Recover unsaved SQL query scripts
How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed? 16 Answers 16
ssms
How to connect to local instance of SQL Server 2008 Express
I just installed SQL Server 2008 Express on my Vista SP1 machine. I previously had 2005 on here and used it just fine … Read more
How do you view ALL text from an ntext or nvarchar(max) in SSMS?
How do you view ALL text from an NTEXT or NVARCHAR(max) in SQL Server Management Studio? By default, it only seems to return … Read more
How can I generate an INSERT script for an existing SQL Server table that includes all stored rows?
I’m looking for a way to generate a “Create and insert all rows” script with SQL Management Studio 2008 R2. I know that … Read more
How to drop all tables in a SQL Server database?
I’m trying to write a script that will completely empty a SQL Server database. This is what I have so far: USE [dbname] … Read more
SQL Server Management Studio, how to get execution time down to milliseconds
When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. … Read more
SQL Server. How to refresh the intellisense? [duplicate]
This question already has answers here: Closed 10 years ago. Possible Duplicate: Lost the IntelliSense SQL Server 2008 Intellisense problem I’m new to … Read more
Removing the remembered login and password list in SQL Server Management Studio
I’ve recently used our company’s spare laptop (that has a general user set up) while mine was being repaired. I’ve checked the “Remember … Read more
Unique constraint on multiple columns
CREATE TABLE [dbo].[user]( [userID] [int] IDENTITY(1,1) NOT NULL, [fcode] [int] NULL, [scode] [int] NULL, [dcode] [int] NULL, [name] [nvarchar](50) NULL, [address] [nvarchar](50) NULL, … Read more
How do I set a column value to NULL in SQL Server Management Studio?
How do I clear the value from a cell and make it NULL? 6 Answers 6