Stored procedure that return range of data from any table without using temp table or cursors. You don't even need to use the IDENTITY field in your target table. Check out and comments are welcomed
2003-10-27
282 reads
Provides a method to regularly recycle the sql server error logs based on a given file size. If the current log file is larger than that size, then the current log is closed and a new log created.This proc takes one parameter, @MaxFileSize, which is the target file size. This parameter defaults to 10 MB. […]
2003-10-27
916 reads
It creates documentation for all user tables in a specific database. A server name/ database name was added on the top of the HTML file also a column datatype field was added to the HTML file. Now the @strHTML can have 8000 chars, before only 4000 - still for tables with a lot of columns […]
2003-10-27
646 reads
Sound like old hat ... but this procedure accepts the two database names as input parameters; therefore, it must dynamically generate the SQL and use Exec(@command) to execute it. It also reports on tables that exist in one database but not the other ... Finally, it uses count(*) to provide more accuracy than using sysindex […]
2003-10-24
279 reads
This function lists the column name and column id for primary key columns for a given table.
2003-10-24
1,522 reads
This script converts string-based IP addresses to their numeric equivalents so that it is easy to do arithmatic on them such as find an IP address that is within a range.NOTE: This function calls the split function which is included in the post.
2003-10-20
1,434 reads
Are you managing big databases with a lot of tables like SAP as I'm?Do you use sp_spaceused, as I'm?Do you want to know your n biggest tables as I'm?Then don't search any longer.I'm using this script every day for may maintenance jobs.I generates, like sp_spaceused, out of sysindexes the n biggest tables without any cursor, […]
2003-10-20
301 reads
I routinely need to retrieve and package query result sets in an XML package. The built in functions supported by SQL Server 2000 are effective, but are often more of a pain than a help. This routine can be used in a simple select statement to XML encode the contents of a column during the […]
2003-10-14
236 reads
2003-10-10
77 reads
Calculates the factorials of numbers between 1 - 31.High level is 31 because maximum stored procedure, function, trigger, or view nesting level is limited to 32.
2003-10-08
642 reads
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
This is a quick blog post, mainly so I have the code available if...
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
I've read lots of the horror stories about nested views in databases where they're...
Hello! How do I grant a user to read-write to a single database and...
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers