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 2: THEN UPDATE 3: ELSE 4: INSERT SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to provide this functionality with a [...]