SQLServerCentral: Scripts tagged miscellaneous

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><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>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Scripts with tag miscellaneous

Search for any content tagged miscellaneous

Add a script

<< Previous 20 Items 21 to 40 of 834 Next 20 >>

Show all database's tables' columns' collations.

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

By Rafal Skotak 2008/04/04 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Briefcase | 1,490 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 Skotak 2008/04/01 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Briefcase | 1,080 reads

Generating permutations

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

By Rafal Skotak 2008/02/27 | Category: miscellaneous

Rating:

|

Briefcase | 964 reads

Effectively mapping primary key – foreign key relations

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

By John Liu 2012/05/15 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Briefcase | 2,706 reads

Collation Checker Version 2

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

By paul_richardson 2007/12/27 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Briefcase | 915 reads

Find Parent Child RelationShip

By Jorge Novo-@ETLDEVDBA 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 895 reads

Script to find text in stored procedures

By Doug Elwood 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 1,764 reads

Combine multiple rows into single output

By Mohit Nayyar 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 3,486 reads

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

By R. van Laake 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 659 reads

finding the blocks in sql server

By Paarthasarathy 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 3,449 reads

Welcome To the World of ANSI compliant Occult :)

By ARIJIT RAHUT 2007/11/12 | Category: miscellaneous

Rating:

|

Briefcase | 575 reads

This SP will be create C# classes using all table

By Satyanarayana B 2007/11/13 | Category: miscellaneous

Rating:

|

Briefcase | 2,450 reads

sp_displaylogin - sybase style

By paul_richardson 2007/11/09 | Category: miscellaneous

Rating:

|

Briefcase | 828 reads

Get all user def table info

Get space for all user defined table information like size and row counts. Read more...

By Mohit Nayyar 2011/06/06 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Briefcase | 6,739 reads

Get the list of permissions of database object

List permissions for an object in various ways. Read more...

By Deepthi Viswanathan Nair 2011/05/24 | Source: SQLServerCentral.com | Category: miscellaneous

Rating:

|

Briefcase | 13,237 reads

Delete Duplicates using CTE

By stumbling fish 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 981 reads

Display disk space stats for each table

By Andrew Greenall 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 942 reads

Get Record Count for each table in a database.

By Hari Sharma 2013/05/19 | Category: miscellaneous

Rating:

|

Briefcase | 1,367 reads

Table row count using 3 different ways

Three different ways that you can get the count of the rows in a table. Read more...

By Mohit Nayyar 2011/06/16 | Category: miscellaneous

Rating:

|

Briefcase | 6,354 reads

Locate primary key - foreign key relations

By Mohit Nayyar 2011/09/14 | Category: miscellaneous

Rating:

|

Briefcase | 2,660 reads

<< Previous 20 Items 21 to 40 of 834 Next 20 >>