Stack Overflow
Stack Overflow

Questions tagged [sql-server-2017-express]

51 questions
0
votes
0 answers

How to solve SQL Server Express installation error

While installing SQL Server express 2017 in windows, getting the following error: Please any one suggest to move forward on installation
RutherA
  • 19
  • 5
0
votes
0 answers

How to resolve "Ensure SQL Server Browser is running" , when it is

I'm creating an Android App using Xamarin Forms in Visual Studio 2017. Since this includes storing data, I'm using SQL Server 2017 to accomplish this. When I run my code, and debug the line "conn.Open()", I get an error stating that I should…
U of M Student
  • 1
0
votes
0 answers

Passing XML data from C# application to stored procedure taking long time

See my below sample stored procedure code which is not full code base because my it is huge. I am passing several xml data fragments to the stored procedure from my C# application and it is taking long time to pass them. In the stored procedure, I…
Dona bhatt
  • 71
  • 2
  • 5
0
votes
0 answers

Python Script to run SQL Server UPDATE statement to loop through each row in result set and update column

I have a SQL Server 2017 database table with 10,000+ records with an EmailAddress column that needs to be updated for every row in the table incremented by 1 (i.e. a+1@email.com, a+2@email.com up to a+10000@email.com). I'm thinking the easiest way…
benfsmith3
  • 21
  • 1
  • 4
0
votes
1 answer

I am unable to do insert into a table along with Merge command

Unable to perform Merge with Insert statement (for an accounting process) Table1 contains GRList for write off (based on date on Table3) Table2 Contains All GR details (all information from 1-jan-2010 to till date) Table3 contains Oldest Claim date…
Avinesh
  • 21
  • 5
0
votes
1 answer

Return type error when i'm getting JSON as result when calling stored procedure using entity framework

I was trying to get output by calling stored procedure to get result type in JSON format by calling the API.I have used Entity Framework and mapping was done to get values.But i'm getting the error. i'm using visual studio 2019(entity framework…
Harish Reddy
  • 1
  • 3
0
votes
1 answer

How to Insert the same records in same table with different value under Id column? (Note : ID is primary key autoincrement column )

Suppose i have table level as ID name abbr countryid 1 None NN 11 2 Middle MD 33 3 Senior SN 33 4 Junior JN 22 No i want to insert the records of countryid 33 in same table with countryid 44 (Countryid 44 will be input…
BTSQL
  • 51
  • 1
  • 4
0
votes
0 answers

STUFF function not retrieving correct results in Production DB

I have the below query working in my local db but not in production. Could anyone please help me out: declare @abc varchar(max) set @abc = (select distinct stuff((select ',' + emp_id from TableA FOR XML PATH ('')),1,1, '') From TableA print…
UshaVemula
  • 1
  • 1
0
votes
1 answer

Select one of two distinct boolean values

I have a column that is a bit. I want to update all the records to 1 if 1 is present in that column. When the query runs and there are no 1 in the column it returns 0 as I expect. If it is all 1 it returns just 1 as I expect. However, if there is a…
The OrangeGoblin
  • 764
  • 2
  • 7
  • 27
0
votes
1 answer

SQL Server 2017 installation failed

When I try to install SQL Server 2017, I get an error: This Screenshot I did delete SQL Server 2008 R2 and c++ redistributable 2017, but the error is the same. And this is the log folder screenshot I don't know how to use the log folder
ahmad johan syahputra
  • 3
  • 2
0
votes
1 answer

Any solution for error code 1603 in SQL Server 2017 installation?

I installed some SQL Server Instances in 2005 and 2016 version. Now, I am trying install 2017 version, but I get the following message: === Verbose logging started: 07/09/2018 15:08:25 Build type: SHIP UNICODE 5.00.10011.00 Calling process:…
Sergio Rodríguez González
  • 91
  • 2
  • 11
0
votes
1 answer

Microsoft SQL Server Login Stuck

I have a Microsoft server 2012 running Microsoft SQL Server 2017 Express database. I am trying to log in through SQL Server Management on a remote machine but the log in loads forever and gives no error. If I put in the wrong username and password…
jrocc
  • 1,274
  • 2
  • 18
  • 48
0
votes
3 answers

Is there a SQL equivalent of return?

Consider the following bit of SQL SET DATEFORMAT ymd SET ARITHABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON SET NUMERIC_ROUNDABORT, IMPLICIT_TRANSACTIONS, XACT_ABORT OFF GO USE…
Dom Sinclair
  • 2,458
  • 1
  • 30
  • 47
0
votes
2 answers

SQL Server version error while attaching a mdf file

TITLE: Microsoft SQL Server Management Studio Attach database failed for Server 'DESKTOP-MR6JCUA'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. …
keshav bhadel
  • 1
  • 4
0
votes
1 answer

Set two primary keys but reset the second primary key for each first primary key value - SQL Server

I am trying to make a comment section for products. I am setting two primary keys, the CommentID and the ProductID for the Comments table. But what I want to do with the primary keys is as follows: for each ProductID, the CommentID should start…
Tinaira
  • 727
  • 2
  • 7
  • 23
1 2
3
4