We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it. We've got a stored procedure in Sql Server 2005. It's not terribly complicated but it's ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

For a complete description of the PROC SQL statements, see SQL Procedure Pass-Through Facility Statements. The following section describes the SYBASE-specific arguments that you use in the CONNECT ...

Although the SQL Procedure Pass-Through Facility has always passed joins to the DBMS, it is now possible to pass joins to the DBMS without using Pass-Through. Beginning in Version 7, the LIBNAME ...

Rather than writing 3 stored procedures, I'd like to write a single one with some conditional logic in the WHERE clause. However, what I wrote (based upon bits and pieces of code samples I found) ...

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them. Initially created in the 1970s, ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...