SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• db size for all db's across servers from cms

  how do I calculate db sizes of all databases across all servers from cms declare @dbsizes TABLE (se…

  mtz676

  6 replies

  6 years ago

  By: david.edwards 76768

• Code to auto-update tables on set date

  I am in a project where information is being pulled from a database then put into a web page in a m…

  thetubageek

  33 replies

  6 years ago

  By: ScottPletcher

• Joining 2 select results into a single row

  select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus …

  mtz676

  20 replies

  6 years ago

  By: sgmunson

• query

  Hi i have 3 table that need to find out which id missing two tables TABLES: Main,table1 and table2 …

  sankaripr

  5 replies

  6 years ago

  By: jcelko212 32090

• 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

  6 years 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

  6 years 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

  6 years 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

  6 years 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

  6 years 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 years ago

  By: Weegee2017