SQL Server Blogs

Post

SQL Server

Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

Blogs

SQL Server Transact Basic to Expert - View Collation Metadata

SQL Server Transact Basic to Expert - View Collation Metadata
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - View Collation Metadata (for database)

SQL Server Transact Basic to Expert - View Collation Metadata (for database)
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Get Collation complete description

SQL Server Transact Basic to Expert - Get Collation complete description
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Add Foreign Key to existing Column

SQL Server Transact Basic to Expert - Add Foreign Key to existing Column
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Add Check constraints to existing table

SQL Server Transact Basic to Expert - Add Check constraints to existing table
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Add Default constraints to existing table

SQL Server Transact Basic to Expert - Add Default constraints to existing table
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Dropping Constraint from a table

SQL Server Transact Basic to Expert - Dropping Constraint from a table
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Create a temporary table

SQL Server Transact Basic to Expert - Create a temporary table
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Create a table variable

SQL Server Transact Basic to Expert - Create a table variable
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Inserting value in temporary table

SQL Server Transact Basic to Expert - Inserting value in temporary table
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Inserting value in tablevariable

SQL Server Transact Basic to Expert - Inserting value in tablevariable
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Query a temporary and a table variable tables

SQL Server Transact Basic to Expert - Query a temporary and a table variable tables
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Partitioning data using Partition Function

SQL Server Transact Basic to Expert - Partitioning data using Partition Function
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Get location of data in the partition

SQL Server Transact Basic to Expert - Get location of data in the partition
Karthikeyan Anbarasan Jun 07, 2011
SQL Server Transact Basic to Expert - Alter an existing partition

SQL Server Transact Basic to Expert - Alter an existing partition
Karthikeyan Anbarasan Jun 07, 2011
SQL Server: Create, Alter and Drop an Assembly.

Here is the syntax for creating, Altering and Droping an Assembly in SQL Server:
Nipun Tomar Jun 07, 2011
Scalar User Defined Function in Sql Server

A Scalar user-defined function returns one of the scalar data types
Sandeep Shekhawat Jun 04, 2011
COMMIT and ROLLBACK in Sql Server

SQL provides many transaction management features. SQL commands COMMIT, ROLLBACK and SAVEPOINT helps in managing the transaction.
Sandeep Shekhawat Jun 02, 2011
How to find Table relationship in SQL SERVER 2005 / 2008

Using this T-SQL you can easily find the Table relationship just passing Table Name
Gohil Jayendrasinh Jun 01, 2011
Never use prefix “sp_” in the stored procedure name in the sqlserver Database

In this blog I will give you the reason.
Shirsendu Nandi May 26, 2011

1021 - 1040 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Front-end