SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Getting all ancestral parents of a table

  From this link - https://stackoverflow.com/questions/22005698/how-to-find-all-the-dependencies-of-a…

  jaango123

  2 replies

  8 months, 4 weeks ago

  By: Jeff Moden

• Something Odd About CAST/TRY_CAST

  I've got some code that is supposed to generate a unique key by prefixing an integer with a single …

  Chris Wooding

  3 replies

  9 months ago

  By: Jeffrey Williams

• how to query that stores mulit select field data

  Hi everyone, I have a table as below, I would like to strip out the commas in the oppo_SCRMcompetit…

  mathewspsimon

  4 replies

  9 months ago

  By: mathewspsimon

• sqlclient data provider .net provider connection

  I have a task to check the connection managers as part of ssis integration project, now the package…

  jaango123

  5 replies

  9 months ago

  By: Phil Parkin

• Help with index rebuild

  Hi there!  This should make some eyes roll for some of you DBA's out there.  Disclaimer:  I am not …

  dnison-905607

  3 replies

  9 months, 1 week ago

  By: EdVassie

• Tablock to avoid deadlock

  Hi, We have 4 stps. the flow of the stored procedure (stp) is as below stp A is main stp that is ca…

  saum70

  9 replies

  9 months, 3 weeks ago

  By: cyrusbaratt

• Case or LOOKUP Table on Common but simplistic values

  NOTE: I get that this may be too broad a question to answer and if so just say that, I get it. I do…

  YSLGuru

  2 replies

  9 months, 3 weeks ago

  By: ScottPletcher

• string_agg issue

  I have a string_agg line in my code that is bringing back hundreds of duplicates in my service_cd f…

  DaveBriCam

  12 replies

  10 months, 1 week ago

  By: DaveBriCam

• Losing Saved Connections in SSMS 2016

  Microsoft SQL Server Management Studio 13.0.16106.4 Hi , I am used to having saved connections in t…

  HeftSteady

  2 replies

  10 months, 3 weeks ago

  By: Mr. Brian Gale

• Help with to generate Data pattern Sql help

  Need to generate a from and to From to 50 -99 100 -299 300 -- I tried to do the logic ,but its work…

  mnr123

  2 replies

  10 months, 3 weeks ago

  By: Jeffrey Williams

• Can you pass an undeclared variable to a Stored Procedure

  If I have a SP that calls another/different SP can I pass to that second SP a variable that has not…

  YSLGuru

  2 replies

  11 months ago

  By: Dennis Jensen

• Deadlocks with UPDATE statements using serializable transaction isolation level

  We are seeing frequent deadlocks occurring due to a particular stored procedure that is using the S…

  zoggling

  8 replies

  11 months, 3 weeks ago

  By: zoggling

• How To Approach Adding A primary Key To An Existing Table

  In our vendor created/managed DB we have a table that is like an audit table the vendor uses for tr…

  YSLGuru

  10 replies

  11 months, 3 weeks ago

  By: Mr. Brian Gale

• How to get a distinct value from my data set

  Hi, I need help with writing a script that will allow me to pull a distinct value from column A, de…

  skaggs.andrew

  3 replies

  11 months, 3 weeks ago

  By: ScottPletcher

• Error while Simultaneous Switching and BCP in same table

  Hi, Our application is created in VC++. We have House keeping process in which the data from main t…

  saum70

  1 replies

  12 months ago

  By: saum70