I would like to make some of our database search functions more sophisticated, but I'm running into a roadblock. The code below is a cleaned-up version of what I've come up with (minus several search ...

To update the data, you can specify view descriptors in the PROC SQL INSERT, DELETE, and UPDATE statements. Here is a summary of these PROC SQL statements: DELETE deletes records from a CA-DATACOM/DB ...

I'm working on a VB.NET app that creates SQL Logins for an app that uses our MS-SQL server.<BR><BR>The docs for both sp_addlogin and sp_grantdbaccess claim that it will return a zero if successful, ...

Most professional business programmers have found themselves on the receiving end of more than a few crazy requirement or design documents at least once in their careers. These stoic programmers grind ...