Convert Hex value to Signed 32-bit int
Convert, up to 8 nibbles, hex string ('FFFFFFFF'...'00000000')to signed 32-bit int (-2147483648..2147483647).
2001-11-15
2,495 reads
Convert, up to 8 nibbles, hex string ('FFFFFFFF'...'00000000')to signed 32-bit int (-2147483648..2147483647).
2001-11-15
2,495 reads
In this view, Steve thinks that certifications are invaluable (especially in this economy).
2001-11-13
3,424 reads
When implementing a pilot study of audit trail triggers, you often want a way of removing all triggers in the database in order to retest your scripts: here it is!
2001-11-08
1,522 reads
Part 1 of a 4 part series about ADO, this is a beginner level article designed to get you started using the ADO connection object. If you haven't used ADO so far, why not see what it's all about?
2006-05-26 (first published: 2001-11-08)
31,346 reads
Like the one posted before, the use of the SP is like this: proc_alerts 1,18. This will show the first 18 alerts on the system. OR proc_alerts 20,35 will show from 20 to 35. This lets you manage the list without letting go out of the screen.
2001-11-03
1,054 reads
If you are using OSQL or ISQL from DOS querys are really hard to use, because the result is to big for the screen. With this procedure, you can especify from wich column to wich column show the list of tables. For Example: proc_tables master, 3, 10 will show you only a short list of […]
2001-10-28
775 reads
2001-10-26
1,436 reads
Now you can run administrative T-SQL tasks against all your databases in one shot. Very usefull for environments that have a seperate database for each client, ASP's, etc. It's pretty straight forward and can be used for almost any task. This example Looks for a table and prints the database name and selects from the […]
2001-10-21
3,135 reads
Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!
2019-08-01 (first published: 2001-10-09)
34,396 reads
Ever forget to commit a transaction and then find out hours later that there is deadlocked transactions all over your database server? Worse yet has one of your coworkers done this to your database server? Never again, this stored procedure will net send the machine that has an open transaction, and send you (The DBA) […]
2001-10-08
9,153 reads
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
By gbargsley
This is Week 1 of PowerShell Strikes Back – a four-week May series for...
By Steve Jones
This happened to me recently after being busy with non-data modeling tasks for a...
WhatsApp: 0817825533, Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol, Kec....
Whatsapp:087757645171 Jl. Suari No.18, Purwodinatan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50121
Whatsapp:087757645171 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta, Jawa...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers