SQLServerCentral: Scripts tagged T-SQL, T-SQL Aids, Miscellaneous

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

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

Proc to Rename a file

A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005. Read more...

By Simon Facer 2008/06/17 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Discuss |

Briefcase | 1,850 reads

Scripts with tags T-SQL, T-SQL Aids, Miscellaneous

Add a script

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

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

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

Proc to Rename a file