SQLServerCentral.com Content tagged T-SQLhttp://www.sqlservercentral.com/Content tagged T-SQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Stairway to T-SQL DMLThis Stairway will provide you with a basic understanding of how to work with data from SQL Server tables, using SQL Server’s Transact-SQL (T-SQL) dialect. DML is the Data Manipulation Language, and is the aspect of the language dealing with the data. It includes the statements SELECT, INSERT, UPDATE and DELETE. This Stairway will as also provide some history of the SQL language and some general concepts about set theory. Each level will build upon the prior level, so by the time you are finished you will have a good understanding of how to select and modify data from SQL Server.

]]>http://www.sqlservercentral.com/stairway/75773/Tue, 30 Aug 2011 13:22:01 UThttp://www.sqlservercentral.com/stairway/75773/Temp Tables

]]>http://www.sqlservercentral.com/questions/T-SQL/98866/Fri, 24 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98866/REPLICATE

]]>http://www.sqlservercentral.com/questions/T-SQL/98878/Thu, 23 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98878/The many uses of CROSS APPLYOver the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY. In the first...

]]>http://www.sqlservercentral.com/blogs/sqlstudies/2013/05/20/the-many-uses-of-cross-apply/Thu, 23 May 2013 06:00:00 UThttp://www.sqlservercentral.com/blogs/sqlstudies/2013/05/20/the-many-uses-of-cross-apply/Object QualificationI came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...

]]>http://www.sqlservercentral.com/blogs/sqlserver365/2013/05/15/object-qualification/Wed, 22 May 2013 06:00:00 UThttp://www.sqlservercentral.com/blogs/sqlserver365/2013/05/15/object-qualification/Paging Data with T-SQLGreg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.

]]>http://www.sqlservercentral.com/redirect/articles/99194/Wed, 22 May 2013 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/99194/CHARINDEX()

]]>http://www.sqlservercentral.com/questions/charindex/99043/Tue, 21 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/charindex/99043/EXCEPT - 1

]]>http://www.sqlservercentral.com/questions/EXCEPT/98568/Mon, 20 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/EXCEPT/98568/INSERT

]]>http://www.sqlservercentral.com/questions/T-SQL/98942/Fri, 17 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98942/Assigning categories to values 2

]]>http://www.sqlservercentral.com/questions/T-SQL/98548/Wed, 15 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98548/Assigning categories to values 1

]]>http://www.sqlservercentral.com/questions/T-SQL/98547/Tue, 14 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98547/INTO Identities

]]>http://www.sqlservercentral.com/questions/T-SQL/98651/Mon, 13 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98651/Data Type

]]>http://www.sqlservercentral.com/questions/NULL/98486/Fri, 10 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/NULL/98486/The Subquery

]]>http://www.sqlservercentral.com/questions/Subquery/98200/Thu, 09 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/Subquery/98200/Nested triggers 2

]]>http://www.sqlservercentral.com/questions/T-SQL/98456/Wed, 08 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98456/Comparing an inner join vs a subqueryI was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...

]]>http://www.sqlservercentral.com/blogs/sqlstudies/2013/05/03/comparing-an-inner-join-vs-a-subquery/Wed, 08 May 2013 06:00:00 UThttp://www.sqlservercentral.com/blogs/sqlstudies/2013/05/03/comparing-an-inner-join-vs-a-subquery/Distinct

]]>http://www.sqlservercentral.com/questions/T-SQL/98441/Tue, 07 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98441/Timestamps

]]>http://www.sqlservercentral.com/questions/T-SQL/98433/Mon, 06 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98433/Identity Insert

]]>http://www.sqlservercentral.com/questions/T-SQL/98397/Fri, 03 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98397/Table Alias

]]>http://www.sqlservercentral.com/questions/T-SQL/98396/Thu, 02 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98396/REPLICATE - 1

]]>http://www.sqlservercentral.com/questions/T-SQL/98349/Wed, 01 May 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98349/Table Variable

]]>http://www.sqlservercentral.com/questions/T-SQL/98318/Tue, 30 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98318/QUERY and TABLE HINTS

]]>http://www.sqlservercentral.com/questions/T-SQL/98313/Mon, 29 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98313/Create Table

]]>http://www.sqlservercentral.com/questions/T-SQL/98299/Fri, 26 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98299/Triggers 2

]]>http://www.sqlservercentral.com/questions/Triggers/98253/Thu, 25 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/Triggers/98253/Solving Complex T-SQL Problems, Step-By-StepWhat should you do if your first, most intuitive solution to a problem ends up scanning the data more than is necessary, resulting in poor performance? Have you missed a new SQL Server feature that can remove inefficiency from your technique? Alternatively, do you need a little help, and some lateral thinking, to open the path to a different approach? Sometimes, the answer is "both".

]]>http://www.sqlservercentral.com/redirect/articles/98163/Thu, 25 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/98163/FK to IDENTITY

]]>http://www.sqlservercentral.com/questions/Foreign+Keys+(FK)/98294/Wed, 24 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/Foreign+Keys+(FK)/98294/Nested triggers 1

]]>http://www.sqlservercentral.com/questions/Triggers/98282/Tue, 23 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/Triggers/98282/Using FULL JOINs to Compare DatasetsThis article describes a technique of using FULL JOINs to compare two datasets within a numerical tolerance.

]]>http://www.sqlservercentral.com/articles/FULL+JOIN/71136/Tue, 23 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/articles/FULL+JOIN/71136/Handling NULL

]]>http://www.sqlservercentral.com/questions/T-SQL/98251/Mon, 22 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/questions/T-SQL/98251/