This is a very simple and small stored procedure which will help you identify repeated rows on any given table. This is specially useful for situations when you want to clean up a table and add a primary key on it, but you cannot until all duplication is eliminated. Only two parameter are necessary; table […]
2002-07-08
1,080 reads
Deletes the duplicates from a table based upon any fields in the table leaving a single copy of the record in the table.
2002-07-04
922 reads
This script allows you to dynamically alter all the tables in your database. In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)
2002-07-04
747 reads
Returns the key fields of all duplicate rows in a table based upon any fields in the table.
2002-07-04
739 reads
Returns an ordered column listing for the specified table, stored procedure, or view.
2002-07-04
471 reads
Generates a rowset with a datetime values for every day between a start datetime and end datetime.
2002-07-04
629 reads
2002-07-04
678 reads
This script returns the index locking strategy informationfor all user tables in a database. It also generates the required TSQL statement to alter locking strategies if required. These statements require CTRL-C and CTRL-V individually into query analyser for execution. Results are best viewed in text only. This TSQL can be wrapped in a stored procedure […]
2002-07-04
1,383 reads
Generates a VB6/ADO procedure prototype, procedure call, and ADO Command Object Parameters.Append calls. To use, simply set the @spname variable equal to the name of your stored procedure, run, and cut and paste the output into you VB program. The generated code may require some slight modifications, but this should save you a lot of […]
2002-07-04
1,055 reads
This script search the active database for the stringyou're looking for.It searhes with in Table Names, Table Columns, Views, SP's, Triggers, Indexes and System Tables.Enjoy it ...
2002-07-03
504 reads
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Hi I am trying to assign the value of the variable using the output...
Comments posted to this topic are about the item Merry Christmas 2025
Comments posted to this topic are about the item The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers