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

How to trim a string from a space

I have a field like BestStreet 123/56 and I want to get BestStreet I've tried: LEFT(sd.UliceCP, CHARINDEX(' ', sd.UliceCP)-1)
user5021612
1
vote
4 answers

How to union aggregated queries?

I have a query SELECT CntApp = COUNT(app.ApplicationID) ,r.RegionName ,d.DistrictName FROM dim.Application app JOIN dim.Geography g ON (app.ApplicationID = g.GeographyID) AND (app.CountryId = g.CountryId) JOIN…
user5021612
1
vote
1 answer

Prevent SQL "FOR JSON" from causing duplication

I have a master table Departments. The details table Employees has foreign key pointing back to Departments table. When the simple join query is returned as JSON using the PATH option, it is listing multiple rows for the Department. Whereas when…
Aamir
  • 791
  • 3
  • 15
  • 28
1
vote
1 answer

select 2 table with same column without join

i have 2 table like this ---------tbl1---------------- id | name | lname | 1 j h 2 jj hh and ---------tbl2---------------- _id | name | lname | 1 a b 2 aa bb 3 aaa ccc i…
jh_6990
  • 33
  • 8
1
vote
2 answers

Query XML data in SQL Server 2016 database

I have XML data stored in a SQL Server 2016 database that I need to query a date range in a stored procedure around the PROJECT_END to return the application_ID's …
Bill
  • 1,423
  • 2
  • 27
  • 51
1
vote
0 answers

TSQL error occurs depending on number of rows returned in PIVOT

I stumbled upon very weird behaviour when using PIVOT in MSSQL Server 2016. I'm trying to retrieve data using PIVOT and get an error depending on how many rows are returned from the query. Below is query that I wrote specifically to reproduce this…
Michal L.
  • 111
  • 1
  • 5
1
vote
0 answers

Can't use OData with SQL Server 2016 (DTExec 13)

I've build a simple package that extract data from an OData source. It work with DTExec 12 (SQL Server 2014) but when I deploy to an SQL Server 2016 (DTExec 13) I got a weird error in french : La connexion « Connexion » est introuvable. Vérifier…
JPB
  • 255
  • 1
  • 5
  • 16
1
vote
1 answer

Group by with inner joins returning too many records

A table has a foundStatus column that's a char. I want to return a list of foundStatuses with a count next to each - this works: SELECT foundstatus, count(foundstatus) as total FROM findings f WHERE findDateTime BETWEEN '2008-01-01' AND '2017-06-24…
niico
  • 11,206
  • 23
  • 78
  • 161
1
vote
0 answers

Script Tasks losing code in SSIS 2016 (VSTA 2015)

I have an SSIS package with a number of For Each ADO Loops, each with a single script task, which are usually working fine. However, every so often, the script task will suddenly 'forget' all the code in task. I'm presented with an empty task…
Kevnotec
  • 61
  • 5
1
vote
1 answer

Analysis Services Deployment Wizard 2016

In trying to run the Microsoft.AnalysisServices.Deployment.exe I get the following error Could not load type 'Microsoft.AnalysisServices.ManagementDialogs.TabularProcessProgress' from assembly 'Microsoft.AnalysisServices.ManagementDialogs,…
DenisJC
  • 43
  • 7
1
vote
1 answer

SSMA mysql to mssql

I try to convert mysql data base to mssql, I used SSMA. At first I converted schema from mysql to mssql, then I synchronized it. Finally I migrated data's and faced with these errors: Column 'column1 for example' does not allow DBnull.vallue used…
arman nemat pasand
  • 21
  • 3
1
vote
0 answers

"Value does not fall within the expected range" when adding securables to a SQL Server database user

I'm trying to assign securables against a user, but every time I try and grant permissions on a table-valued function, I get the error: Key cannot be null. Parameter name: key (mscorlib) There is no error when adding stored procedures, views or…
pcdev
  • 2,852
  • 2
  • 23
  • 39
1
vote
1 answer

Use T-SQL Transaction for batch of delete statements?

I have a stored procedure that deletes records from multiple tables. I wish for either all of the delete statements to complete successfully, or none. The actual purpose here is to wipe all data related to a particular user. Note that none of this…
James Wierzba
  • 16,176
  • 14
  • 79
  • 120
1
vote
1 answer

How to reference JSON list value with a variable

I am trying to do this: JSON_VALUE(@jsondata, CONCAT('$.[', @count, '].Name') such that I can reference a value in my json list using a variable, however the JSON_VALUE function requires a string literal for the 2nd argument (JSON Path). Is there…
capitol
  • 15
  • 4
1
vote
0 answers

Windows Server 2016 Active Directory-Detached Cluster - Cannot add a Client Access Point

I am setting up a Windows Server 2016 cluster detached from an active directory (so called Workgroup Cluster, i.e. nodes are not added to an active directory). I cannot add a Client Access Point to the cluster. The error is Unable to determine if…
Alexey F
  • 1,763
  • 14
  • 19
1 2 3
…
99
100