Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
What T-SQL command can be run to find character set of a table or database in SQL Server? edit: Server …
sql-server sql-server-2008-r2 collationHow do I connect MS SQL Server using Windows Authentication, with the pyodbc library? I can connect via MS Access …
sql-server sql-server-2008-r2 odbc windows-authentication pyodbcPossible Duplicate: How to do SQL Like % in Linq? Like Operator in Entity Framework? I'm doing a query like this: …
c# wpf sql-server-2008-r2 ef-code-firstIs there any easy way to return single scalar or default value if query doesn't return any row? At this …
sql sql-server sql-server-2008-r2I'm trying to share my site in the local network. I want to use command line tool to perform this …
iis iis-7 sql-server-2008-r2 windows-server-2008 firewallCreated a function CREATE FUNCTION Split_On_Upper_Case(@Temp VARCHAR(1000)) RETURNS VARCHAR(1000) AS BEGIN DECLARE @KeepValues AS VARCHAR(50) SET @…
sql sql-server sql-server-2008 sql-server-2008-r2I get the following message when I want to create a new publication or Subscription. "Sql Server replication requires the …
sql-server sql-server-2008-r2I have (for testing purposes) many dbs with the same schema (=same tables and columns basically) on a sql server 2008 …
sql-server sql-server-2008-r2 multiple-databasesI am using SQL Server 2008 R2 and I have an INT column where the data inserted never surpasses the max …
sql-server-2008-r2 int sum overflow arithmeticexceptionI am trying to use IIF() in a select statement. The boolean expression checks to see if a fields value …
sql sql-server sql-server-2008 sql-server-2008-r2