SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Can't Get BULK INSERT TO ERROR!!!

  Hello guy, I was testing my script for bulk insert. But i can't get the rows to error out and go to…

  Jacob Pressures

  11 replies

  7 years ago

  By: Jacob Pressures

• Connection Manager in SSIS 2017 Package NOT Saving the Password

  We're using Visual Studio 15.7.2 and using SSIS on SQL 2017 (14.0.3029.16). We built a connection m…

  Sean Perkins

  3 replies

  7 years ago

  By: Smendle

• colonne calculée ne peut pas être utilisée dans une autre définition

  Avec tous mes respects . Je voudrais vous poser un problème J'ai rencontré avec Microsoft SQL Ser…

  aabdma20142

  4 replies

  7 years ago

  By: aabdma20142

• SQL Server : sp_send_dbmail

  Hi all,I need help.I changed the SP [msdb].[dbo].[sp_send_dbmail], adding a new parameter.There is …

  mwamoreira

  1 replies

  7 years ago

  By: Sue_H

• SQL Entity Partion

  Hi, When partitioning data from a table do I need to have a separate filegroup for each partition?&…

  mwamoreira

  1 replies

  7 years ago

  By: BrainDonor

• Need to write query with conditioms

  update tab1.ut_prc with tab2.prcup of seqnum in which amtperact fall under.for example if you take …

  saptek9

  6 replies

  7 years ago

  By: sgmunson

• Grouping Records by evaluating the next record...

  We have GPS data that we receive from several devices that we have.  When we receive the data …

  steve.groner

  3 replies

  7 years ago

  By: ben.brugman

• Insert with dynamic SQL and Cursor for variable table/columns according to update list

  Hi!I have a bit of a problem for a while. I have updated tables in Database A. These tables gets up…

  coolasice24

  9 replies

  7 years ago

  By: ben.brugman

• sql 2017 'sqllocaldb' is not recognized

  Hey there,  this issue 'killed' 🙁 my working time. Need a REAL solution for this issue. See p…

  fleur.loves

  1 replies

  7 years ago

  By: frederico_fonseca

• Convert Varchar field

  I have a Varchar field with units in inches 🙁 that i need to convert to an integer (Unfortunately t…

  bpmosullivan

  41 replies

  7 years ago

  By: TomThomson

• XML Query

  I have XML being passed into a stored procedure in the following format.  I'm struggling with …

  Mike01

  13 replies

  7 years ago

  By: Mike01

• Error when loading CSV file to SQL Server using SSIS. The Column Delimiter was not found

  Can someone help me with loading the attached csv file database.The issue here is the CSV file has …

  kashyap4007

  26 replies

  7 years ago

  By: Sergiy

• How to capture and log custom error message after RAISERROR()

  SQL server makes it simple to capture error numbers <50000 using ERROR_NUMBER(), ERROR_MESSAGE()…

  DavidL

  3 replies

  7 years ago

  By: Lynn Pettis

• Convert all varchars in all tables to nvarchars

  Hello Experts,I have a requirement where I need to convert all varchar datatypes in all tables of a…

  dallas13

  6 replies

  7 years ago

  By: dallas13

• Need to modify the Update statement to include combination two new fields instead of one field.i want to write in better way in performance wise.

  Need to modify the Update statement to include combination two new fields instead of one field: Cur…

  saptek9

  10 replies

  7 years ago

  By: sgmunson