SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Reclaim space after setting varbinary(max) column to NULL

  I have a sql server 2019 database with a table that contains  a varbinary(max) column . I have used…

  kdaniapam

  4 replies

  3 years, 12 months ago

  By: kdaniapam

• To Proc or Not to Proc – Building SSRS Reports

  I'd like to hear some others' opinions on this. If you are building an SSRS report which requires a…

  Phil Parkin

  18 replies

  3 years, 12 months ago

  By: chris.johnson.0120

• Inner Join with multiple filter

  Table 1 Bank ID Transaction ID Date Amount 1 1 30-06-2020 50 1 2 30-06-2020 80 1 1 31-12-2020 72 1 …

  hirenvihaan

  3 replies

  3 years, 12 months ago

  By: chris.johnson.0120

• Tables with constant data

  Hello: I am creating a new database and suddenly I have a doubt. In most applications, there is alw…

  fgrodriguez

  11 replies

  3 years, 12 months ago

  By: GeorgeCopeland

• Parallel Execution of SQL in ADO.Net on C# - SQL Parameter is already contained

  Hi there Im not sure if this should be asked on a C# forum, but im taking a shot here. We have a C#…

  Weegee71

  3 replies

  3 years, 12 months ago

  By: Chris Wooding

• SQL that copies and pastes data in a database that changes

  Good Morning, I have programmed a SQL coding that copy "z" data under the "a" data but the number "…

  onyirimba

  5 replies

  4 years ago

  By: Jeff Moden

• SSMS Connect to Server name with hyphens?

  This is a question about the Connect to Server dialog in SSMS, the one that you use to connect to a…

  GeorgeCopeland

  2 replies

  4 years ago

  By: GeorgeCopeland

• aggregate by a given period

  Hello! Please, consider the following code DECLARE @SNH TABLE ( cntDT DATETIME, cntQ varchar(10), c…

  nkat

  5 replies

  4 years ago

  By: nkat

• How to put a variable content as attachment file saida.txt ?

  DECLARE @saida VARCHAR(MAX) SET @saida = '<br>===================<br>' SELECT @saida…

  vpmaciel

  6 replies

  4 years ago

  By: Thom A

• Table level increament backup

  Hi Expert, How i can take table backup and restore again in sql server when more data is available …

  Shree23

  8 replies

  4 years ago

  By: Grant Fritchey

• Summing rows based on two columns - cross apply not working

  I have a table with data (just including the relevant stuff here) and each line has a TeamId which …

  legacyvbc

  3 replies

  4 years ago

  By: legacyvbc

• Where are SQL Server Templates stored in a Docker Container of SQL Server DB

  Hi there I have created a Docker Container and able to restore and operate SQL Server Databases wit…

  Weegee71

  3 replies

  4 years ago

  By: Weegee71

• How to get previous rows in SQL Server

  I have a table data like below. Now I need to find the previous 2 rows where I have SLA Expired in …

  Krish319

  1 replies

  4 years ago

  By: DesNorton

• Convert Varchar data type to Datetime or Timestamp

  select Convert(Varchar(100),yourcolumn,103) as Converted_Date from yourtbl How can I get the end re…

  SQLisAwe5oMe

  7 replies

  4 years ago

  By: frederico_fonseca

• dynamic sql and openrowset xml

  Hello! This is a follow-up for this topic as, IMHO, the question deserves a separate thread I'm usi…

  nkat

  4 replies

  4 years ago

  By: nkat