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 …
Inserting JSON Text into SQL Server Table - CodeProject
Learn how to insert JSON objects into SQL Server 2016 tables effectively and easily.
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 …
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, …
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 …
Create Primary Key using Entity Framework Code First
Sep 5, 2014 · Sometimes, Code First fails to drop the database and generates an exception as follows. It generally happens if some process is using the SQL Server database and during …
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 …
Data Dictionary in C#.NET - CodeProject
Sep 23, 2016 · Another thing might be to populate a combo box to load all the SQL server instances in the network (System.Data.Sql.SqlDataSourceEnumerator), and choosing the …
Documenting MS SQL Server Databases - CodeProject
The examples of SQL Server database documentation using both the extended properties and a third-party utility.