Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL

Tip: Change the Owner of SQL Reporting Services Subscription

Here is the scenario: Your organization has a SQL Reporting Server that generates custom reports based on some of your data.  These reports need to be generated each day at noon and then emailed to someone important.  So Tom, your current DBA, Read More...
Posted Thursday, July 10, 2008 11:07 PM by Jeremiah.Clark | 5 Comments
Filed under: , , ,

SQL 2008 February CTP

The SQL Server 2008 Feb CTP has been released and can be found here: http://www.microsoft.com/sql/2008/prodinfo/download.mspx I can't wait to test some of the new spatial features, compression, and the long awaited MERGE statement. Read More...
Posted Thursday, February 21, 2008 12:01 AM by Jeremiah.Clark | 1 Comments
Filed under:

SQL: If Exists Update Else Insert

This is a pretty common situation that comes up when performing database operations. A stored procedure is called and the data needs to be updated if it already exists and inserted if it does not. If we refer to the Books Online documentation, it gives Read More...
Posted Sunday, February 17, 2008 10:30 PM by Jeremiah.Clark | 28 Comments
Filed under: ,
 
Page view tracker