SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Counting Instances in TEXT

  Hello Community, I have been presented with the following SQL challenge Find the number of times th…

  carlton 84646

  5 replies

  5 years ago

  By: carlton 84646

• Copy tables from one db to another db

  I have a user that needs to truncate a number of tables in DB2 and then make a backup of some table…

  LinksUp

  7 replies

  5 years ago

  By: Michael L John

• Return incorrect numeric value

  Hello, I have make this query to return the max numeric value from the right for adding +1 : SELECT…

  luissantos

  4 replies

  5 years ago

  By: luissantos

• VBA/VBS Insert Into Always Encrypted Column

  Hello~ I work on an application (Azure SQL Server Back End/MS Access Front End), and have been task…

  EsquireDeveloper

  2 replies

  5 years ago

  By: EsquireDeveloper

• BCP - Export Query to Tab Delimited Text File

  Dear Group: I am using SSMS and trying to export a query to a text file using T-SQL (I know there a…

  AMCity

  4 replies

  5 years ago

  By: frederico_fonseca

• Dense_Rank function issue. Unable to Rank Field in Descending order

  Hello Community, I'm trying to obtain the following output from a dataset:   I have compiled …

  carlton 84646

  3 replies

  5 years ago

  By: Phil Parkin

• Script to automate sync logins in Always on Replicas

  Hi, I looking for a script to have a nightly job to sync newly added logins in Always on replica? C…

  gary1

  3 replies

  5 years ago

  By: Sreejith!

• Bulk Insert not working for dataset

  Hello all, Maybe this is my own ignorance showing, but I think I've hit a brick wall. I can't seem …

  logan.keister

  17 replies

  5 years ago

  By: Mathison852

• Trying to figure out a set-based approach to a stock eta problem

  Due to the pandemic, the shipping/receiving of products has been a bit delayed.  This delay has cre…

  logitestus

  2 replies

  5 years ago

  By: logitestus

• Transactions

  Hi, Can you please let me know what is the benefit of using the 'SET IMPLICIT_TRANSACTIONS ON' in t…

  sizal0234

  6 replies

  5 years ago

  By: The Dixie Flatline

• Empty Index Statistics object

  This is a new thread but relates directly to https://www.sqlservercentral.com/forums/topic/index-st…

  AnzioBake

  3 replies

  5 years ago

  By: AnzioBake

• Index statistic is empty - how is this possible?

  I have a simple index on a table - just one column in the index plus one included column. There is …

  shaun.stuart

  9 replies

  5 years ago

  By: AnzioBake

• Help with OPENJSON for Google Maps API data

  Hello, I'm a newbie when it comes to JSON so when I started down the road of trying to retrieve dat…

  tacy.highland

  5 replies

  5 years ago

  By: Mark Cowne

• GRANT CREATE SEQUENCE syntax error

  Hello experts, I am getting this error Msg 102, Level 15, State 1, Line 6192 Incorrect syntax near …

  webrunner

  3 replies

  5 years, 1 months ago

  By: webrunner

• SQL Query execution plan sort operation

  Hi All, Could you please let me know what could be the cause of having 58% sort operation in Insert…

  yuvipoy

  4 replies

  5 years, 1 months ago

  By: yuvipoy