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
0
votes
1 answer

How to build nested queries in SSMS if I only have read access to the database?

I'm just getting started learning SQL Server Management Studio. I'm familiar with building nested queries in Access, e.g.: Query1 (get a data set) select t1.a,t2.b,t1.abc,t2.def from tbl_FNA t1 inner join tbl_DMZ t2 on t1.b=t2.b Query2 (return…
sigil
  • 9,370
  • 40
  • 119
  • 199
0
votes
0 answers

SSMS2012 does not show non-index predicates on index seek?

Although SSMS2012 execution plan does show me all the seek predicates of a non-clustered index seek operation, it does not show any other predicates: However, if I save the execution plan as XML file, I can see other predicates: …
D.R.
  • 20,268
  • 21
  • 102
  • 205
0
votes
1 answer

Virtual indenting empty strings

SQL Server Management Studio 2012 has some strange behaviour. For example I have the following query: if year(getdate()) = 2013 select 'two thousand and thirteen'; if year(getdate()) = 2014 select 'two thousand and fourteen'; There is no…
GriGrim
  • 2,891
  • 1
  • 19
  • 33
0
votes
1 answer

Inserting into database LINQ to SQL Visual Basic Visual Studio 2008

Using SQL Server Management Studio 2012 So i have a text box and a button, I would like to type something into the text box and have it inserted into a specific table when i click the button. Here is what i have so far. I found something a lot…
Monz
  • 139
  • 1
  • 13
0
votes
1 answer

How can I check if bit value is greater than 1 with TRY_CONVERT sql function

I'm using sql server managment studio 2012 What I'm trying to do is check if string value is a bit if it is then I want to check if this value is greater than 1. here is my code: (TRY_CONVERT(bit, '2') IS NULL OR TRY_CONVERT(bit, '2') > 1) For…
Harry89pl
  • 2,415
  • 12
  • 42
  • 63
0
votes
0 answers

One synonym in SSMS isn't showing up in the intellisense. But every other synonym is.

In the following image, you can see a small section of our synonym list. In the intellisense, I can't see dbo.SYN_MC_Asset, but I see the other synonyms. Any ideas on why this is occurring?
ernest
  • 1,633
  • 2
  • 30
  • 48
0
votes
0 answers

SSMS change Select shortcut to SELECT *

I've already changed the right-click shortcut from SELECT TOP 1000 to Select All, but when it executes the query, it lists out all columns in the query instead of just running SELECT *. Nitpicking here, but it's an extra step when I add a new…
Nick F
  • 72
  • 1
  • 6
0
votes
0 answers

Reason why data returned is different. SSMS 2012

I'm pretty new when it comes to memory issues with SQL. Our company currently has SSMS 2012 (we updated from SSMS 2008 R2). I'm running a procedure in SSMS 2012 that has two cursors. Within the cursors, I have a dynamic SQL statement that is…
Kristina
  • 679
  • 5
  • 11
  • 25
0
votes
1 answer

Client database is using Text field, I'm using nvarchar

In relation to Need to convert Text field to Varchar temporarily so that I can pass to a stored procedure I've tried the cast, but I still get a surviving CRLF that plays havoc with my system. There is no way I can alter anything on the client, I…
DoStuffZ
  • 785
  • 15
  • 37
0
votes
1 answer

Pivot table wording - SSMS 2012

I'm trying to pivot the PRODUCT column of a table. Values that have two words have an underscore in between: EX of some PRODUCT values: PRODUCT USSIC_Aviation Avemco_Aviation Property Life This is my pivot code: select SIMULATION, [USSIC…
Kristina
  • 679
  • 5
  • 11
  • 25
0
votes
1 answer

SQL Server Management Studio 2012 not recognizing Local Server

I'm a total newb to SSMS, but all of the tutorials I'm finding online gloss over the step where they start up the program and connect to their local server, their computer's name. I'm on Windows 8, and ISS is installed and running correctly. I'm…
NominalAeon
  • 593
  • 5
  • 23
0
votes
1 answer

SQL Server connection restriction

Is there any way to restrict individual connection to SQL Server Management. Like I have set of users can login to SQL server Management studio with active 2 connection for a individual open in a time. Connection with Database will not be allowed if…
user1954762
  • 159
  • 1
  • 3
  • 11
0
votes
1 answer

SQL Server 2012 Intellisense works, but for 2008 is does NOT work

From the day I got my machine before even opening SSMS 2008 they had installed on my machine, I had installed 2012, so I don't know if intellisense ever worked on 2008. However it is working on 2012. Did 2012 overwrite some dll or something in the…
user1826685
  • 21
  • 2
0
votes
1 answer

How do you toggle showing the results tab in SSMS query editor

In the previous version the shortcut key was Ctrl+R This would close or open the query results pane in previous versions of SSMS, but in SSMS2012 that doesn't work anymore. This was a nice way for me to get extra screen real-estate while building…
BraveNewMath
  • 8,090
  • 5
  • 46
  • 51
0
votes
2 answers

TSQL Keyword Previous or Last or something similar

This question is geared for those who have more SQL experience than me. I am writing a query(that will eventually be a Stored Procedure but this should be irrelevant) where I want to select the count of rows if the most recent entry's is equivalent…
Brandon
  • 915
  • 4
  • 23
  • 44
1 2 3
…
17 18