Stack Overflow
Stack Overflow

Questions tagged [management-studio-express]

Microsoft SQL Server Management Studio Express is the freely downloadable version of Microsoft SQL Server Management Studio, a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

81 questions
1
vote
2 answers

PetaPoco request for int[] type not working

Hello I am trying to make a fetch to Microsoft SQL Server Management studio where in one of my columns there is an array of ints that I want to retrieve based on another column value. I am making the query like this: int[] appsId =…
Ivan Rosa
  • 85
  • 8
1
vote
1 answer

Converting the given minutes to hh:mm:ss format

Here's my database structure (simplified): if db_id('MovieDB') is null create database MovieDB; go use MovieDB; go if object_id(N'Movies', N'U') is null create table Movies ( MovieID bigint not null identity …
user3132457
  • 789
  • 2
  • 11
  • 29
1
vote
0 answers

Log Management in TFS 2018

I have a TFS 2018 running in a machine. My log files are huge so I am deciding how to deal with it. I found how I can use Management studio and use the shrink log files option. (Log into Microsoft SQL Server Management Studio > Right click on your…
fr0zt
  • 733
  • 4
  • 12
  • 30
1
vote
0 answers

Results of a query not showing up. says "Commands completed successfully"

I have a small query that needs print the results in the results pane. The query runs fine without any errors. But I don't see the output of the query in results pane. All other select statements show the results in the results pane. Just this…
SQLServerNewBie2
  • 35
  • 7
1
vote
1 answer

SQL SSMS VS .Net Perfomance Query

I have install Sql Server Management Studio in my PC. Then am connecting to one of my databases remotely I execute a query that returns 6000 records in almost 1 or 2 seconds but when i run the same query from .Net Application (WPF Desktop) also…
Stelios
  • 330
  • 5
  • 21
1
vote
1 answer

Replacing multiple characters in a CASE statement, SQL

I would like to change a bunch of characters in a column using a CASE statement in SQL. The code is the following CASE WHEN [EmpName] LIKE '%æ%' THEN REPLACE([EmpName], 'æ', 'ae') WHEN [EmpName] LIKE '%ø%' THEN…
gripep
  • 379
  • 3
  • 13
1
vote
1 answer

Getting Null error even tho there should be a value via the foreign key

I keep getting an error message when trying to enter my data into the books table error(Msg 515, Level 16, State 2, Line 32 Cannot insert the value NULL into column 'booksPubID', table 'Librarys.dbo.books'; column does not allow nulls. INSERT…
Euforia Stein
  • 37
  • 4
1
vote
2 answers

Tool for Developing SSRS Reports

I only have SSMS 2008 Express on my dev machine. What tools are there that I can use to develop, maintain, and manage server side SSRS reports on this machine?
ProfK
  • 49,207
  • 121
  • 399
  • 775
1
vote
1 answer

Case for every second row in a resultset SQL server 2008

I have a resultset of many rows and I want to write a case expression for comparing every second row in my result without hard coding the rownumber. Every second row in my result is connected to each other. Example: 1 Number1: 2345 Number2:…
Johannate
  • 11
  • 2
1
vote
1 answer

.net error when trying to browse tables

I've installed version 17 of SQL Server Management Studio. When I attempt to click open a database's tables, it gives the following error... Data is Null. This method or property cannot be called on Null values. (System.Data) Any ideas how to…
Ian Warburton
  • 15,170
  • 23
  • 107
  • 189
1
vote
1 answer

How to resolve the issue as “A network related instance specific error”

I trying to connect azure SQL database from SQL Server Management studio and also trying connect from SQL Server Object Explorer in Visual Studio 2015, at that time I got the Exception like “A network related instance specific error”. If you want…
Pradeep
  • 5,101
  • 14
  • 68
  • 140
1
vote
1 answer

How to run a script for each table and save the result into separate CSV files in SSMS 2014?

I have an SQL script that outputs these, given a table name: the column names in the table the datatypes for those columns the column allows NULL or not the column has unique constraint or not. Like this: column | datatype | nullable |…
Sнаđошƒаӽ
  • 16,753
  • 12
  • 73
  • 90
1
vote
0 answers

Microsoft SQL Server : the parameter is incorrect "exception from Hresult:0x80070057

After installating SQL Beautifier, I get this error when I Open SSMS. The parameter is incorrect. (Exception from HRESULT:0x80070057 (E_INVALIDRG)) Create Command bar error 2:VSShell
jit sanju
  • 11
  • 5
1
vote
0 answers

SSMS 2016 Problems with the Editor

I am facing problems with my SSMS express. I have installed a couple of windows 10 updates and after that I could not write queries anymore, the new query windows does not open. I can execute different operations with it such as Create object ("DB,…
Diego Sanabria
  • 23
  • 8
1
vote
1 answer

How to convert a date range table to a row based view?

I’m facing a tough situation. I could not find a solution so far. I have a table giving information based on date ranges. I’d like to have this information broken down by date. So I’m looking to convert the range into a row structure. The extra…
Tartino
  • 13
  • 5
1
2
3 4 5 6