Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag t-sql Rss

Search for any content tagged t-sql

<< Newer    Items 41 to 60 of 1121    Older >>
 

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2013/10/28 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 15,777 reads

Using a column name in a COUNT function

Putting a column name in a COUNT() function may not always give you what you are looking for.  Read more...
By Charles Kincaid 2013/10/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,580 reads

Removing Duplicates

How to remove identify and remove duplicate data from your tables  Read more...
By Stefan Krzywicki 2013/10/08 | Source: SQLServerCentral.com | Category: duplicate data
Rating: |  Discuss |   Briefcase | 15,585 reads

Simple way to create a SQL Server Job Using T-SQL

Sometimes we have a T-SQL process that we need to run that takes some time to run or we want to run it during idle time on the server. We could create a SQL Agent job manually, but is there any simple way to create a scheduled job?  Read more...
By Additional Articles 2013/10/08 | Source: MSSQLTips.com | Category: sql agent jobs
Rating:  Rate this |   Briefcase | 4,498 reads

Group Islands of Contiguous Dates (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to quickly group ranges of contiguous dates without RBAR.  Read more...
By Jeff Moden 2013/10/04 (first published: 2010/12/07) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,579 reads

A Hazard of Using the SQL Update Statement

If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.  Read more...
By Dwain Camps 2013/09/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,949 reads

Common table expressions and circular references

Finding circular references that are stopping your CTE from working.  Read more...
By Geoff Norman 2013/09/02 (first published: 2011/01/31) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 15,863 reads

Displaying Sorted Hierarchies (SQL Spackle)

Learn how you can query a hierarchy of data and also return the results in an ordered fashion. A handy T-SQL skill that you will use over and over again.  Read more...
By Jeff Moden 2013/08/23 (first published: 2011/03/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,379 reads

How to Compile, Deploy and Consume a SQL Server CLR Assembly

Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.  Read more...
By Stan Kulp 2013/08/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,858 reads

Sorting Months By Number (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.  Read more...
By Jeff Moden 2013/08/02 (first published: 2010/11/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 17,860 reads

Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)

Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.  Read more...
By Brandie Tarvin 2013/08/01 | Source: SQLServerCentral.com | Category: generate scripts
Rating: |  Discuss |   Briefcase | 3,145 reads

Survey: Understanding SQL Code

Understanding thousands of lines of code of an existing database is very time-consuming and tedious, prone to inadvertent oversight of key logic points. We are looking at advanced ways to provide greater insight into your code base while reducing the numerous demands placed on the developer. Please help us by completing this short survey to help us define the requirements.  Read more...
By Additional Articles 2013/07/23 | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 4,491 reads

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2013/07/09 | Source: SQLServerCentral.com | Category: recursive cte
Rating: |  Discuss |   Briefcase | 10,514 reads

A simple trick for “Block Comment” syntax in SSMS

Make your comment blocks much more useful, in a surprising number of ways  Read more...
By Peter Zerk 2013/07/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 9,710 reads

Display More Than 8000 Characters (SQL Spackle)

SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).  Read more...
By Jeff Moden 2013/06/28 (first published: 2011/01/27) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,654 reads

Understanding T-SQL Expression Short-Circuiting

Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.   Read more...
By Gianluca Sartori 2013/06/21 (first published: 2010/12/30) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,240 reads

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS.  Read more...
By Steve Moore 2013/06/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,861 reads

Custom Sequence Numbering

This article shows how to implement low cost custom sequence numbering logic via a cunning use of the the ROW_NUMBER() function  Read more...
By James Skipwith 2013/06/14 (first published: 2011/02/07) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,382 reads

Paging Data with TSQL

Greg 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.  Read more...
By Additional Articles 2013/06/05 | Source: Database Journal | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,446 reads

Paging Data with T-SQL

Greg 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.  Read more...
By Additional Articles 2013/05/22 | Source: Database Journal | Category: paging data
Rating:  Rate this |   Briefcase | 4,886 reads
<< Newer    Items 41 to 60 of 1121    Older >>