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

Access multiple instances in SQL Server

There are two instances of SQL Server installed on my PC. Version 11 and 13. for accessing version 11, I enter .\ in a server name for accessing version 13, I enter (LocalDB)\MSSQLLocalDB When it comes to IP address I enter 192.168.1.104 (my IP)…
abhi
  • 45
  • 2
  • 10
2
votes
2 answers

How to handle async data in ngOnInit (routing with parameter) Angular 4

I am trying to load data from my web api controller. Currently I am using my API service which I call from the ngOnInit function of the component. But, nothing return in the view because it's an asynchronous data Web api…
Noura Messaoudi
  • 21
  • 3
2
votes
3 answers

Node js connection string not accepting backslash (\) in for SQL Server

I have connection string in node js for SQL Server as following: var webconfig = { user: 'sa', password: 'aman', server: 'Aman\AMAN', database: 'Demo', options: { encrypt: false // Use this if you're on Windows…
Amandeep Singh
  • 372
  • 6
  • 20
2
votes
4 answers

Distinct In SQL Query resulting duplicate Values

In my database there is multiple entries from same employee so I would like to get the Latest entry by way of identifying the auto number field. But using below sql code with distinct in eno is resulting duplicate entries. SELECT distinct(eNo),…
Sixthsense
  • 1,927
  • 2
  • 16
  • 38
2
votes
4 answers

How to Describe table in SQL Server 2014

I am using SQLSERVER 2014 Express and I created Employee Table I want to know the details Description for the Employee Table like NULL or NOT NULL and Datatypes In Oracle we have desc Employee like any syntax? Please help me
Hemanthkumar Naik
  • 151
  • 1
  • 3
  • 11
2
votes
2 answers

How to get return value from stored procedure in Windows form C#

This is my procedure: DECLARE @ReturnValue int SELECT @ReturnValue = idUser FROM Users WHERE Alias = @UserAlias AND Password = @UserPassword RETURN @ReturnValue This is my C# code where I'd hope I could retrieve the value from the…
walkman
  • 478
  • 1
  • 8
  • 21
2
votes
2 answers

Query speeds using Access front with SQL backend

I have been working on converting an Access database over to MS SQL. For my initial testing I have imported the back end data onto my system with SQL Server Express 2014. So far I have been able to get everything to work with my Access front end…
vxd128
  • 71
  • 10
2
votes
1 answer

Incompatibility error message when viewing a Table Data

I'm currently using Microsoft VS 2012 along with Microsoft SQL Server 2014 Express. I'm trying to work with an existing SQL Server database that I originally obtained as a .bak backup file and had to restore it into my own server. So adding the said…
Ahmed Aboumalek
  • 613
  • 4
  • 21
2
votes
1 answer

C# application on a shared drive / site / what else?

Hello all, I just created a C# application that connects to a server database, it can insert, update, search, delete the files from the database, more than this I can view all the files in a listview. I have encountered the following problems: 1) I…
Norbert Forgacs
  • 605
  • 1
  • 8
  • 27
2
votes
1 answer

SQL Server "pseudo/synthetic" composite Id(key)

Sorry but I don't know how to call in the Title what I need. I want to create an unique key where each two digits of the number identify other table PK. Lets say I have below Pks in this 3 tables: Id Company Id Area Id Role 1 Abc …
Flib
  • 165
  • 3
  • 14
2
votes
3 answers

Insert null excel cell as a blank cell in database

I have a simple button event to import excel sheet into the database. The piece/part of code is like this.. private void button6_Click(object sender, EventArgs e) { OpenFileDialog theDialog = new OpenFileDialog(); theDialog.Title…
Vik
  • 89
  • 2
  • 13
2
votes
1 answer

show the first SQL row in jTable in java

jTable doesn't show the first row. I created SQL table with list of files in directory and show in jTable in Java. I see the table, but I cant see only the first row. Example: In directory I have 20 files. code insert into the SQL table all of 20…
Xhyzors
  • 43
  • 5
2
votes
1 answer

How is the memory used greater than the SQL Server Express limitation?

Microsoft tells me that SQL Server 2014 Express should have Maximum memory utilized (per instance of SQL Server Database Engine) of 1 GB. Whenever I run this simple script to tell me the Physical Memory In Use I get 4 GB. SELECT…
Mark
  • 1,455
  • 3
  • 28
  • 51
2
votes
1 answer

Tools for Building an OCA (Occasionally Connected Application) 2015

This question has been asked before, but the times and technology seemed to have dramatically changed, so I find the need to ask again. The changes being: * Compact 3.5 SP2 is deprecated (soon to be no support) * Compact 4.0 does not support…
mson
  • 7,762
  • 6
  • 40
  • 70
2
votes
3 answers

SQL, How to loop for a date list using each as parameter for an Procedure?

I have an Procedure that receives an specific date as parameter ie Exec ProcDB '20150428' frequently I need to run this procedure for many dates and usually I retype Exec ProcDB 'date1' GO Exec ProcDB 'date2'go..... I think it's not smart, so I can…
Flib
  • 165
  • 3
  • 14
1 2
3
…
22 23