SQL Server Central: Scripts tagged SQL Server 2005, Miscellaneous

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 | 15 reads

A Sudoku solution with set based T-SQL utilizing binary operators.

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm. Read more...

By Kevin Duan 2008/06/09 | Source: SQLServerCentral.com | Category: T-SQL

Rating:

|

Discuss |

Briefcase | 98 reads

Row count and space used for all tables in database (update)

This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model). Read more...

By Rafal S. 2008/05/02 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 1,228 reads

Generating number sequences with Common Table Expressions

The script shows one of ways generating number sequence - this one uses CTE Read more...

By Rafal S. 2008/03/31 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating: (not yet rated) |

Discuss |

Briefcase | 540 reads

Clear database - delete all records from a database (updated)

The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys'). Read more...

By Rafal S. 2008/04/14 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 1,239 reads

Search for a text in all databases

This procedure searches for a specified text in all (or one selected) databases in all (or selected) tables. Read more...

By Rafal S. 2008/03/12 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 809 reads

Search for a specified GUID (or its part) in all databases (updated)

This procedure searches for the specified GUID (or its part) in all (or selected one) databases Read more...

By Rafal S. 2008/03/06 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 410 reads

Sorted views in 2005 and TOP clause

These examples show how You can circumvent the problem with not working TOP 100 PERCENT and ORDER BY in views. Read more...

By Rafal S. 2008/02/22 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 631 reads

Generating combinations 'm elements from n-element set'

This procedure generates a dataset with combinations of elements_to_select taken from number_of_values element set. It prints also the prepared query. Read more...

By Rafal S. 2008/04/01 | Source: SQLServerCentral.com | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 304 reads

Generating permutations

This script shows one on ways of generating permutations. Read more...

By Rafal S. 2008/02/27 | Category: Miscellaneous

Rating:

|

Discuss |

Briefcase | 495 reads

Scripts with tags SQL Server 2005, Miscellaneous

Add a script

Proc to Rename a file

A Sudoku solution with set based T-SQL utilizing binary operators.

Row count and space used for all tables in database (update)

Generating number sequences with Common Table Expressions

Clear database - delete all records from a database (updated)

Search for a text in all databases

Search for a specified GUID (or its part) in all databases (updated)

Sorted views in 2005 and TOP clause

Generating combinations 'm elements from n-element set'

Generating permutations

Row count and space used for all tables in database (update)

Search for a text in all databases

Search for a specified GUID (or its part) in all databases (updated)

Scripts with tags SQL Server 2005, Miscellaneous

Refine your search with one of the following additional tags (with number of items):