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

Is there a way to launch a stored procedure before and after every SSIS package?

I'm looking for a way - either using in-built SSIS functionality or custom-built (3rd party software or internally-coded) - to "wrap" every executed SSIS bundle with specific code, e.g. launch certain SQL procedures prior to and after all execution…
Alex
  • 73
  • 3
5
votes
4 answers

How to parse JSON column to a table with TSQL

I am trying to open up a JSON string and have each key to be its own column. The JSON column lives in a Metadata table with key and polymorphic id. I want to be able to parse every key into its own column with its corresponding value populated for…
Duyan Zhen
  • 95
  • 2
  • 4
5
votes
2 answers

Alter failed for ProxyAccount 'yyy' (Microsoft.SqlServer.Smo)

I am running into an issue when trying to script the creation of a credential and related proxy in Microsoft SQL Server Management Studio. My script is the following: CREATE CREDENTIAL xxx WITH IDENTITY = 'domain\xxx', SECRET = '*******'; EXEC…
Cody
  • 161
  • 7
5
votes
3 answers

Change data type from varchar to nvarchar for a table which has a large amount of data

I need suggestions on how I would best go about changing a column's data type from varchar to nvarchar for a table which has 500 million records. Thanks in advance.
Panda1122
  • 101
  • 1
  • 10
5
votes
2 answers

How to separate variables and values, then insert in a table?

Problem A stored procedure is receiving list of variables and values, and the delimiter. This stored procedure needs to insert those in a table. --Example table create table #tempo ( Variable1 int, Variable2 int, Variable3 int ) These…
Farhan
  • 2,535
  • 4
  • 32
  • 54
5
votes
1 answer

Selectivity estimation error on a simple query

Let us have a simple table tt created like this WITH x AS (SELECT n FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) v(n)), t1 AS ( SELECT ones.n + 10 * tens.n + 100 * hundreds.n + 1000 * thousands.n + 10000 * tenthousands.n as id FROM x…
Radim Bača
  • 10,646
  • 1
  • 19
  • 33
5
votes
1 answer

Match inflectional forms of words in a particular order with SQL Server full-text search

I'd like to use SQL Server full-text search to find inflectional forms of words that occur in a specific order. So the words method and apparatus would match These are the methods I'm using with the apparatuses but not This apparatus is used with…
rory.ap
  • 34,009
  • 10
  • 83
  • 174
5
votes
1 answer

Incorrect Syntax near the keyword 'OR' in CREATE OR ALTER PROCEDURE

I have a master script that runs and create all stored procedures, but when I run the script I error out at the only two places that use the syntax CREATE OR ALTER PROCEDURE The code is below: CREATE OR ALTER PROCEDURE…
Benny
  • 155
  • 3
  • 15
5
votes
1 answer

How to insert data using stored procedure after encrypted column using Always Encrypt option?

I am using sql server 2016 and i have encrypted the column using always encryption option. I have connected sql with entity frameworking in ASP.NET MVC application. The dats are inserting properly using insert option. But i cant able to insert using…
Melody
  • 1,203
  • 2
  • 17
  • 28
5
votes
3 answers

How to add HIDDEN property on column?

When temporal table is created, we need to defined start and end date time columns which can be hidden - not visible in SELECT * or INSERT without columns. I want to add one more column, which will contain information about the user who has commit…
gotqn
  • 42,737
  • 46
  • 157
  • 243
5
votes
4 answers

Sql group by latest repeated field

I don't even know what's a good title for this question. But I'm having a table: create table trans ( [transid] INT IDENTITY (1, 1) NOT NULL, [customerid] int not null, [points] decimal(10,2) not null, [date] datetime not…
Mc Kevin
  • 962
  • 10
  • 31
5
votes
1 answer

Spatial Intersect of two SQL Server layers/tables

I need to do a spatial intersection between two spatial tables with a geometry column in each within SQL Server 2016. I have a piece of T-SQL where I take a single set of polygons from one table (tableA), and then use each polygon and perform a…
user3047431
  • 91
  • 1
  • 4
5
votes
1 answer

SQL Server CTE with multiple delete statements

I have a CTE: ;WITH DeleteTarget AS ( .... ) How do I use this CTE for two delete statements - maybe like: DELETE FROM [TableA] WHERE ColumnA IN (SELECT Id FROM DeleteTarget) DELETE FROM [TableB] WHERE ColumnB IN (SELECT Name FROM…
Max
  • 4,439
  • 2
  • 18
  • 32
5
votes
0 answers

Create User in dacpac deployed by SqlPackage.exe leads to login failed SqlException

Problem I'm trying to automate SQL deployment including User and Roles. It works when I create the user in Sql Management Studio, but when I deploy dacpack I get SqlException: Login Failed for user 'MyUser' Description I have SQL Server 2016…
Liero
  • 25,216
  • 29
  • 151
  • 297
5
votes
1 answer

How to insert JSON object to SQL Server 2016 as nvarchar

I want to insert a few JSON objects into my SQL Server 2016 table. My table structure is as follows: field type nullable default name | nvarchar(max) | true | Null age | nvarchar(max) | true |…
KnightCavalry
  • 377
  • 1
  • 6
  • 17
1 2 3
…
99 100