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

Search for string in a text column and list the count

Ok, I may be asking very stupid question but somehow I am not able to get a way to perform the following. I have a table that contains two columns as…
Youbaraj Sharma
  • 1,295
  • 3
  • 17
  • 34
2
votes
2 answers

How can I resolve the "LOCALDB_ERROR_AUTO_INSTANCE_CREATE_FAILED" error after installing SQL Server 2014 Express LocalDB?

I have been using SQL Server 2012 and Visual Studio 2013 on Windows 8.1. All working fine. Recently I installed SQL Server 2014 Express LocalDB. After installing, I am not able to work with LocalDB. I get odd errors, one I get is…
Yooakim
  • 1,717
  • 2
  • 13
  • 21
1
vote
0 answers

How to calculate the status of a task within a week

I want to calculate the status of a task against end date. In my codes below in completed column it's displaying A = 0 instead of A = 1 as my result. ID EndDate Task Status A 2023-06-11 Analysing In progess B 2023-06-11 Developing Not…
User_K47
  • 49
  • 4
1
vote
0 answers

I am trying to send email using smtp to multiple users from asp.net core web api with angular 2.0. but its throwing CORS error

bellow is my error: Access to XMLHttpRequest at 'https://localhost:44359/api/ClientCandidateBulkStatusUpdate' from origin 'http://localhost:4200' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested…
Rakhi
  • 11
  • 2
1
vote
1 answer

SQL Server : query to get table data (count) from another table as VIEW

I have 4 tables, MASTER, TRANS1, TRANS2 and TRANS3. I want to get count by USERID in table MASTER from tables TRANS1-3. This show tables for references. Master table: USERID REF -------------------- 1 Alfa 2 Beta 3…
FannyKaunang
  • 91
  • 1
  • 8
1
vote
1 answer

select record after interval of at least 1 minute

I have an application that logs data after around 1 second if the packet is healthy which means the logging is not guaranteed. Now the client wants to see the log data only with the gap of at least 1 minute. For example, this the sample schema and…
Harsh Shankar
  • 506
  • 5
  • 16
1
vote
1 answer

Running SSIS automatically with pat file

I created an SSIS package in visual studio 2015 with a couple SQL execute tasks, a data flow task and a script task. Since I am using SQL Server 2014 Express edition, I want to be able to schedule running the package using a pat file. What I found…
user2823833
  • 95
  • 2
  • 9
1
vote
0 answers

Fatal error: while accessing SQL Server Tables

I am getting following fatal error while accessing data from SQL Server 2014 through PHP Script. Fatal error: Uncaught PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The SELECT permission was denied on the…
Two - T
  • 11
  • 2
1
vote
1 answer

How to filter XML data based on an attribute using XQuery

Given the below XML structure, I need to filter out all the question nodes whose value is equal to ABC, and whose
Rudolf Lamprecht
  • 1,050
  • 1
  • 14
  • 37
1
vote
2 answers

SQL Server trigger is stuck on executing

I am trying to run a batch file in a SQL Server trigger to get information from a query and put it in a text file. I am trying to do this because I want to do stuff with the information in that same batch file later on. The problem is that when the…
user4356
  • 11
  • 2
1
vote
1 answer

Pull NULL if column not present in table while UNION SQL Server

I am currently building a dynamic SQL query. The tables and columns are sent as parameters. So the columns may not be present in the table. Is there a way to pull NULL data in the result set when the column is not present in the table? ex: SELECT *…
Rathan Gopi
  • 25
  • 4
1
vote
1 answer

SQL Server 2014 Express does not show newly created table

I created a table using the create table command but it does not show up in the object explorer. I have tried refreshing both the explorer and IntelliSense but it still does not show up. The table is present in the database I confirmed that by…
Tanmay Bhatnagar
  • 2,330
  • 4
  • 30
  • 50
1
vote
0 answers

SQL server installation doesnt start

I have downloaded Microsoft SQL server 2014 express and I can't launch the setup. When I start the installer, it shows me an error box with no description.
A. Shawkat
  • 17
  • 6
1
vote
1 answer

SQL Msg 7303, Level 16, State 1, Line 3 Cannot initialize the data source object of OLE DB provider "VFPOLEDB"

I have a 32bit SQL Server 2014 Express (BenVM) set up on a virtual machine running Windows 7 64bit. This instance of SQL Server has a linked server connected to it called MSCRIBE2 using the VFPOLEDB (foxpro) provider. From my virtual machine I am…
Ben
  • 37
  • 1
  • 7
1
vote
1 answer

Create the stored procedure to compare records and update system generated record

I want help for this: I have 4 vehicle records from different users: vehicle_id vehicle_name vehicle_number date_update usr1 10 My Ferrari 1000 NULL usr2 11 My Ferrari 1000 …
Akshay Thakur
  • 33
  • 4
1 2 3
…
22 23