My best guess is that this is not a bug, but a feature of Sql 2012. 😉 In other contexts, you’d be happy to retain your cr-lf’s, like when copying a big chunk of text. It’s just that it doesn’t work well in your situation. You could always strip them out in your select. This … Read more
You can use INFORMATION_SCHEMA.TABLES to retrieve information about your database tables. As mentioned in the Microsoft Tables Documentation: INFORMATION_SCHEMA.TABLES returns one row for each table in the current database for which the current user has permissions. The following query, therefore, will return the number of tables in the specified database: USE MyDatabase SELECT COUNT(*) FROM … Read more
As of SQL Server 2012 you no longer have to go through the hassle of deleting the bin file (which causes other side effects). You should be able to press the Delete key within the MRU list of the Server Name dropdown in the Connect to Server dialog. This is documented in this Connect item … Read more
Although this has already been answered, I see people are repeatedly getting the same error that I did when trying to solve it. If when you run: C:\windows\system32> lodctr /r you get the error Error: Unable to rebuild performance counter setting from system backup store, error code is 2 then you instead need to run … Read more
You can convert it to datetime, and then use DATEADD(DAY, -30, date). See here. edit I suspect many people are finding this question because they want to substract from current date (as is the title of the question, but not what OP intended). The comment of munyul below answers that question more specifically. Since comments … Read more
If you want to do it this way then this is the syntax you’re after; IF EXISTS (SELECT * FROM tblGLUserAccess WHERE GLUserName=”xxxxxxxx”) BEGIN SELECT 1 END ELSE BEGIN SELECT 2 END You don’t strictly need the BEGIN..END statements but it’s probably best to get into that habit from the beginning.
The answer to this may be identical to the problem with full blown SQL Server (NTService\MSSQLSERVER) and this is to reset the password. The ironic thing is, there is no password. Steps are: Right click on the Service in the Services mmc Click Properties Click on the Log On tab The password fields will appear … Read more
This works for me to find queries on any database in the instance. I’m sysadmin on the instance (check your privileges): SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.* FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest WHERE dest.dbid = DB_ID(‘msdb’) ORDER BY deqs.last_execution_time DESC This is the same answer that Aaron Bertrand provided … Read more
Use a temporary table: CREATE TABLE #variables ( VarName VARCHAR(20) PRIMARY KEY, Value VARCHAR(255) ) GO Insert into #variables Select ‘Bob’, ‘SweetDB’ GO Select Value From #variables Where VarName=”Bob” GO DROP TABLE #variables go
IIF is the same as CASE WHEN <Condition> THEN <true part> ELSE <false part> END. The query plan will be the same. It is, perhaps, “syntactical sugar” as initially implemented. CASE is portable across all SQL platforms whereas IIF is SQL SERVER 2012+ specific.