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

Create a stored procedure that would Retrieve, Update, and Delete Records on each Table

CREATE TABLE Person ( ID INT Primary Key Identity (1,1), LastName nVarchar (20) not NULL, FirstName nVarchar (20) not NULL, MiddleName nVarchar (20), BirthDate DateTime not NULL, Age INT not NULL, Check (Age>18) ); CREATE TABLE…
Jezun
  • 79
  • 2
  • 10
-3
votes
2 answers

SQL Query Display the names of the employees and their corresponding department

The following are my CREATE TABLE scripts: CREATE TABLE Person ( ID INT Primary Key Identity (1,1), LastName nVarchar (20) not NULL, FirstName nVarchar (20) not NULL, MiddleName nVarchar (20), BirthDate DateTime not NULL, …
Jezun
  • 79
  • 2
  • 10
-4
votes
1 answer

Is it possible to connect to an mdf file without using a server installation?

As stated in my question, I want to know if it is possible to connect a C# application with a .mdf file without a Microsoft SQL Server installation. I found this one. But it looks a little "old" due the fact that it was created for Visual Studio…
Evosoul
  • 197
  • 1
  • 12
-7
votes
1 answer

How can I write this sql query using entity framework and linq

can I write this below mentioned query with the same concept in entity framework update o set o.Name='NewName' from Organization o Inner join Guardian g on o.OrgRowId=g.OrgRowId where g.IsEnabled=1 and g.OrgRowId=1 Please guide!!! Update As…
Shax
  • 4,207
  • 10
  • 46
  • 62
1 2 3
…
22
23