Script will drop the Default, Primary, Unique, Foreign Constraints, Index and ROWGUID on Unique Identifier data type column and finally it alters the unique identifier to varchar (38) data type. I have compile and execute the script in my database server. Script has executed successfully.
2005-01-12 (first published: 2004-12-24)
781 reads
Return the Count of Monday between two date........Return the Count of Sunday between two date
2005-01-11 (first published: 2004-12-25)
357 reads
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-10 (first published: 2004-12-28)
101 reads
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-07 (first published: 2004-12-28)
386 reads
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-06 (first published: 2004-12-28)
199 reads
This function will take a 64 bitmask string and return the value of bitmask. If you need 128, 256, etc simply change the length of the parameter, being careful to remember you may need to change the return type of int to BigInt if you get too long.
2005-01-04 (first published: 2004-12-30)
254 reads
Script uses simpler Dateadd function ensuring additions/substractions are based from 1st of month.
2005-01-03 (first published: 2004-12-02)
144 reads
I wanted to know which tables contains the most populated records in db. So I wrote this script.
2005-01-02 (first published: 2004-11-18)
98 reads
It is often necessary to generate a table with sequential numbers, up to a specified upper limit N. For small N, a simple INSERT in a WHILE loop will do. But, for large N, that solution becomes too slow. This script presents a different approach. It generates sequential numbers from the binary representation of N, […]
2004-12-30 (first published: 2003-11-24)
641 reads
This function will calculate the number of weekdays between two dates passed. This allows for accurate tracking of "business days" for metrics in many different views.
2004-12-28 (first published: 2004-12-16)
277 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers