SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Refactoring an Entity Attribute Value schema

  Apologies in advance, as I know this has been discussed a million times already but I think our req…

  julian.fletcher

  1 replies

  4 years ago

  By: Phil Parkin

• SSIS SFTP using WinSCP

  Hi I am using WinSCP to create a SFTP task by following this guide: https://winscp.net/eng/docs/gui…

  water490

  19 replies

  4 years ago

  By: Jeff Moden

• SSIS package to select a button on a windows app

  Hi everyone I am creating an SSIS package where I run an windows program to download data.  The dat…

  water490

  3 replies

  4 years ago

  By: water490

• CPU

  Hi everyone I am in the market for a new computer.  I have been comparing various Xeon processors a…

  water490

  3 replies

  4 years ago

  By: Jeff Moden

• Enable 'Microsoft OLE DB provider for ODBC Drivers' or MSDASQL trace in SSMS

  Hello, I have a Windows 2019 machine with SQL Server 2019. I have created a linked server to Db2 da…

  CheBob

  1 replies

  4 years ago

  By: CheBob

• Error for byte size

  Hi, I am getting the following error for following query I am trying to run. Anyone can advise what…

  singhzsql

  7 replies

  4 years ago

  By: mistygal08

• Use of '$$xxx'

  I have seen a number of queries that contain statements like "set @SomeBitVariable  = iif('$$SomeNa…

  andymay-496937

  1 replies

  4 years, 1 months ago

  By: Mr. Brian Gale

• UNION ALL with CTE

  Hello. I am trying to UNION ALL two tables 1) Current receipts 2) Historical receipts. Both of thos…

  JeremyU

  11 replies

  4 years, 1 months ago

  By: Jeff Moden

• Bulk Insert Stored Procedure

  Hi I am trying to create a stored procedure.  I am getting an error.  Is someone able to help me wi…

  water490

  8 replies

  4 years, 1 months ago

  By: water490

• Export to Multiple Worksheets / Tabs in Excel ?

  I am able to use an SSIS package to export from a SQL table and create an Excel spreadsheet and ass…

  homebrew01

  3 replies

  4 years, 1 months ago

  By: SoCal_DBD

• automating query against local server group and producing .csv output file

  Hi, all - I'm trying to automate a script to run a query against a local server group and output th…

  smueller72

  7 replies

  4 years, 1 months ago

  By: Jeffrey Williams

• Stored procedure insert data with an id & return a list of all inserted ID's

  I need to create a SQL server stored procedure to insert records with an ID column that is an ident…

  ashatimjohn

  6 replies

  4 years, 1 months ago

  By: Michael L John

• High speed hardware for SQL server use

  I'm not sure if this is the right forum if not please, if possible, direct me to one that might be.…

  Howard Quinton

  1 replies

  4 years, 1 months ago

  By: Michael L John

• Question about malformed ZIP codes

  ISNULL('"' + LEFT(D.Zip, 5) + '"', '"99999"') AS ["Customer Zip"], I have this query in a stored pr…

  Brad Allison

  9 replies

  4 years, 1 months ago

  By: ScottPletcher

• Encryption SQL2019 Decryption -SQL2016

  Hi Everyone, I am trying to encrypt a data column on SQL 2019 and decrypt on SQL 2016. I am not sur…

  mishka-723908

  2 replies

  4 years, 1 months ago

  By: mishka-723908