Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I want to add a new trigger to my table. As seen in the picture, New Trigger button is not …
sql-server sql-server-2008-r2 sql-server-express triggers management-studio-expressWhat I Have I have a variable size XML document that needs to be parsed on MSSQL 2008 R2 that looks …
sql-server performance sql-server-2008-r2 sqlxml cross-applyI have a report with 2 data sets and would like to perform a SUM operation in a textbox expression. The …
reporting-services sql-server-2008-r2 expression iifI'm using something similar to example C on this MSDN page: http://msdn.microsoft.com/en-us/library/ms190307.aspx DECLARE @…
html tsql sql-server-2008-r2 sp-send-dbmailI'm trying to get up and running with Windows Azure but finding the database side extremely frustrating. I need to …
sql sql-server-2008-r2 azure-sql-database bacpacI want to create setup file for my project with all prerequisites like framework,sqlserver and .log file/db script. …
visual-studio-2010 c#-4.0 sql-server-2008-r2 visual-studio-setup-proje visual-studio-setupI have two database tables, Team (ID, NAME, CITY, BOSS, TOTALPLAYER) and Player (ID, NAME, TEAMID, AGE), the relationship between …
sql-server-2008-r2 calculated-columnsIs it possible to return output parameters from a SSIS "Script Task" that has been called by a stored procedure …
ssis sql-server-2008-r2 xp-cmdshellHow to transform this: ID Name Description 1 Test1a TestDesc1a 1 Test1b TestDesc1b 2 Test2a TestDesc2a 2 Test2…
sql sql-server-2008-r2 pivot pivot-without-aggregateI have a variable coming into a stored procedure. This variable can either have a value or be null. If …
sql sql-server-2008-r2 isnull