Getting "Subquery returned more than 1 value" error on cursors. Changed the following in a couple of places and it runs now. systypes.[name], --(SELECT systypes.[name] FROM systypes WHERE xtype = syscolumns.xtype), Mny thanks to whomever wrote the script. Saved me a bunch of effort."This script will document tables (including constraints and triggers, row counts, sizes […]
2005-10-19 (first published: 2005-10-07)
602 reads
This SQL script returns a recordset with all the index information for all tables within a database
2005-10-18 (first published: 2005-10-07)
879 reads
Use this script as part of your data warehouse projects. I created this script based on previous postings of the Date/Time Dimension. I wanted a dimension that does hours, minutes and seconds. Includes military and standard hours.
2005-10-13 (first published: 2005-10-11)
5,316 reads
SP_SQLSMTPMail is an OLE automation implementation of the CDOSYS dll for Windows 2000 which utilizes a network SMTP server rather than an Exchange server/Outlook client. The stored procedure functions similar to xp_sendmail including the ability to run a query and attach the results. No MAPI profile is required. It is also a working, detailed example […]
2005-10-12 (first published: 2002-10-08)
3,811 reads
This scripts adds the users to the specified Windows NT Group.This will be helpful if we want to give the access to group of users to a sql server, which is runing with Windows Authentication. Create a NT group and give the access on SQL and run this script it adds the user into the […]
2005-10-10 (first published: 2005-09-15)
504 reads
I took the script from the email you sent me and tested on my machine but i had to correct a few thing because our system is case sensitive. Thanks for the anonymous that wrote that script..... 😉 "This script will document tables (including constraints and triggers, row counts, sizes on disk), views (including all […]
2005-10-07 (first published: 2005-09-16)
473 reads
A table Users contains a Create date column.A table AccessLog contains StartTime column.Both are date time fields.Users table contains one row per user and AccesLog contains as many rows as the number oftimes the user Logged into the system.The requirement is:to produce a single table that has two different COUNTs... one column will have the […]
2005-10-06 (first published: 2005-09-16)
1,605 reads
This stored procedure was written to complement the automated profiler trace create procedure (should be here somewhere - check the scripts).Bascially, given the database (sample script to create the database included, but you may want to personalize it), this stored procedure will import the tracefile content into the table, which is indexed on expected search […]
2005-10-03 (first published: 2005-03-04)
377 reads
2005-09-28 (first published: 2004-09-23)
280 reads
This UDF takes a delimited string and parses it into "words" which are returned as rows in a table. The table returned indicates the position of each element in the source string, and converts values to integer and numeric formats if possible.The script contains examples on how to use the function.the original version was written […]
2005-09-26 (first published: 2004-08-10)
649 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers