SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SSMS csv export file is missing leading zeroes for Numeric data types

  Hi, I am working to move data from SQL Server to BigQuery.  I tried exporting the .csv data out via…

  squareoff

  5 replies

  2 years, 10 months ago

  By: Jeff Moden

• Float

  Hi, I am having problem with generating a Float which generates a output of adding 1 every second m…

  n.haugaard

  7 replies

  2 years, 10 months ago

  By: Ed B

• How can i get the more accurate and optimzed grouped data ?

  Hi , I need to get the correction and a way to group it in a better and efficient way. What I want …

  mehmood

  2 replies

  2 years, 10 months ago

  By: drew.allen

• Split column into multiple column/rows

  Hi, I hope someone can help with an issue I'm facing. Within the database I'm working with there is…

  dbayliss1978

  2 replies

  2 years, 10 months ago

  By: dbayliss1978

• Schedule Replication

  Hi, I have a SQL 2019 server that is currently running replication. However I want to only run it b…

  Kris-155042

  3 replies

  2 years, 10 months ago

  By: Kris-155042

• Issue with converting Varchar to Numeric so I can add them

  I have this so far . . . SELECT * INTO #tempValue FROM ( SELECT t.HTS_98_Value, t.HTS_99_Value, t.H…

  jeffshelix

  8 replies

  2 years, 10 months ago

  By: jeffshelix

• No validation if Table Valued Function is used

  Hi, i have an issue with a few queries in SQL Server 2019 that no validation is done while saving a…

  AintTim

  7 replies

  2 years, 10 months ago

  By: AintTim

• Extracting first characters in a string

  Hi All, How could I can extract all the first characters in the string using SQL Server query

  sathishkm

  5 replies

  2 years, 10 months ago

  By: Jeff Moden

• How to remove diamond character from string in sql

  I have a column with data where i am getting character � Example - data looks like Student� Tried t…

  mcfarlandparkway

  10 replies

  2 years, 10 months ago

  By: Jeff Moden

• full name splitting based on the condition

  Hi All, I have the full name in the columns. Here i would like to split the names according to the …

  sathishkm

  3 replies

  2 years, 10 months ago

  By: Jeff Moden

• Why does a select on 1 table end up putting locks on other tables?

  I am playing with extended events. I noticed that when I do a select on table A there are numerous …

  Tobar

  16 replies

  2 years, 10 months ago

  By: Jeff Moden

• Sql subquery poor perf - Need to rewrite to optimise

  I have a sql query as below which takes endless time to execute. Any help in rewriting this query t…

  SQL Bee

  6 replies

  2 years, 10 months ago

  By: Jeff Moden

• How do I decrypt that Data after adding Column Level Encryption

  Added Column Level Encryption on Table Column.. Now Sensitive data is encrypted.. I want certain us…

  mandavli

  1 replies

  2 years, 10 months ago

  By: Johan Bijnens

• Select into variable table name

  I want to select data from one table into another table. The to table name has to be variable bases…

  bswhipp

  5 replies

  2 years, 10 months ago

  By: Johan Bijnens

• Multiple Database Deployment using DACPAC

  Dear All, I am able to deploy single database using DACPAC and VS Solution ,Post deployment scripts…

  Alone

  5 replies

  2 years, 10 months ago

  By: zaidmughal