Visual Studio Magazine

T-SQL | COMBINE UPDATE AND INSERT STATEMENTS

Listing 5. This procedure demonstrates a technique for combining an Insert statement and an Update statement into a single stored procedure. CREATE PROCEDURE STDA.CustomersUpdate @CustomerID NCHAR(5), ...
Visual Studio Magazine

SQLite Performance and Prepared Statements

In my last column, I introduced SQLite, an amazing little database engine written and provided entirely in C source code. I showed you how to begin wrapping it up in modern C++, producing a correct ...