SQLServerCentral.com Scripts tagged Miscellaneous

BCP Format File Builder

Fri, 14 Aug 2009 06:00:00 UT

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.

Find SQL Server Install Date

Fri, 07 May 2010 06:00:00 UT

Script to find the SQL Server Instance Install Date

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

Wed, 15 Jul 2009 06:00:00 UT

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.

Find SQL Server TCP/IP Port Number

Thu, 13 May 2010 06:00:00 UT

Script to find the TCP/IP Port number of SQL Instance

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

Function to Add Leading 0's (Zeros) to an INT

Thu, 05 Mar 2009 07:00:00 UT

Very simple function code to add leading zeros to a passed in int for a length also passed.

Function to Return Date and Time String for File Archiving

Wed, 18 Feb 2009 07:00:00 UT

This function will return a string in sortable format YYYYMMDD-hhmmssnnn to append to file names for archiving.

Find Text in all columns of all tables in a Database

Thu, 31 Mar 2011 06:00:00 UT

Will find the Table Name, Column Name and the number of occurances some text appears in a database.

Search All SQL Script Objects in All Databases for Text

Thu, 19 Feb 2009 07:00:00 UT

Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.

Yet Another Deleting Duplicate Records (in-place)

Thu, 15 Jan 2009 07:00:00 UT

Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.

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

Wed, 06 Aug 2008 02:57:05 UT

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

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

Wed, 06 Aug 2008 02:50:45 UT

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

Proc to Rename a file

Fri, 28 Oct 2011 06:00:00 UT

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.

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

Wed, 21 Dec 2011 07:00:00 UT

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

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

Wed, 25 May 2011 06:00:00 UT

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).

Select from stored procedure

Wed, 14 Dec 2011 07:00:00 UT

This terse script shows an easy (but "dirty" - so not advisable for production environments - rather for personal use) way to select data from stored procedure.

Generating number sequences with Common Table Expressions

Tue, 04 Oct 2011 06:00:00 UT

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

Generating permutations - procedure

Tue, 18 Mar 2008 06:00:00 UT

This procedure prepares a query for generating permutations of n-numbers set and executes it.

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

Fri, 09 Dec 2011 07:00:00 UT

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

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

Thu, 06 Mar 2008 07:00:00 UT

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

Sorted views in 2005 and TOP clause

Fri, 22 Feb 2008 07:00:00 UT

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

Show all database's tables' columns' collations.

Fri, 04 Apr 2008 06:00:00 UT

Created view displays all text columns' collations in the current database with the information whether the collation is different from the database's one.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

Generating combinations 'm elements from n-element set'

Tue, 01 Apr 2008 06:00:00 UT

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

Generating permutations

Wed, 27 Feb 2008 07:00:00 UT

This script shows one on ways of generating permutations.

Effectively mapping primary key – foreign key relations

Tue, 15 May 2012 06:00:00 UT

This script maps the primary key - foreign key relations regardless if the column names are the same or not.

Collation Checker Version 2

Thu, 27 Dec 2007 07:00:00 UT

this version 2 of my sproc to do various collation checks.

Find Parent Child RelationShip

Tue, 18 Sep 2007 18:40:54 UT

Script to find text in stored procedures

Sat, 15 Sep 2007 04:18:10 UT

Combine multiple rows into single output

Fri, 14 Sep 2007 18:58:22 UT

LSTR() and RSTR(): Enhanced LEFT() and RIGHT()

Thu, 13 Sep 2007 07:33:20 UT

finding the blocks in sql server

Sun, 09 Sep 2007 11:07:40 UT