SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• sql command written in cmd that is .bat file is synchronous or asynchronous

  hi, I call few stored procedure from a .bat file  and .bat file is executed from micrisoft  windows…

  rajemessage 14195

  3 replies

  1 year, 11 months ago

  By: rajemessage 14195

• Restore table from onedrive

  I made a mistake and dropped a table with 270,000 records.  I have a backup table with 204,000 reco…

  Jocar26

  3 replies

  1 year, 11 months ago

  By: Jocar26

• How to Efficiently Find and Remove Duplicates in a Large SQL Database?

  I have a large SQL database with millions of records, and I've identified duplicate entries. What's…

  Piyushbhatt

  14 replies

  1 year, 11 months ago

  By: Jeff Moden

• Cannot able to login to mysql as localhost

  I have a query in mysql I have created a account with test@localhost and i want to access the parti…

  santhosh

  1 replies

  1 year, 11 months ago

  By: Phil Parkin

• How to find second position after decimal

  Have a numeric column HRS Numeric(5,2) Need to add error if the value after decimal point second di…

  mcfarlandparkway

  9 replies

  1 year, 11 months ago

  By: Jeff Moden

• Update CSV string with lookup table

  I need to replace word(s) in CSV string in table tblA, in the [original] column, by [word] from loo…

  itlk

  5 replies

  1 year, 11 months ago

  By: itlk

• SSIS - flat file import

  I am trying to import a text file that looks like this into a sql server database table using ssis.…

  EM2

  18 replies

  1 year, 11 months ago

  By: frederico_fonseca

• Need help on Pl SQL Stored procedure need to be converted on SQL SERVER.

  HI All. Iam looking for some support where i have been stuck since few days while converting the be…

  pavanpala.vja

  8 replies

  1 year, 11 months ago

  By: Mr. Brian Gale

• How do I add files to the server?

  Hello all, I would like to begin storing and displaying PDFs and images using SQL Server.  However,…

  mjdemaris

  23 replies

  1 year, 11 months ago

  By: Ken McKelvey

• Import ridiculously large CSV file

  First off, I know how to spell BCP, and that's about it. I'm trying to import a stupid huge CSV fil…

  pietlinden

  8 replies

  1 year, 11 months ago

  By: frederico_fonseca

• Time allocation across blocks of time

  I've been working on this problem for a few days now and cannot find a way to solve it. blockstart …

  max266

  24 replies

  1 year, 12 months ago

  By: max266

• Advanced SQL Query Optimization Assistance Needed

  Hey guys, I'm having a real tough time optimizing a SQL query for my project. I've been working wit…

  sindhuagarwal

  4 replies

  1 year, 12 months ago

  By: Johan Bijnens

• Excel report into SQL - View

  Please assist. What would be the quickest and most convenient/effective way of turning an Excel rep…

  yrstruly

  4 replies

  2 years ago

  By: Phil Parkin

• Trigger to track changes

  I need to track changes when a column is updated on two tables. Is there a way to do it. please sen…

  sqlguy80

  9 replies

  2 years ago

  By: Mr. Brian Gale

• No Data Being Inserted

  I have a table that i populate using joins.One of the tables don't insert its data. Tables are:-- T…

  yrstruly

  2 replies

  2 years ago

  By: Emperor100