SQLServerCentral: Scripts tagged Advanced Querying, T-SQL

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas. Read more...

By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: admin

Rating:

|

Discuss |

Briefcase | 1,121 reads

Prime Number Table Generator (new ver crunches to 1 Mil in <10.5 sec!)

Generates prime numbers and puts them into a table for future reference by adhoc queries and database and application code. 100% set-based. DDL embedded. Read more...

By Jesse Roberge 2009/07/15 | Source: SQLServerCentral.com | Category: advanced querying

Rating:

|

Discuss |

Briefcase | 927 reads

Comparing Stored Procedures, Part 6

Sixth in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures Read more...

By Jesse McLain 2009/04/15 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,071 reads

Delimited String Parsing Functions - TwoCol set

Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order. Read more...

By Jesse Roberge 2008/11/03 | Source: SQLServerCentral.com | Category: t-sql aids

Rating:

|

Discuss |

Briefcase | 1,832 reads

Delimited String Parsing Functions - Big2D set

Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema. Read more...

By Jesse Roberge 2008/10/22 | Source: SQLServerCentral.com | Category: t-sql aids

Rating:

|

Discuss |

Briefcase | 864 reads

Delimited String Parsing Functions - 2D set

Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema. Read more...

By Jesse Roberge 2008/10/14 | Source: SQLServerCentral.com | Category: t-sql aids

Rating:

|

Discuss |

Briefcase | 906 reads

Delimited String Parsing Functions - Big Set

Feed it large strings of delimited horizontal data and it returns it back as a vertical table. Read more...

By Jesse Roberge | Source: SQLServerCentral.com | Category: t-sql aids

Rating:

|

Discuss |

Briefcase | 738 reads

Delimited String Parsing Functions - Basic Set

Feed it delimited horizontal data and it returns it back as a vertical table. Read more...

By Jesse Roberge 2008/10/20 | Source: SQLServerCentral.com | Category: t-sql aids

Rating:

|

Discuss |

Briefcase | 2,205 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers. Read more...

By Jesse Roberge | Source: SQLServerCentral.com | Category: t-sql aids

Rating: (not yet rated) |

Discuss |

Briefcase | 762 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers. Read more...

By Jesse Roberge | Source: SQLServerCentral.com | Category: t-sql aids

Rating: (not yet rated) |

Discuss |

Briefcase | 392 reads