SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Identity column and "EntityID" column naming convention

  This isn't* specific to 2022, but SQL in general. I will be joining a full green field development …

  CreateIndexNonclustered

  11 replies

  1 year, 10 months ago

  By: CreateIndexNonclustered

• Update records using previous row and calculated value of current row.

  Hi All, I am trying to update a table's column avg_gain based on previous avg_gain and current gain…

  learnsql

  4 replies

  1 year, 10 months ago

  By: learnsql

• Select values from second table that are not linked to first table

  This is a simplified version of the actual tables and query I'm working with. I feel like it should…

  jmadsen 98862

  6 replies

  1 year, 10 months ago

  By: Jeff Moden

• "ID" primary key from two separate tables as a foreign key in a new table

  I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with StudentID…

  Edub1122

  32 replies

  1 year, 10 months ago

  By: CreateIndexNonclustered

• Building Application to connect with SQL Server Tables and Edit records

  Hello, I would like to build a Microsoft-based Application to use SQL Server Tables, and with this …

  Reh23

  6 replies

  1 year, 10 months ago

  By: aitorzur@hotmail.com

• Converting nested Json document to SQL data

  I have response from a API that look like { "responseCode": 200, "message": "success", "content": […

  mandavli

  2 replies

  1 year, 10 months ago

  By: aitorzur@hotmail.com

• bcp is giving SQL State = 1000 Native error =0 SQL Server

  Hi experts, Seeking your help. I am using a bcp command in a tool called IBM Datastage for Windows …

  surafeb7

  12 replies

  1 year, 10 months ago

  By: surafeb7

• Converting nested Json document to SQL data

  I have response from a API that look like { "responseCode": 200, "message": "success", "content": […

  mandavli

  1 replies

  1 year, 10 months ago

  By: kaj

• Conventions when writing queries/stored procedures

  At my last place of work the DBA used a code "beautifier" to format his SQL and he insisted that th…

  edwardwill

  20 replies

  1 year, 10 months ago

  By: jcelko212 32090

• Local firewall issue when connecting to SQL Server

  A client has moved to SQL Server 2019 on Windows Server 2022. Earlier they had SQL Server 2012 on W…

  plmehta

  11 replies

  1 year, 10 months ago

  By: Jo Pattyn

• How to get number of unique months from table

  Hi guys, I want some help with a code to count the number of unique months that appears in list (us…

  pelusch

  4 replies

  1 year, 10 months ago

  By: kaj

• what are the best books to become a SQL developer?

  what are the best books to become a SQL developer?

  vpmaciel

  2 replies

  1 year, 10 months ago

  By: andreas.kreuzberg

• Read data based on date-range in huge table is slow

  I've got a table here with more than 60 million rows and I want to extract data based on date (WHER…

  oRBIT

  22 replies

  1 year, 11 months ago

  By: Jeff Moden

• Distance between multiple locations

  What would be the best approach when establishing the distance between points. By that I mean I hav…

  brian.cook

  6 replies

  1 year, 11 months ago

  By: brian.cook

• SQL Converting Columns to Rows based on specific column value

  Hallo, I have a problem to fill a new column from a previous column where the values are calculate.…

  Hassin

  4 replies

  1 year, 11 months ago

  By: Davecat1990