<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tags
SQL Server 2005
,
Miscellaneous
Refine your search with one of the following additional tags (with number of items):
SQL Server 2000
(2)
games
(1)
Puzzle
(1)
T-SQL
(2)
Management
(1)
T-SQL Aids
(1)
Advanced Querying
(1)
Search for
any
content tagged
SQL Server 2005 & Miscellaneous
Add a script
Items 1 to 10 of 10
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
|
912 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
|
1,003 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
|
2,212 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
|
604 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,410 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
|
972 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
|
442 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
|
703 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
|
335 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
|
557 reads
Items 1 to 10 of 10
Most popular
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
|
2,212 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
|
912 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
|
1,003 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
