Top "Ssms" questions

Microsoft SQL Server Management Studio is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

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 …

sql-server ssms
Incorrect syntax near ''

I'm trying to run the following fairly simple query in SQL Server Management Studio: SELECT TOP 1000 * FROM master.sys.procedures …

sql sql-server ssms
SQL query, if value is null then return 1

I have a query that is returning the exchange rate value set up in our system. Not every order will …

tsql null ssms
How can I change my default database in SQL Server without using MS SQL Server Management Studio?

I dropped a database from SQL Server, however it turns out that my login was set to use the dropped …

sql-server sql-server-2005 ssms default-database
How to export all data from table to an insertable sql format?

I have a Table (call it A_table) in a database (call it A_db) in Microsoft SQL Server Management …

sql sql-server copy export ssms
How do I view the SSIS packages in SQL Server Management Studio?

Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server …

sql-server-2005 ssis ssms
How to view the stored procedure code in SQL Server Management Studio

I am new to SQL Server. I am logged into my database through SQL Server Management Studio. I have a …

sql-server tsql ssms
Saving changes after table edit in SQL Server Management Studio

If I want to save any changes in a table, previously saved in SQL Server Management Studio (no data in …

sql sql-server ssms database-table
How to alter SQL in "Edit Top 200 Rows" in SSMS 2008

In SQL Server 2008 Management Studio, when I right click on a database table and choose "Select Top 100 Rows", I can …

sql-server ssms sql-server-2008
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) …

sql-server sql-server-2008 ssms