|
- SQL Table Dependency Diagram Generator (SSMS 18,19 20)
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server
- What is a SQL Server Data Dictionary? - CodeProject
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 database objects such as tables, indexes, columns, datatypes, and views The data dictionary is used by SQL server to execute queries and is automatically updated whenever objects are added, removed, or
- SqlTimeSpan - CodeProject
[Serializable] [SqlUserDefinedType(Format UserDefined, MaxByteSize = 9, IsByteOrdered = true, IsFixedLength = false)] public struct SqlTimeSpan : INullable, IBinarySerialize { #region Mandatory Members internal System TimeSpan SystemTimeSpan; public override string ToString() { return SystemTimeSpan ToString(); } public static SqlTimeSpan Parse(SqlString input) { SqlTimeSpan udt = new
- Build Configurations for Publishing SQL Server Database Projects
Download demo - 320 KB Abstract There are multiple ways to develop and deploy a SQL Server database in Visual Studio SQL Server Database Projects is one of them It is sometimes faster to use SQL Server Data Projects for small projects versus handwritten migration scripts However, these projects do not work with Visual Studio Build configurations (VS 2017 15 3 0) In this document, we
- All you wanted to know about Satellite Assemblies (C# . Net)
Download TestSatelliteAssembly zip - 12 KB Introduction This article details out all the basics that you must understand and know about satellite assemblies before you go ahead and use it in your project The article expects the reader to have a prior knowledge of using Visual Studio editor for C# language Background In today's era we all create applications which target multitude of
- PostgreSQL-ADO. NET Framework - CodeProject
Download solution - 2 5 MB Introduction The simple application that shows how to connect the ADO NET Framework to the PostgreSQL The source code is based on the N-Tier pattern and uses EntityFramework6 Npgsql and Npgsql NuGet packages Background PostgreSQL, unlike MS SQL Server, is completely free It also has the ability to connect NET applications via Entity Framework and some other
- Building Dynamic SQL In a Stored Procedure - CodeProject
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 command There may be several methods of implementing this in SQL Server This article will show you a good method of doing this Before getting into a detailed explanation, let me tell "When to Use Dynamic SQL?" We
- Visual Representation of SQL Joins - CodeProject
This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins
|
|
|