Stack Overflow
Stack Overflow

Questions tagged [ssms-2012]

Microsoft SQL Server Management Studio 2012

Microsoft SQL Server Management Studio (SSMS) 2012 is an easy-to-use graphical management tool for managing SQL Server 2012 Edition with Advanced Services.

The tool includes both script editors and graphical tools which work with objects and features of the server.

258 questions
-2
votes
4 answers

How to select a particular type and exclude others in a query

Was just wondering if it's possible to select rows which uses only particular type and not anything else in SSMS. For example: ╔════════╦══════╗ ║ UserID ║ Type ║ ╠════════╬══════╣ ║ 1 ║ A ║ ║ 1 ║ B ║ ║ 1 ║ C ║ ║ 1 ║ D …
Raja
  • 85
  • 1
  • 1
  • 7
-2
votes
1 answer

Can you save query while it is running?

I am working on a very long stored proc in SSMS. In addition to having the stored proc in the database I have the ALTER PROC statement saved to a .sql file. If I run a portion of the stored proc (such as a SELECT or UPDATE statement), can I…
user2034570
  • 26
  • 1
  • 3
-3
votes
3 answers

Substring between 2 character or full length SQL

I have a question, let's say I have a column A with values: te SN: 123454A / Lo te SN: 12348887 te SN: 547896 I want to retrieve everything that is +2 after : up to the / but in case / doesn't exist, get everything after :. So my result would…
gizq
  • 187
  • 11
1 2 3
…
17
18