Stack Overflow
Stack Overflow

Questions tagged [sql-server-2016]

Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.

Microsoft SQL Server 2016 v.13.0.1601.5 Ready To Manufacture (RTM), was released on June 1, 2016.

There are many editions of SQL Server 2016:

1- Entreprise Edition : Comprehensive, mission-critical in-memory performance with unparalleled security, mission critical high availability, an end-to-end enterprise business intelligence solution with mobile BI built in, in-database advanced analytics at scale, and unlimited virtualization with software assurance. Enterprise edition provides the highest scale and performance for Tier-1 workloads.

2- Standard: Find rich programming capabilities, security innovations, and fast performance for applications and data marts. Easily upgra

3- Developer: Build, test, and demonstrate applications in a non-production environment with this free, full-featured set of SQL Server 2016 SP1 Enterprise edition software.

4- Express: Deploy small databases in production environments with this free, entry-level database that’s ideal for building small, data-driven applications up to 10 GB of disk size.

5- Compact: Free, embedded database app for building ASP.NET websites and Windows desktop applications.

6- Web: Secured, cost effective, and highly scalable data platform for public web sites—available to third-party hosting service providers only.

References

3794 questions
1
vote
1 answer

send push notifications in android using firebase

I have three applications. A Content Management System developed using Asp.NET MVC, an Asp.NET Web API application and an Android Application. I have used SQL Server 2016 as my database. The Content Management System and the Android Application…
vinitpradhan18
  • 51
  • 1
  • 10
1
vote
1 answer

SQL Server 2016: How to set up row level security(RLS) for normalized tables

I have three tables MST_EMployee, MST_ProfitCenter and Mapping_Employee_ProfitCenter. I wanted to set up row-level security on the Mapping_Employee_ProfitCenter table. Steps which I am performing to achieve: Step 1: create a table-valued…
Prayag15
  • 393
  • 3
  • 13
1
vote
2 answers

SQL Find Values Between *

I have a strange request, I thikn. I have a system which I need to retrieve data from - its SQL based. The field in question has a multitude of data in it, but I specifically only need 1 or 2 values. In the example below, the field contains values…
Seb
  • 11
  • 3
1
vote
2 answers

Using IS NULL to convert NULL dates

I'm running a query to change some returned data around in SQL Server 2016, and I am getting a conversion error (Conversion failed when converting date and/or time from character string). SELECT jobs.name, CASE WHEN jact.start_execution_date…
brandont
  • 49
  • 1
  • 3
  • 9
1
vote
1 answer

Date format issue between ssl & non-ssl site. IIS & asp.net

IIS 10 , Windows Server 2016 I have a strange issue & am finding it hard to diagnose.. I have a website which is on SSL. I have the same website codebase which is on same server but on a different port but which is not on ssl. Now : 1) From…
Abdul Rehman Sayed
  • 6,532
  • 7
  • 45
  • 74
1
vote
1 answer

SQL Server 2016 For JSON return name

I have a stored procedure with a simple select statement in which I return json: SELECT A, B, C FROM 123 FOR JSON AUTO This works fine. However, the name of the result, if I call the stored procedure, is something like:…
Diomedes
  • 634
  • 11
  • 24
1
vote
1 answer

Stored data set from stored procedure - Execute SQL Task

I have this stored procedure: Dbo.SprocName (@Id UNIQUEIDENTIFIER, @ResponseCode INT OUTPUT, @ResponseDescription VARCHAR(500) OUTPUT) And it returns a dataset called say Result as a nvarchar(MAX) (always a single…
Maria
  • 363
  • 4
  • 13
1
vote
1 answer

Compare (greater than or less than) 1st row value with 2nd row value based on Paid date for the Key, and then check if 3rd row is greater than 2nd

Current result -- Scenario1--For ID 1 and 2, I want to compare if Diff Between (DD,Begin date of ID 2 , End Date OF ID 1) < = 1, then the value should be true and be displayed other wise don't display the value Scenario2 For ID 10 and 11 --…
Avi
  • 1,795
  • 3
  • 16
  • 29
1
vote
2 answers

Insert variables into a SQL Server table in stored procedure

I am trying to insert variables into SQL Server table dynamically inside a stored procedure but I'm not able to accomplish it because of the syntax. Can someone correct me what am I doing wrong in the below code. Thanks. Code I have tried: SET…
Teja
  • 13,214
  • 36
  • 93
  • 155
1
vote
1 answer

SQL: find space between 2 movies and lower the space

I am making a cinema booking aplication. I have to make a schedule that is efficient for the cinema. That means that time(space) between 2 movies should be 0. What I have to do: I have to make a Functionality that can find the max space of 30…
Alegou20
  • 60
  • 7
1
vote
3 answers

"FILESTREAM Access Level" stuck at disabled

SQL Server "FILESTREAM Access Level" is stuck at disabled. I have checked all ways by SSMS and queries. After restart, also my configured value is Full Access but Running value is disabled: Windows 10 Enterprise v1703 Build 15063 Redstone 2
Masoud Ehsani
  • 51
  • 4
1
vote
5 answers

SQL trigger cutting email after @

I have a trigger, that checks if the domain of the email, exists in another table (domain). Table user: +------------------+ +------------------+ | email | | domain | +------------------+ +------------------+ | Joe@gmail.com …
Jelle
  • 758
  • 2
  • 14
  • 36
1
vote
0 answers

Table and Index Partitioning & Filtered Index in SQL Server 2016 SP1

Table and Index Partitioning I am planning to use table partitioning for one of my existing databases. All the tables in the database have a clustered index and a non-unique non-clustered index. The non-unique non-clustered index is built on the…
DBK
  • 403
  • 4
  • 13
1
vote
0 answers

What are the ways to return a result set from a trigger?

My company is about to update our SQL server to 2016. Therefore I am looking through all our triggers (there's a lot!) locating the ones, which return result sets. So far I have checked for "select" (not part of insert, delete, update and variable…
jk1990
  • 341
  • 3
  • 12
1
vote
2 answers

Out of bound of array error while creating Database Diagram SQL Server 2017

I am using SSMS 2017 and my database is SQL Server 2016 Enterprise. An error is being shown while creating a database diagram: The index is out of bound of array How to resolve it? Thank you in advance
Abubakar Riaz
  • 320
  • 8
  • 26
1 2 3
…
99
100