SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Query Issue

  Hi all, new here. I was using Access and almost finished creating what I needed to accomplish and r…

  MannyR

  5 replies

  5 years ago

  By: MannyR

• I passed the Microsoft Exam 98-364: Database Fundamentals

  I recently passed Microsoft Exam 98-364: Database Fundamentals.  As it turns out, I did better than…

  michael.leach2015

  5 replies

  5 years ago

  By: Jeff Moden

• How To Process JSON Columns, having '.' (dot) in Their Names?

  I have a JSON file from Azure's DevOps I need to process. It seems to be straight forward on column…

  BOR15K

  18 replies

  5 years ago

  By: BOR15K

• Simple Python question...

  I have a table in SQL Server like this: CREATE TABLE #SymptomData (     PatientID INT NOT NULL, …

  pietlinden

  1 replies

  5 years ago

  By: pietlinden

• In search of Database scripts version control strategy or process

  Hello! I am looking for strategy/process that helps to achieve database scripts version control and…

  blogs4t

  1 replies

  5 years ago

  By: Jeff Moden

• Validate field in STaging before loading

  I have a STaging table where I have defined all fields as Varchar(255), now I'm trying to load the …

  Bruin

  16 replies

  5 years ago

  By: david.edwards 76768

• Size of table

  Hi This probably a silly question but..... If I query the size of a table and it shows 20 gigs in s…

  caz100

  9 replies

  5 years ago

  By: Jeff Moden

• JSON Value

  I'm trying to get the Json value from the lat and lon, however keep getting NULL as a result. What …

  Peter Kruis

  2 replies

  5 years ago

  By: Peter Kruis

• Ignore the entire record if a matching record is found

  Hello, Kindly guide me with the following code in T-SQL. I need to only extract those KeyId where t…

  SQL_Hunt

  6 replies

  5 years ago

  By: Jeff Moden

• How to create a minimal tally table and to describe its advantages (if any)

  What is the minimal way to create a tally table/tvf/cte and to describe its advantages (if any) ver…

  Steve Collins

  46 replies

  5 years ago

  By: Jeff Moden

• Find row closest to date

  Just having trouble getting this to work as I hoped. Trying to extract entire row from one table wi…

  boehnc

  3 replies

  5 years ago

  By: pietlinden

• SQL Select with condition

  Hi, In my sql table,  there is a column which have string of text : Column 2ABF   CD000000000012345…

  Dee Dee-422077

  11 replies

  5 years ago

  By: Ken McKelvey

• How to write query for multiple rows into a single row for different columns

  How to write query for multiple rows into a single row for different columns in SQL Server While st…

  Harry

  9 replies

  5 years ago

  By: Harry

• do a replace in update statement

  I have a varchar(130) field called exportpath. I want to replace the word devserver with prodserver…

  Bruin

  4 replies

  5 years ago

  By: ratbak

• The backup set holds a backup of a database other than the existing 'MyDB'

  I'm trying to restore a database from our production server to my local machine using the following…

  JBentrum

  2 replies

  5 years ago

  By: Grant Fritchey