Stack Overflow
Stack Overflow

Questions tagged [ssms]

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

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for accessing, configuring, managing, administering and developing all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SSMS works with all components of SQL Server such as Reporting Services and Integration Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

On Wikipedia: SQL Server Management Studio

7484 questions
2
votes
3 answers

T-SQL Use a variable as a table name

I am in the process of trying to condense several stored procedures in SSMS into a single one. All of the procedures were fairly similar in function: go through a table and change the value of a given field to a given variable. The only real…
5E4ME
  • 173
  • 4
  • 16
2
votes
1 answer

Converting rows to columns using multiple pivot in sql

I have written a query to convert rows into columns using multiple pivot functions with respect to months 4, 5 & 6. I did succeed in converting the rows into columns. Below is the query: (SELECT [team], Count_Of_OrderId, Count_Of_OId, …
Tamil
  • 77
  • 10
2
votes
2 answers

How to add a distinct value to repeating columns in SQL Server?

I have a table with CountryName and an id. Eg. id CountryName ----------------- 1 Afghanistan 2 Afghanistan 3 Afghanistan 4 Albania 5 Albania 6 Albania 7 Albania I want to add a new column CountryID where…
Peter Parker
  • 31
  • 2
2
votes
1 answer

Can I connect to localhost on SSMS without being a system admin?

How to setup and use temporary local db without admin privilege on the system.
Huzefa Baramatiwala
  • 21
  • 1
2
votes
1 answer

Getting Error "Incorrect syntax near ENspid" "Incorrect syntax near smoEnabled" while connecting Remote database via SSMS 2012

While trying to connect to Remote database via SQL Server management studio 2012 using SQL Server authentication, getting error shown in snapshot. But, it is working fine with the local database, with SQL server authentication. It is happening only…
Neet Singh
  • 167
  • 1
  • 9
2
votes
2 answers

Where to download sun.jdbc.odbc.JdbcOdbcDriver (trying to connect output csv from Spoon to SSMS)

I have a csv that I have transformed in Kettle/Spoon/PDI and I am trying to output it to SSMS. In Spoon, it's a two step process: read the csv (and edit a couple types), then output to SQL. I get this error: "Driver class…
CD9999
  • 109
  • 1
  • 3
  • 14
2
votes
4 answers

how to use is null with case statements

Hi can any one say me how to write query in sql server management studio for statement =>if(isnull("GROSS_SF")=1 or "GROSS_SF"=0,0,"GROSS_SALES"/"GROSS_SF") by using case statement : CASE WHEN ("GROSS_SF"=1 or "GROSS_SF"=0) isnull then 0 …
sweety
  • 23
  • 1
  • 4
2
votes
2 answers

SQL error reading a value from a text file to use in WHERE clause and YYYY-DD-MM localized DATETIME

There is a file C: /date.txt, there is only one date stored here, for example 02-08-2018. How do I in SQL select the data that is greater than this date? if I so will write a request SELECT Dt, col,col2, col3... FROM mytab1 WHERE Dt> C:…
psysky
  • 3,037
  • 5
  • 28
  • 64
2
votes
3 answers

Delete rows using case when condition in SQL Server

Say I write this query select x1, x2, x3 act from mytab I need delete rows using any condition case when x1=b, and act=0, then delete these rows At the same time, i need to delete rows that contain a null value by x1 column. How can I do…
psysky
  • 3,037
  • 5
  • 28
  • 64
2
votes
2 answers

Is it possible to install SSMS on an Azure VM and connect to a Azure SQL Database

I have an Azure SQL Database that I currently connect to from my on-premises laptop computer. I would like to install SSMS on an Azure Virtual Machine and have my complete stack in the Azure Cloud. Is it possible to install SSMS (or comparable…
Mutuelinvestor
  • 3,384
  • 10
  • 44
  • 75
2
votes
2 answers

How do you show the actual query plan for a single query in a batch in SSMS?

I have a stored procedure I'm trying to optimize which accepts a table variable as parameter. The table variable has a single column and is used to pass in a list of primary keys. When testing, I create a dummy table variable, run a bunch of INSERT…
Andrew
  • 789
  • 7
  • 13
2
votes
2 answers

SQL Server : set value where row id is same

I am using SQL Server and I'm facing an issue. I have two tables, table1 and table2. Table1 has a column VALUE and table2 has two columns Id and Wiegand_Id. What I want to do is set the columns's VALUE (in table1) to the values of Wiegand_Id,…
we_mor
  • 478
  • 5
  • 20
2
votes
6 answers

Get the distinct of two columns that are the reverse of each other in SSMS

Apologies if this is a duplicate question, I can't seem to find it anywhere else. I have a table like so: column1 column2 column3 entry 1 A B ENTRY 2 A C ENTRY 3 B C ENTRY 1 B A ENTRY 2 C A ENTRY 3 C B The table I'm using has more…
Anonymous
  • 440
  • 3
  • 14
2
votes
5 answers

How to join SQL statements with different where clause on different column of same table

I have 3 queries in sql: 1st query: select t1ID ,AVG(t2score) AS AVG1 from T1 WHERE t1m1 NOT IN (t2m1,t2m2,t2m3) and t1m2 IN (t2m1,t2m2,t2m3) group by t1ID Result +------+------+ | t1ID | AVG1 | +------+------+ | 1 | 55 | | 2 | 45 | | …
user101
  • 45
  • 2
2
votes
6 answers

Is there a way to get all the stored procedures that can update a specific column in SQL?

I've got a field in a table that changed value unexpectedly. Clearly, a stored procedure caused that (I've already searched the few triggers we're using, and no login has update grants on any table in our database), and I'm in the process of finding…
Brann
  • 31,689
  • 32
  • 113
  • 162
1 2 3
…
99 100