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
vote
2 answers

SQL Query from database schema with functional dependences. Normalization

I'm supposed to write a SQL query from given schema: BookAuthors (ISBN, authorName, gender, title, yearPublished, pubId, pubName, phone) FD = { ISBN -> title, pubId, yearPublished; authorName -> gender; pubId -> pubName, phone } Here's what I…
Veasst
  • 37
  • 6
1
vote
1 answer

Correct sql syntax for this Update Procedure

I have three tables: LandingDetails with fields LandingId, ProductId and UnitPrice LandingHeaders with fields LandingId and LandingDate Products with fields ProductId and CostPrice I wish to udate the LandingDetails UnitPrice from the costprice in…
Dom Sinclair
  • 2,458
  • 1
  • 30
  • 47
1
vote
0 answers

Moving records from SQL Server 2014 to 2005 database

I have 917419 records in a table in a SQL Server 2014 database. I want to move theses records into a SQL Server 2005 database. I have generated script into a file using "generate and publish wizard" for one table, and I ran the script file into…
Vijeeshkumar vofox
  • 441
  • 2
  • 5
  • 17
1
vote
1 answer

Enable remote connections for SQL Server 2014 Express

I have a SQL Server 2014 Express installed and I want to allow remote connections. I have read this answer, but I can't find the configuration manager installed on the system. So my question: where can this configuration be done?
etalon11
  • 895
  • 2
  • 13
  • 36
1
vote
3 answers

SQL Server 2014 Express .MSI for LocalDB failed to install on a target vm

Post was rewritten after additional investigation. The error message was: Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation. The…
Alan
  • 1,587
  • 3
  • 23
  • 43
1
vote
0 answers

An exception of type 'System.Data.SqlClient.SqlException' error occurred in System.Data.dll

I am making telephone dairy and one error is coming An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Please tell me where I am doing wrong this is my code error comes in this line con.Open(); using…
Cesar
  • 7
  • 3
1
vote
1 answer

Restoring SQL Server 2008 R2 *.bak databases on SQL Server 2014 Express

I recently changed my SQL Server 2008 R2 (10.50.1600.1) to SQL Server 2014 Express (12.0.4100.1 - with service pack 1). Now I would like to restore *.bak files that I have created on SQL Server 2008 R2. First of all I can't see my *.bak files in…
Dear Deer
  • 515
  • 1
  • 11
  • 29
1
vote
2 answers

SQL cant create column for TIMESTAMP for SQL server 2014

I'm having trouble creating a column in a table with the following query: alter table Items add ModifiedTime timestamp not null default current_timestamp on update current_timestamp; I get this error: Msg 156, Level 15, State 1, Line…
Mikael
  • 35
  • 1
  • 7
1
vote
0 answers

Connect to MS SQL 2014 via PHP with MD5 password

I'm connecting to MS SQL Server 2014 via PHP and sql_srv: "TDB", "UID"=>"TEST", "PWD"=>"1234"); $conn = sqlsrv_connect( $serverName, $connectionInfo); ?> As you can see,…
Venique
  • 11
  • 2
1
vote
2 answers

SQL Server: delete rows which does not have a parent (based on 2 columns join)

I am trying to delete entries from child table (accidents) which have not parent (location). If I understand correctly, I cannot have these rows in case I want to create a relationship between these two tables (one to one/many instead of one/zero to…
B Sienkiewicz
  • 13
  • 2
1
vote
1 answer

What are the practices when converting column data type in SQL Server Express 2014?

I just recently hit the 10GB DB limit in SQL Server Express and am looking to drop unnecessary columns, and convert other columns to less heavy data types. I have 29 columns, and just shy of 50M rows. Of that 29, 20 are floats, and only 10 of them…
ijustlovemath
  • 703
  • 10
  • 21
1
vote
1 answer

Very Strange SqlClient error with SmallDatetime parameter in SQL Server 2014 stored proc

I've been stumped with the following error for the past hour: "Procedure or function 'write_call' expects parameter '@Date', which was not supplied." The @date parameter is a smalldatetime. I am trying to pass the value #1/27/2009 04:32:00 PM# I am…
Charles Okwuagwu
  • 10,538
  • 16
  • 87
  • 157
1
vote
1 answer

Visual Studio 2015 express / SQL Server 2014 Express

Can I use Visual Studio 2015 Express and SQL Server 2014 Express to develop an application for commercial issue? Can you please show me the licenses? I know that you can use Visual Studio 2013 Express for a commercial issue but for 2015 I was…
xAminex
  • 393
  • 2
  • 6
  • 18
1
vote
1 answer

Msg 10300, Level 16, State 2, Line 1 in SQL Server 2014

Unable to create Assembly [System.Web] in SQL Server 2014. The Query is given below. CREATE ASSEMBLY [System.Web] from 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\System.Web.dll' with permission_set = UNSAFE Throwing an error Msg 10300,…
Musakkhir Sayyed
  • 7,012
  • 13
  • 42
  • 65
1
vote
1 answer

SQL Database Select, Sort, and Eliminate Duplicates without DISTINCT

In a sample SQL database, I've got Invoice Totals and Vendor Names on two separate tables. As a general orientation, here is the current code I've created: SELECT TOP 5 InvoiceTotal, VendorName FROM Invoices JOIN Vendors ON Invoices.VendorID =…
TekGiant
  • 1,132
  • 3
  • 14
  • 29
1 2 3
…
22 23