SQL - Pivot with Grand Total Column and Row - CodeProject
Jul 27, 2011 · Introduction Microsoft SQL Server has introduced the PIVOT and UNPIVOT commands as enhancements to T-SQL with the release of Microsoft SQL Server 2005. Pivot Table in SQL has …
Inserting JSON Text into SQL Server Table - CodeProject
Mar 25, 2016 · Introduction SQL Server 2016 and Azure SQL Database have a new function OPENJSON that enables you to easily parse JSON text and insert it into any table. See more details …
Computed Column Specification in SQL Server - CodeProject
Jul 18, 2007 · The user needs to select the column and write in "Computed Column Specification --> Formula". Remember the parameters are the column names, users are not supposed to use '@' …
Customize Entity Framework Core Migration History Table
Aug 3, 2022 · Download source code - 13.9 KB Background Entity Framework Core keeps track of applied migrations by adding logs in a table named __EFMigrationsHistory, and schema dbo. The …
Entity Framework: Storing Complex Properties as JSON Text
Jan 17, 2017 · SQL Server 2016 and Azure SQL Database (I will call them SQL Database in the following sections) enables you to store hybrid data with both relational tables and columns, but also …
Documenting MS SQL Server Databases - CodeProject
Jul 9, 2019 · In this article, we’ll review some examples of SQL Server database documentation using both the extended properties and a third-party utility. How to Document SQL Server Database Using …
How to store and fetch binary data into a file stream column
Jan 3, 2009 · In SQL Server 2008, if a varbinary column is defined to be stored as a file stream, the binary data is stored in a special folder structure, which is managed by the SQL Server engine. The …
Easy Way to Change Collation of All Database Objects in SQL Server
Dec 19, 2011 · Have you encountered a problem where you wanted to change your database collation to default or even just change it to a different type? I guess what you had initially done (like me) was …
Dynamically creating Excel File, ExcelSheets and ... - CodeProject
Dec 20, 2011 · The Goal of this article is to help the users by providing the concept to create a Excel file with unlimited sheets with all the data from the SQL Sever database eliminating the need of SSIS …
Data Dictionary in C#.NET - CodeProject
Sep 23, 2016 · Create a data dictionary for your database tablesIn this method, we use SP_FKEYS which is a built-in Stored Procedure of SQL Server. We pass our table name as a parameter to the …