SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Other methods of getting the true length of UTF8 String?

  Something I've been playing around with lately is the UTF8 functionality in 2019, and it dawned on …

  Thom A

  15 replies

  4 years, 11 months ago

  By: Thom A

• How to get these description from XML into the table?

    I want all these description in different row. TIA Example descriptions 0|Home 1|Office|Fals…

  NewDBA201

  4 replies

  4 years, 11 months ago

  By: Jeff Moden

• case statement issue

  SELECT CASE WHEN EXISTS ( SELECT name,enabled FROM msdb.dbo.sysjobs WHERE name = 'Myjob' ) THEN 'Ex…

  mtz676

  2 replies

  4 years, 11 months ago

  By: jcelko212 32090

• SQL Agent and Windows Task Scheduler

  Hi Guys, Has anyone used windows task scheduler with SQL Agent? I have a FTP which needs to be impo…

  Zed

  5 replies

  4 years, 11 months ago

  By: phegedusich

• Date time diff

  Hello all, trying to return the time in minutes between the Date1 and Time1 columns and the Date2 a…

  boehnc

  3 replies

  4 years, 11 months ago

  By: Michael L John

• \'DBMS_DATA_MINING\' is not a recognized CURSOR option

  Is DBMS_DATA_MINING available in SQL Server 2019? This is error: 'DBMS_DATA_MINING' is not a recogn…

  mtl20144102

  1 replies

  5 years ago

  By: frederico_fonseca

• SQL Server - Issues with Update When Summing Source + Target Columns in Batches

  Hi guys, I am trying to update a large table in small batches. Within the update statement, I am se…

  milkycow

  2 replies

  5 years ago

  By: milkycow

• Help me develop my skills

  Hi Guys, I'm hoping for a little advice and please delete if this is not relevant here.  I've been …

  Zed

  2 replies

  5 years ago

  By: Grant Fritchey

• Unique Index ~ SQL server

  Dear Experts   Please help me to convert below oracle unique index to Sql Server.   CREAT…

  Anthony_123

  2 replies

  5 years ago

  By: Grant Fritchey

• DLOOKUP in SQL

  I tried looking up a comparable function in SQL to the DLOOKUP in ACCESS.  I had this working in AC…

  MannyR

  5 replies

  5 years ago

  By: sgmunson

• How to check format of string number variable will format to Decimal(32,6)

  I have an incoming set of string values which need to be checked so they can be formatted as Decima…

  Weegee2017

  3 replies

  5 years ago

  By: Weegee2017

• Create string from broken hierarchy

  Hi I have a broken hierarchy where I need, for each row, to create a string that contains all poss…

  MichaelG

  7 replies

  5 years ago

  By: MichaelG

• SQL query error help

  Hi Guys, I have a table, around 320 fields. I am trying to use a simple Insert statement. Insert in…

  rocky_498

  5 replies

  5 years ago

  By: sgmunson

• Issue with Foreign Keys

  So recently I began to start a personal project to push my limits and try to gain an edge on databa…

  Reheight

  3 replies

  5 years ago

  By: Grant Fritchey

• PowerShell command to Run SQL file Fails asking for a variable

  Good morning team, I can run a .sql file that contains a SQLCMD command, with no errors via SSMS. T…

  sunshine-587009

  2 replies

  5 years ago

  By: Steve Jones - SSC Editor