devxlogo

Tip Bank

Create UDL files the easy way

The standard way to create a UDL file is to right-click in the directory where you want to create it and select the New-Microsoft Data Link menu command. Unfortunately, on

Handling Data Inconsistency

Many times in DB programming, a situation occurs when one operation, depends on the result of the other, but there is no way to communicate that result to the first

Determining the Last Date Of a Month

It’s common when working with dates to be able to determine the last date of a particular month. I’ve seen solutions to this problem that range from using arrays or

Encrypting Stored Procedures

When creating stored procedures, there will be occasions where a certain procedure definition should not be viewed. Using the WITH ENCRYPTION clause stores the procedure definition in an unreadable form.