What is a SQL Server Data Dictionary? - CodeProject
Aug 14, 2019 · What is a Data Dictionary? In SQL Server, the data dictionary is a set of database tables used to store information about a database’s definition.& The dictionary contains information about …
How Do I: Use SQL File Stream - CodeProject
Nov 18, 2010 · An end to end article describing how to use file stream data type in SQL Server. This article discusses both SQL Server and .NET side of things.
Excel Macro to Generate Database Insert Script - CodeProject
Jul 13, 2019 · Download sample-old - 20.3 KB Download sample - 25.9 KB Introduction For developers, one time adding/editing master or static data in database has always become a pain as it needs the …
Passing NULL and table values to a parametrized SQL query
Jun 4, 2013 · Introduction This tip demonstrates how to create a universal method to pass null and table values to dynamic, but parametrized SQL queries, without a need to create any special types on the …
Generating Insert or Update statements from table data ... - CodeProject
Oct 3, 2006 · Writing a SQL script to generate insert or update scripts for a table full of data.
Building Dynamic SQL In a Stored Procedure - CodeProject
Oct 9, 2007 · Download source - 1.56 KB Introduction A dynamic SQL in a stored procedure is a single Transact-SQL statement or a set of statements stored in a variable and executed using a SQL …