Categories

ISNUMERIC maybe…

So the other day I was working on a T-SQL query that I was using to take data from generic data types and insert it into a strongly typed table.  One of the columns was moving from an nvarchar(255) to an decimal data type.  As some of the rows had character data in it, I [...]

Did you know? SQL Server 2008 includes Transact-SQL Debugger

The Transact-SQL debugger in SQL Server Management Studio enables you to find errors in Transact-SQL scripts, stored procedures, triggers, and functions by observing their run-time behavior. You can start the debugger when you are using the Database Engine Query Editor window.

By using the Transact-SQL debugger, you can do the following:

Step through the Transact-SQL [...]

Did you know? SQL Server 2008 includes Merge Statement

Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as:

1: IF FOUND
2: THEN UPDATE
3: ELSE
4: INSERT

SQL [...]