Ars Technica

sql IF statements - using query results as conditionals

I'm trying to get better aquainted with conditional sql statements, using variables, loops, and all that other junk. (This is MSSQL 2000 by the way) My test is that I want to try to cycle thru all of ...
Simon Fraser University

Invoking the SQL Query Window

profile= the name of a user-defined profile that you want to use for your SQL Query Window session. You can specify a profile by using the following syntax: profile=libname.catalog.profile access= the ...
Ars Technica

TSQL: Pass parameter to OPENQUERY statement

I can't seem to work this out. SELECT * FROM OpenQuery(LinkedServer,' SELECT * FROM tblData WHERE SomeField LIKE ''' @SearchParm ''' ') But that doesn't seem to work. I have it working just fine ...
TechRepublic

SQL basics: SELECT statement options

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...
Visual Studio Magazine

SQLite Queries and Primary Keys

In this third and final installment on using SQLite from C++, I want to begin exploring some of the internals of this amazing little database engine. SQLite does things quite differently than most ...