SQL Server learning related data collation "turn"

Stored procedures:

SQL Server Stored Procedures Blog Park on an article, explained in very detailed, there are test code, very practical.

Execute dynamic SQL statements in SQL Server stored procedures The curse and blessings of the dynamically SQL

stored procedures and Cursors learning notes Blog Park, very basic, very meticulous, good article.

T_sql statement:

SQL Server query implementation across servers details how to implement cross-server additions and deletions.

SQL Server transactions include how to write in SQL statements and write transactions in C #, without

SQL Server field type detailed The data fields in SQL Server are described in detail. tinyint, smallint, int, bigint in SQL Server and 10 binary conversion 16 binary method

sysobjects in SQL Server. Xtype Query whether there are data tables and some system expression reasons, etc., very detailed. SQL Server System tables detailed description

The key to determining whether a table or temporary table exists in SQL Server is how the temporal table is judged to exist. [SQL] SQL Server determines whether an object exists (organized ... It's better to do it yourself.

field conversions for time types in SQL Server Time Class self-field

Flexible use of SQL SERVER for XML PATH aggregation column to row. For example, set the week settings to show 2,3,4,5,6,7

Learning, accumulation, persistence, freedom (individual independent blog, welcome to subscribe http://www.ixirong.com)

SQL Server learning related data collation "turn"