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 [...]
|
||||||
|
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 [...] 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 SQL [...] |
||||||
|
Copyright © 2010 Aaron Lowe - All Rights Reserved |
||||||