Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I have a table that contains a Xml column: SELECT * FROM Sqm A sample of the xml data of a …
sql-server xml sql-server-2005 sql-server-2008-r2 sqlxmlWhile I am searching through my database, I run an INSERT statement if I find that a particular item does …
sql sql-server sql-server-2008 tsql sql-server-2008-r2I am working in a database where I load data in a raw table by a data loader. But today …
sql-server database sql-server-2008-r2 locking deadlockI am using SQL Server 2008. I have the following: select convert(varchar(20),fmdate) from Sery How do I convert the …
sql-server-2008-r2I've got dirty data in a column with variable alpha length. I just want to strip out anything that is …
tsql sql-server-2008-r2 substring patindexI have installed MS SQL Server 2008 R2 and when I try to update model from database under EDMX file I …
.net visual-studio sql-server-2008-r2 entity-framework-5I want to retrieve the last time table was updated(insert,delete,update). I tried this query. SELECT last_user_…
sql-server-2008-r2Hi I am loading table A data from sql server to mysql using pentaho when loading data i need to …
sql sql-server sql-server-2008-r2 pentaho pentaho-cdeI have some data that I would like to split based on a delimiter that may or may not exist. …
sql sql-server sql-server-2008 tsql sql-server-2008-r2I just created a Instead After Trigger whose syntax is given below: Create trigger tgrInsteadTrigger on copytableto Instead of Insert …
sql sql-server database sql-server-2008 sql-server-2008-r2