Stack Overflow
Stack Overflow

Questions tagged [ssms-2014]

Microsoft SQL Server Management Studio 2014 is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server. Use this tag specifically for questions related to Microsoft SQL Server Management Studio 2014.

SQL Server Management Studio 2014 is a tool included with Microsoft SQL Server 2014 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

206 questions
0
votes
1 answer

Select rows from query table

Is there an add-in for SSMS 2014 that would allow me to right click on a table form my joins to do the select top 1000 rows functionality?
Jmaurier
  • 767
  • 2
  • 10
  • 28
0
votes
1 answer

Regular expression for an SQL query

I'm looking for a regular expression for the below SQL query. Select * from data where url like '%?%' Where the alphabet can be any alphabet(a-z). Thanks in advance
Harikrishnan N
  • 53
  • 1
  • 2
  • 7
0
votes
0 answers

CTL + SHIFT + ] not working when connected to Azure SQL

According the the official MS documentation, the shortcut key for "Move the cursor to the next brace, extending the selection" is CTL+SHIFT+] But the shortcut key is not working. Does any one know why? Does it require any settings to be changed to…
dejjub-AIS
  • 1,501
  • 2
  • 24
  • 50
0
votes
1 answer

SSIS: trying to convert a flat file with 1 column but has 2 types of data into a table with 2 columns

I am using SSIS and am trying to convert a flat file that has a column for SSN and RN to a table that has 2 columns, one for SSN which is varchar(9) and the other for RN which is varchar(2). How do I split the flat file up into the 2 separate…
Brandon Massey
  • 1
0
votes
2 answers

ALL uses of <> in SSMS schemata - Found one that I can't identify from any search

Preface: Sort of green to this, apologies if it is beyond obvious. I'm using SQL Server Management Studio 2014, and in one of our schemata found this: I've gone down a number of rabbit holes regarding variants in schemata, != functionality,…
Joy_TK
  • 11
  • 3
0
votes
1 answer

How do I find the sum of all transactions since an event?

So, let's say that I have a group of donors, and they make donations on an irregular basis. I can put the donor name, the donation amount, and the donation date into a table, but then I want to do a report that shows all of that information PLUS the…
DaveX
  • 745
  • 6
  • 16
0
votes
0 answers

SSMS 2014 Design Does not show column

I have created a table which has the columns Id, name, CountryId,CreatedOn,CreatedBy,updatedOn,UpdatedBy but when i see the design, there is no CountryId. When i see script of the created table, it shows CountryId the script is as follows -- …
Dastagir Husain Yasin
  • 382
  • 4
  • 15
0
votes
1 answer

SQL command which extracts data after every 500 rows and save it in prefer location and then clear(truncate) it

I'm using a software that generates and feeds data continuously. This data is shown in my own software and can be extracted using report generation (option available). The limit of data storage is 500 rows, so after every 500 rows of data, I have to…
Ajay Tiwari
  • 1
0
votes
2 answers

Need to write a complex query involving multiple Joins with related foreign key dependencies

Main question I need a SQL statement to answer this entire question, not using any Union statements. In the AdventureWorks2014 database I need to find which store is David Campbell associated with? And sort by store name. This query must show…
TheCyberTechnician
  • 1
  • 3
0
votes
0 answers

Why can't I connect to a remote SQL Server instance?

I have tried the various suggestions on this issue and am still having no luck. I am trying to use SQL Server Management Studio 2014 to connect to a remote SQL Server instance. The server is there. I can ping it, connect via TELNET to port 1433,…
Daniel Anderson
  • 275
  • 3
  • 16
0
votes
1 answer

Track the user that changed/updated a row in database table - sql server

I need to make a column that whenever a user on the network updates the row through the listview in an ASP.net web page, it can find and store that in the column one that row. Does anybody have an example of this?
Psymbionic
  • 29
  • 8
0
votes
0 answers

T-SQL cast column to dynamic Data Type

I want to cast a column to the datatype which is a text value in another column. I know I can do this with exec sp_executesql, but if I can do it without this, that would be ideal. BEGIN TRY DROP TABLE #1 END TRY BEGIN CATCH END…
user2921429
  • 1
  • 1
  • 2
0
votes
3 answers

Trying to use a count column in the where part of a query

There is 2 tables called Students stuID camID FK Campus camID PK camName I am trying to find the campuses with more than 4 students that include the camName, camID, (number of students) This is what I got so far SELECT students.camID,…
Tristan
  • 83
  • 1
  • 8
0
votes
1 answer

Diacritic characters in CSV but turned into strange characters in SQL Server Import Wizard

I have a CSV file encoded as UTF-8, which I downloaded off IMDb.com. I would like to import this data into SSMS 2016 (or 2014) using the Import Wizard. Here is a sample of what the CSV looks like (note the director of Dallas Buyers Club is Jean-Marc…
Walker
  • 153
  • 2
  • 9
0
votes
1 answer

Doing Query for with 3 tables and cant get the output how I want it

There is 3 Tables ITEM itemID PK INVENTORY quantity charID FK itemID FK CHARACTERS charID PK charName . ITEM 1---many INVENTORY 8----1 CHARACTER I want to find the top 10 most stacked items that is stacked in the characters inventory and in…
Tristan
  • 83
  • 1
  • 8
1 2 3
…
13 14