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

   Items 1 to 20 of 1154    Older >>
 

Questions About T-SQL Transaction Isolation Levels You Were Too Shy to Ask

Every time you access a relational database to make a query, you have an important decision to make: What is the appropriate isolation level for your query? If you get this wrong, the consequences can be serious. Deadlocks, Dirty reads, Non-repeatable reads, or poor performance. We're in luck, because Robert Sheldon once more answers those questions that are awkward to ask in public.  Read more...
By Additional Articles 2014/12/18 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,782 reads

Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

The first installment of this new stairway series will be discuss the CROSS JOIN operator. This stairway should help readers prepare for passing the Microsoft Certification exam 70-461: Querying Microsoft SQL Server 2012.  Read more...
By Gregory Larsen 2014/12/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,433 reads

The SQL Scrabble Puzzle

An enhancement to a Phil Factor puzzle gives you a chance to play scrabble in T-SQL.  Read more...
By Additional Articles 2014/12/05 | Source: Other | Category: contest
Rating:  Rate this |   Briefcase | 6,310 reads

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2014/11/28 (first published: 2012/12/06) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 14,777 reads

Real World T-SQL Tricks

This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.  Read more...
By Steve Jones 2014/11/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 537 reads

Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask

It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.  Read more...
By Additional Articles 2014/11/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 8,997 reads

Exploring Your SQL Server Databases with T-SQL

Scott Swanberg shares 38 scripts he uses time and time again for discovering more about database objects.  Read more...
By Additional Articles 2014/10/21 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 9,768 reads

Filling In Missing Values Using the T-SQL Window Frame

Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update' tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the 'Data Smear'. Do window functions make this easier, and what is performance like? Dwain Camps investigates.  Read more...
By Additional Articles 2014/10/01 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 9,688 reads

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".  Read more...
By Jeff Moden 2014/09/19 (first published: 2012/11/13) | Source: SQLServerCentral.com | Category: hierarchy
Rating: |  Discuss |   Briefcase | 15,443 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 18,474 reads

New toys in SQL Server 2012

In this article we are going to look two new enhancements: the Insert snippet menu option and the surround with option.  Read more...
By Daniel Calbimonte 2014/09/01 (first published: 2012/05/15) | Source: SQLServerCentral.com | Category: insert
Rating: |  Discuss |   Briefcase | 18,195 reads

Questions about T-SQL Expressions You Were Too Shy to Ask

Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?  Read more...
By Additional Articles 2014/08/27 | Source: SimpleTalk | Category: expressions
Rating: (not yet rated)  Rate this |   Briefcase | 11,147 reads

Stairway to T-SQL DML Level 12: Using the MERGE Statement

The final level of this stairway looks at the MERGE statement in detail, focusing on how to perform insert, update and delete logic using the MERGE statement.  Read more...
By Gregory Larsen 2014/08/20 (first published: 2013/01/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 17,057 reads

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 9,554 reads

How to Handle Calculations Related to fiscal year and quarter

This article describes an easy way to handle calculation based on fiscal year and quarter  Read more...
By Raymond Xie 2014/07/28 | Source: SQLServerCentral.com | Category: fiscal year
Rating: |  Discuss |   Briefcase | 5,807 reads

Exploring Recursive CTEs by Example

Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.  Read more...
By Dwain Camps 2014/07/25 (first published: 2012/07/17) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 20,999 reads

Stairway to T-SQL: Beyond The Basics Level 9: Dynamic T-SQL Code

There times when you need to write T-SQL code that creates specific T-SQL Code and executes it. When you do this you are creating dynamic T-SQL code. When writing dynamic T-SQL you need to understand how dynamic code opens the possibilities for a SQL injection attack.  Read more...
By Gregory Larsen 2014/07/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 7,066 reads

Calculating and Verifying Check Digits in T-SQL

A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes we must check that the code is valid- but do we? Dwain Camps shows how it can be done in SQL in such a way that it could even be used in a constraint, and keep bad data out of the database.  Read more...
By Additional Articles 2014/07/23 | Source: SimpleTalk | Category: calculation
Rating: (not yet rated)  Rate this |   Briefcase | 11,242 reads

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2014/07/17 | Source: SQLServerCentral.com | Category: rows to columns
Rating: |  Discuss |   Briefcase | 14,356 reads

Single Quotation Marks in SQL

One of the common problems is dealing with apostrophes in T-SQL. This article examines the challenges of single quotation marks and ends with a short quiz.  Read more...
By Kenneth Fisher 2014/07/11 (first published: 2013/01/03) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,837 reads
   Items 1 to 20 of 1154    Older >>