SQL - Pivot with Grand Total Column and Row - CodeProject
SQL Dynamic Pivots
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 …
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 …
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 …
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, …
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 …
Random Value Per Row in SQL - CodeProject
Jan 9, 2019 · Occasionally, you need to update a table with a random value per row. And thanks to some optimizations SQL Server does, it’s not exactly straight forward. If you just try to …
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 …
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 …
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 …