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
3 answers

Grouping of columns with comma separated and padding extra blanks in SQL Server

I have a table with similar data as below Label Value ColorCode -------------------------- M1 0.5 #C71585 M1 1.5 #808080 M2 1 #C71585 M2 2 #C71585 M2 1.6 #FFC0CB M3 3 #9400D3 I want…
CrazyCoder
  • 2,194
  • 10
  • 44
  • 91
1
vote
1 answer

Changing a column from NULL to NOT NULL in SQL Server

I am trying to change a column from NULL to NOT NULL in SQL Server 2014. This is my code: ALTER TABLE purchase_order_line ALTER COLUMN pol_sl_id INT NOT NULL However, I am prevented from doing so by the following error message: Msg 5074, Level 16,…
Jeremy Morren
  • 615
  • 9
  • 23
1
vote
1 answer

SQL UPDATE SET one column to be equal to 0.000 when there are two identical values

So here is the problem i'm trying to update column distance, first to sum the distance for each ownerID and after when there is a record with the same id address the first record should memories thee distance and the second should be 0.000 This is…
johnnyReed
  • 35
  • 4
1
vote
1 answer

How to resolve "Storage Engine Operation Failed" with Microsoft.Sync?

I have developed a synchronization software that will sync Databases and Directories using Microsoft Sync Framework 2.1. After a while a client using the application gets this error : A storage engine operation failed with error code 25104…
Oussama melki
  • 66
  • 6
1
vote
1 answer

How to create Link server to connect Oracle database?

I just used this command to install OraOLEDB.Oracle install.bat all c:\oracle odac I've tested .udl file it's working fine!!! But when I test link sever I'm getting error. SQL SERVER Information as below Microsoft SQL Server 2014 - 12.0.2000.8…
Syan
  • 137
  • 1
  • 5
  • 17
1
vote
1 answer

Updating Model from Database EF6

Following from my old question in which I used SQL server and Entity framework. As in initial stage I set address id as not null in database and similarly I also created a parameter user id in address field which is also not nullable. Now I am stuck…
Rohit
  • 552
  • 3
  • 15
1
vote
1 answer

Mail queued but not delivered in SQL Server 2014

I am trying to send the result of a SQL query through email using SQL Server 2014. The problem is that the e-mails are getting queued, but are not delivered to the recipient. There are some issues with the connectivity to the server. The description…
aneri
  • 11
  • 1
  • 2
1
vote
0 answers

Pentaho: Relational database discarding relation while migrating

From: MS SQL Server 20014 To: My Sql server migrating a table from MS SQL which is having dependency in another table is happening to MYSQL discarding relation. Are there any way to create table along with relation.
gophervk
  • 67
  • 8
1
vote
0 answers

How do I access my sql server 2014 express adv from another computer?

Cannot connect to ITADMIN\SQL2014. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct…
sujith Augustine
  • 11
  • 1
1
vote
0 answers

The request failed with HTTP status 401: Unauthorized in Report Server

I am creating ASP.NET Core Web Application and I am using ReportViewer to view a report that is hosted on another server. I am trying to connect to the server but i get this error "The request failed with HTTP status 401: Unauthorized" and I don't…
A. Savva
  • 632
  • 10
  • 30
1
vote
1 answer

SQL Server 2012/2014 Express setup.exe fails on WS2012 R2 when run in quiet mode

I downloaded SQLEXPR_x64_ENU.exe and extracted its content (/X option) into a temp folder. I then attempted to run setup.exe in a quiet mode. Unfortunately the setup failed. Here is the command line that I used to install the server and the output…
bdristan
  • 1,048
  • 1
  • 12
  • 36
1
vote
1 answer

OUTPUT in Dynamic SQL

The following sql query is part of the query I have. The idea is that there will be a loop (cursor) over the result set inserting records one by one in another table. It is dynamic sql because of reasons not entirely known to me, but which I have to…
AyatollahOfRockNRolla
  • 147
  • 1
  • 9
1
vote
1 answer

Database restore from .bak

In my current project there is a need to restore a database using wix installer, previously I had managed to work-around this is issue by creating a .sql script of the DB which was 5-10MB. Now I have a .bak file around 1GB and with .sql is 2.8GB, I…
Dimitris Batsougiannis
  • 739
  • 4
  • 14
1
vote
2 answers

SQL rounding does not appear to work as expected

I have the following SQL query. DECLARE @StartDate DATE ='20160101' , @EndDate DATE = '20160331', @Box1 DECIMAL, @Box2 DECIMAL, @Box3 DECIMAL, @Box4 DECIMAL, @Box5 DECIMAL, @Box6 DECIMAL, @Box7 DECIMAL, @Box8 …
Dom Sinclair
  • 2,458
  • 1
  • 30
  • 47
1
vote
1 answer

Convert lastname, firstname middleinitial to different columns in sql

I currently have a column named PersonFullName. It has data in it like this: PERSONFULLNAME Doe, John A Doe, Jane M Doe, Eric I am wanting to get the data in this format: LastName - FirstName - MI DOE - John - A DOE …
Albert Vincent
  • 51
  • 9
1 2 3
…
22 23