Stack Overflow
Stack Overflow

Questions tagged [sql-server-2014-express]

For questions specific to the scaled down, free edition of SQL Server 2014

Microsoft SQL Server 2014 Express is free and contains feature-rich editions of SQL Server that are ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs.

The SQL Server 2014 Express release includes the full version of SQL Server 2014 Management Studio. For a complete list of supported features in SQL Server Management Studio, see Features in SQL Server Management Studio.

Source: Microsoft (SQL Server 2014 Express)

334 questions
-1
votes
3 answers

Count and Sum consecutive records with minimum value

I have a table that shows payments for clients summarized by months. It looks like this: Client | Month1 | Month2 | Month3 | Month4 | Month5 | Month6 ------------------------------------------------------------ x1 | 100 | 200 | NULL |…
Peraklo
  • 79
  • 2
  • 3
  • 18
-1
votes
1 answer

Copy Database using SQL Server 2014 Management Studio Express

I want to quickly overwrite one database with another (preferably using the GUI in Management Studio). Basically I have DB1 and DB2. DB1 is an older version of DB2 which I need to overwrite, so DB1 = DB2. I have tried the following; Right Clicking…
Matthew Flynn
  • 3,661
  • 7
  • 40
  • 98
-1
votes
2 answers

Query to return single instance of an item

Here is what I want to accomplish: I have a table that stores the computer name in one column and a a software title in another. The computer name can be listed numerous times based on how much software is installed. There are also multiple…
GarudaLead
  • 469
  • 1
  • 5
  • 18
-1
votes
1 answer

Problems with connecting locally to SQL Server 2014 Express

I can't connect to my locally DB, it's working fine on the live version. Live version is SQL Server 2012 and test enviroment is SQL Server 2014 Express. I'm using Web Matrix 3 and a Visual Studio 2013 debugger attached to the process, but I've tried…
Alex Sleiborg
  • 95
  • 6
-1
votes
1 answer

SQL Dynamic query returning date for a varchar variable

This procedure should return the prior day based on @refdate. If I only execute this select on DB it works perfectly, but something is wrong in my procedure code. alter procedure [dbo].[SavePosition] (@Refdate as varchar(15) =null) as begin try set…
Flib
  • 165
  • 3
  • 14
-1
votes
2 answers

SQL Server : Authorize User not in domain

I have notebook with Windows 8 and SQL Server 2014 Express installed. The authentication mode is set to Mixed Mode (Windows + SQL Server authentication). I need to create a new SA user for my friend in order to let him work on my database. We are…
DarioN1
  • 2,460
  • 7
  • 32
  • 67
-2
votes
1 answer

I want to a get Result in SQL Server Using UNION and Group ignore 0

Here is my code DECLARE @Fromdate date = '2021-06-5'; DECLARE @Todate date = '2021-06-5'; DECLARE @till01 varchar(200) = 'ST-LO-01'; DECLARE @till02 varchar(200) = 'ST-LO-02'; DECLARE @till03 varchar(200) = 'ST-LO-03'; DECLARE @till04 varchar(200) =…
Waqar YousufZai
  • 37
  • 10
-2
votes
1 answer

Microsoft SQL Server 2014 too many services

I have a problem. I can't start SQL Server 2014. It's ok when I connect to a server as a Windows authentication, but when I try to connect as SQL Server authentication with username sa and my password, O get a SQL Server error 18456. Why? When…
sabadvali
  • 25
  • 1
  • 4
-2
votes
1 answer

Delete user in SQL Server database

I am executing this code to create user in my database. CREATE LOGIN john WITH PASSWORD = 'john123'; GO USE mytestdb; GO CREATE USER [john] FOR LOGIN [john] GO ALTER USER [john] WITH DEFAULT_SCHEMA=[dbo] GO ALTER ROLE [db_datareader] ADD MEMBER…
jemz
  • 4,987
  • 18
  • 62
  • 102
-2
votes
1 answer

Sign In page using SQL SERVER, JAVA, Servlets, Eclipse

Here is my code, it is connecting to database, in the console I could see the msg "connected" but the problem is after giving the user credentials it is not navigating to the next page(welcome.jsp) and it just shows a msg that "username or password…
gupta k
  • 23
  • 1
  • 9
-2
votes
1 answer

SQL Server service does not start at start up

I have a fresh windows 10 installed computer, and I have installed SQL Server 2014 express. The service is set to automatic, but when I reboot the computer the service is stopped and I have to start manually. The installation is a local installation…
Álvaro García
  • 18,114
  • 30
  • 102
  • 193
-2
votes
1 answer

SQ Server : how to find the fifth order for each customer

How to find the fifth order for each customer and return title_order or null if the customer doesn't have the fifth order Tables are customer with columns Id, firstname, lastname... order with columns order_id, title_order, id_custmer,…
Mona
  • 1
-3
votes
2 answers

SQL Server 2014 Express performance tweaks

I have a few customers who are running a third party program and they often complain of slowness when the program searches and even freezes at points. The computers are running i7 3.2ghz with 16 GB memory on a 1 terabyte hard drive. The performance…
KingSchmoyer
  • 13
  • 1
  • 4
-3
votes
1 answer

Transpose rows into columns in sql server

I have the output like below after parsing XML Name Type Value doccreated datetime 2017-05-05 docmodified datetime 2017-05-06 version varchar(10) 3.1.42 doccreated datetime 2017-04-11 docmodified datetime …
M Sundaram
  • 1
-3
votes
1 answer

How to combine a loop in a subquery in SQL?

I am trying to make this automated with a loop where I define an beginning and ending time period @t_begin , @t_end starting from 0 to 24 for example. CURRENTLY, I am putting all these codes one by one, and for ending t=60 for example, I need to…
EMRE
  • 41
  • 6
1 2 3
…
22
23