Email Alerts
-
Adding data into SQL Server 7 from Visual Basic
Ask the Expert
-
Simpler way to get a randomly sorted column
Code to give a randomly sorted column without altering a table. Tip
-
Sending mail using CDONTS
This stored procedure can be used to send mail through CDONTS and SQL Server. Tip
-
BBA friendlier version of sp_lock
This SQL Server stored procedure generates more readable output from the system sp_lock procedure. Tip
-
ODBC IP connection troubleshooting
A tip on how to resolve MDAC and connection issues in SQL Server 7 & 2000. Tip
-
What is SQL?
Ask the Expert
-
Quick insert or update of records from a second table
Here is how to update an existing record in a table from another table and insert a new record if one doesn't exist. Tip
-
Read a text file from the Windows system
A script that will read a text file from the Windows system into SQL Server. Tip
-
String manipulation functions
An introduction to SQL Server's string functions and real-world solutions that take advantage of them. Tip
-
Procedure to drop all user-created indexes of given table
A simple stored procedure that allows you to drop all user created index of a given table. Tip