Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.
I need to add a specific column if it does not exist. I have something like the following, but it …
sql-server sql-server-2008 tsql sql-server-2012 sql-server-2016Under SQL Server, is there an easy way to filter the output of sp_who2? Say I wanted to just …
sql-server sql-server-2016I want to move a table into a specific Schema using T-SQL? I am using SQL Server 2008.
sql-server sql-server-2008 tsql schema sql-server-2016I am trying to parse out a value from a string that involves getting the last index of a string. …
sql sql-server sql-server-2016When trying to install SQL Server 2016 Express in Windows 7 Professional x64 SP1 in VMware I get the following message. What …
sql-server installation windows-7 sql-server-2016 windows-7-x64I need to replace multiple characters in a string. The result can't contain any '&' or any commas. …
sql replace sql-server-2016I'd like to select everything AFTER a certain character (-) that is placed on the most right side. Eg. abcd-efgh-XXXX …
sql sql-server-2016I think the answer is no but I'm looking to give someone access to a SQL Server database but I …
sql-server permissions sql-server-2016 grantI am using Visual Studio 2017 and SQL Server 2014. While attaching a database file to Visual Studio, I get this error: "" …
c# sql-server visual-studio-2017 sql-server-2014 sql-server-2016I've downloaded and installed SQL Server 2016. When I attempted to use the STRING_AGG function I receive this error. Here …
sql sql-server sql-server-2016