SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SqlBulkCopy class and ROWS_PER_BATCH option

  Hi, we use the SqlBulkCopy class for insert bulks (SQL 2019). Is there an option to set the ROWS_PE…

  alexander.huberti

  1 replies

  4 years, 2 months ago

  By: alexander.huberti

• Database alert if no data added

  Hi friends, I’d like to have your help. I have a SQL Server database, and a table dbo.OnData on it.…

  tsiryelhy

  8 replies

  4 years, 2 months ago

  By: Jeff Moden

• Help in creating a dynamic query

  I want to do a dynamic query whose result is the intersection of several results. I have this table…

  Puiu

  1 replies

  4 years, 2 months ago

  By: Jez-448386

• XML Parsing Problem

  I need to parse the following XML file into columns and rows: <?xml version="1.0" encoding="UTF-…

  SQLJim1

  4 replies

  4 years, 2 months ago

  By: Alan Burstein

• Issue connecting to sql server 2019

  Hi All have been having issues connecting to Sql 2019 server this morning. Please see message I'm g…

  wapunga

  2 replies

  4 years, 2 months ago

  By: Jeff Moden

• Inserting a words from a range randomly into a table

  Im in the process of creating test data Now I have a field in the test data called SerialNo this ha…

  Weegee71

  4 replies

  4 years, 2 months ago

  By: Jeff Moden

• Powershell script to start replication

  Hi all I am looking for an Powershell or C# script that starts an replication which is already conf…

  Inematov

  2 replies

  4 years, 2 months ago

  By: frederico_fonseca

• Deadlocks during concurrent delete operation

  In our environment we have written all our business logics inside a stored procedures. In general, …

  llearnsql

  9 replies

  4 years, 2 months ago

  By: ScottPletcher

• external script for Java

  I have a requirement to make a call to a Java class from stored procedure. How do I get the return …

  vpader

  9 replies

  4 years, 2 months ago

  By: vpader

• Script to DROP and RE-CREATE all Primary and Foreign Key Constraints on all Tabl

  Hi Does anyone know of a good way to Drop and Recreate all Primary and Foreign Key Constraints for …

  Weegee71

  2 replies

  4 years, 2 months ago

  By: Thom A

• Using CASE Statement with $Action in Output Clause in Merge

  Hi there I want to write one combined Output statement at the end of a Merge statement to insert da…

  Weegee71

  1 replies

  4 years, 2 months ago

  By: ScottPletcher

• Sum of Rows

  Hi Guys, How do i group the below code so it gives e a total duration for each person for each day.…

  Zed

  1 replies

  4 years, 2 months ago

  By: Jonathan AC Roberts

• Simple SQL query

  MOTEL (motelID, motelName, town) ROOM (roomID, motelNo, type, cost) BOOKING (motelNo, guestID, date…

  johnhobbs

  3 replies

  4 years, 2 months ago

  By: ScottPletcher

• Problem with conversion from char to datetime

  Hello everybody. I am trying to insert  some data in table  Production.WorkOrder. There are some da…

  Sajo1510

  7 replies

  4 years, 2 months ago

  By: Sajo1510

• extract name to 3 single columns

  Is there a better way to extract to 3 single columns from one full name column: Lastname, FirstName…

  sqlfriend

  12 replies

  4 years, 2 months ago

  By: Steve Collins