SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag T-SQL Rss

Search for any content tagged t-sql

   Items 1 to 20 of 1350    Older >>
 

An Overview of STRING_SPLIT()

Learn how to use the STRING_SPLIT() function in T-SQL.  Read more...
By Steve Jones 2018/12/10 | Source: SQLServerCentral.com | Category: string_split()
Rating: |  Discuss |   Briefcase | 1,306 reads

Transferring Data with JSON in SQL Server

JSON is a viable option for transferring data between systems. It has the ability to include schema information along with the data which is an advantage over CSV files. In this article, Phil Factor demonstrates how he takes advantage of JSON when exporting or importing tables.  Read more...
By Additional Articles 2018/12/05 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 2,567 reads

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2018/11/30 (first published: 2016/10/06) | Source: SQLServerCentral.com | Category: fifo queues
Rating: |  Discuss |   Briefcase | 3,810 reads

T-SQL Decommenter Part IV

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.  Read more...
By Toby Ovod-Everett 2018/11/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 465 reads

Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.  Read more...
By Steve Jones 2018/11/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 718 reads

Nasty Fast N-Grams (Part 1): Character-Level Unigrams

An article about tally tables, N-Grams and the fastest character-level N-Grams function available today for SQL Server.  Read more...
By Alan Burstein 2018/11/22 (first published: 2016/06/23) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 3,779 reads

T-SQL Decommenter Part III

Detailed explanation of the recursive section of the T-SQL Decommenter.  Read more...
By Toby Ovod-Everett 2018/11/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 626 reads

T-SQL Decommenter Part II

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.  Read more...
By Toby Ovod-Everett 2018/11/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 807 reads

T-SQL Decommenter Part I

Introduction to a T-SQL query that remove comments from T-SQL code  Read more...
By Toby Ovod-Everett 2018/11/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,560 reads

Simple way to Import XML Data into SQL Server with T-SQL

In this tip we look at a simple way to import a simple XML document into a SQL Server table.  Read more...
By Additional Articles 2018/11/07 | Source: MSSQLTips.com | Category: xml datasource
Rating:  Rate this |   Briefcase | 2,976 reads

Compress and Decompress in SQL Server 2016

Explore using Compress/Decompress with varying types of data and examine size/storage usage  Read more...
By David Fundakowski 2018/10/01 | Source: SQLServerCentral.com | Category: compress()
Rating: |  Discuss |   Briefcase | 826 reads

Renaming a Schema in SQL Server

If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.  Read more...
By Steve Jones 2018/09/25 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 864 reads

TRY_PARSE

Introducing the PARSE function, brought to us in SQL Server 2012.  Read more...
By Matthew McGiffen 2018/09/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,632 reads

What is the impact of setting SET ANSI_WARNINGS OFF?

Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.  Read more...
By Nakul Vachhrajani 2018/09/11 (first published: 2016/08/23) | Source: SQLServerCentral.com | Category: set options
Rating: |  Discuss |   Briefcase | 4,332 reads

Creating Subtotals and Totals in Aggregated Queries

Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how.  Read more...
Rating: |  Discuss |   Briefcase | 1,752 reads

Displaying Hierarchical Data

Producing hierarchies from SQL tables can necessitate joining a table to itself. This article will explain how you can do this.  Read more...
By Adam Aspin 2018/08/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,583 reads

Count the Number of Weekend Days between Two Dates

Handling weekends can be tricky in SQL. This article shows you how to Count the Number of Weekend Days between Two Dates  Read more...
By Adam Aspin 2018/08/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,142 reads

Aggregate Data for the Last Day of the Month

On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.  Read more...
By Adam Aspin 2018/08/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,199 reads

Rounding Tips and Tricks

This article shows different options to use the rounding functions in SQL Server.  Read more...
By Luis Cazares 2018/08/10 (first published: 2016/09/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,179 reads

Using a CTE as a Tally Table

Sometimes you need to output blank lines - in effect displaying Records for Missing Data. This article explains how to use a CTE to do this  Read more...
By Adam Aspin 2018/08/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,932 reads
   Items 1 to 20 of 1350    Older >>