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 …
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 …
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 …
POCO Generator - CodeProject
Mar 31, 2015 · Column Defaults - Adds properties initialization, based on the column default values in SQL Server. Default value that can't be handled properly will be commented. New Line Between …
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 …
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 required one, rather …
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 that time, Code …
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 update with a …
Using Custom Attributes to Map Database Tables and ... - CodeProject
Feb 16, 2010 · I also store the column name and the field info for later use. This section finishes up by appending the FROM clause to the SQL statement. Note: Using SELECT * forces your database …