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 …
Install and Configure SQL Server Reporting Services (SSRS)
Oct 30, 2021 · Step 4 Next click on the Web Service URL tab from the left panel. Here, you can configure the report server URL. We will use this URL to deploy SSRS reports on the report …
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.
Using temporary tables with LINQ-To-SQL (L2SQL) - CodeProject
Sep 6, 2017 · Download source - 46.6 KB Introduction Have you ever had the desire to use a temporary SQL table using LINQ-To-SQL and found that there was no direct support built in …
MsSql.RestApi - The Easiest Way to Build the ASP.NET REST API
Nov 5, 2018 · MsSql.RestApi is a library that can help you to speed-up the process of building powerful REST API with the minimal amount of code. In this article, you will see something …
Passing NULL and table values to a parametrized SQL query
The importance of using parameterized SQL queries has been well established, but passing table values or occassional NULL values has always been a problem ... u
Generating Insert or Update statements from table data
Oct 3, 2006 · Writing a SQL script to generate insert or update scripts for a table full of data.