SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• get all txt files $filenameAndPath = code please help

  Hello I need to get txt files from directory and send email, when I put name of the file my code is…

  juliava

  2 replies

  1 year, 5 months ago

  By: Ken McKelvey

• How to check for data loss after rollback

  Hello SSC, I am not a DBA,. I have some DBA knowledge, but my education is all programming. I had a…

  Lord Slaagh

  5 replies

  1 year, 5 months ago

  By: rothj

• Change IN for EXSITS

  I have had a hard time to understand how to use EXISTS. I Always use IN instead. Here it dont work,…

  Edvard Korsbæk

  3 replies

  1 year, 5 months ago

  By: Edvard Korsbæk

• timeout in vs for ssas tabular deploy is 0 but i still timeout deploying

  hi we run 2019 std but i'm testing this on 2016.   following some old notes and starting from the d…

  stan

  1 replies

  1 year, 5 months ago

  By: stan

• Table variable declared within cursor persists across loop iterations

  If you run this code it creates a 2 row cursor loop.  Within the cursor the temp table @spec is de…

  Steve Collins

  4 replies

  1 year, 5 months ago

  By: Jonathan AC Roberts

• Stored Procedures - passed string than variable length

  Dear all, I was just wondering: Can you change the default behaviour as illustrated below? The user…

  Arthur Kirchner

  2 replies

  1 year, 5 months ago

  By: Arthur Kirchner

• Blocking question

  Hi all, We have a SSIS package that does 2 things in parallel: moves data from one partition to ano…

  SQL Guy 1

  6 replies

  1 year, 5 months ago

  By: frederico_fonseca

• Sort comma delimited string in column

  I have a column that contains comma separated values.  I'm trying to figure out how to sort the com…

  DBrown

  3 replies

  1 year, 5 months ago

  By: frederico_fonseca

• How to use a scalar function in INSERT stmt?

  Hello all, I would like to create an INSERT statement and use a UDF as part of the VALUES() set.  T…

  mjdemaris

  8 replies

  1 year, 5 months ago

  By: MMartin1

• Create Copy of DB in same server.

  Hi I want to create a copy of a DB on the same server. The account that creates the copy DB should …

  terry999

  5 replies

  1 year, 5 months ago

  By: Perry Whittle

• C# - how to convert string to date

  Hi everyone I am not too experienced using C#.  I need to convert date in string format to date for…

  water490

  2 replies

  1 year, 5 months ago

  By: water490

• Pivot query

  Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [Serial…

  Roust_m

  3 replies

  1 year, 5 months ago

  By: Phil Parkin

• Find the problematic Sql Query Caused Application Crash

  Hi, Is there anyway I can find out the sql script ran on a particular date and which might have cau…

  RCRock

  7 replies

  1 year, 5 months ago

  By: RCRock

• error using #temp tables

  Hi I am getting this error message when I try to re-use a temp table.  The code is a bit long so I …

  water490

  11 replies

  1 year, 5 months ago

  By: Martass

• Should I create tables with dynamic SQL?

  Hello all, I am thinking of creating a "shopping cart" in our application.  My thoughts are using t…

  mjdemaris

  7 replies

  1 year, 5 months ago

  By: mjdemaris