remi's adventures in the database realm

./ mssql / t-sql

T-SQL != PL/SQL

Transact-SQL is central to the use of Microsoft SQL Server. All applications that communicate with SQL Server do so by sending Transact-SQL statements to the server, regardless of an application’s user interface. Transact-SQL Reference

Control Structures

mssql / t-sql November 15th, 2006 / August 20th, 2007

Control structures syntax; IF THEN ELSE, CASE, WHILE . read more →

cursors in tsql

mssql / t-sql November 3rd, 2006 / August 20th, 2007

Cursors in tsql, it can be done … read more →

return variables from dynamic sql - sp_executesql

mssql / t-sql November 1st, 2006 / August 20th, 2007

Returing values into tsql variables from a dynamic sql statement using sp_executesql stored procedure. read more →

environment

mssql / t-sql September 18th, 2006 / August 20th, 2007

Getting around in the mssql environment read more →

Date Time functions

mssql / t-sql September 17th, 2006

Date time functions (frustrations) in T-SQL. read more →