SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• fast farward curson vs while loop on @table

  hi, need to known weather fast farwand cursor is faster than a while loop made on @table variable h…

  rajemessage 14195

  4 replies

  4 months, 3 weeks ago

  By: carwalk

• Find all the tables in a database containing particular column value

  Hi, I want to find all the tables name under a database where tables having text like "ID". Like in…

  RCRock

  7 replies

  4 months, 3 weeks ago

  By: pietlinden

• Looking for help with SQL statement

  Hi there I am seeking some help with an SQL statement. Any help would be welcomed. TIA   See t…

  DalF1960

  6 replies

  5 months ago

  By: ScottPletcher

• Select @ for different fields

  I have a need where I need to pass a field name to a Stored Procedure then lookup information on it…

  bswhipp

  6 replies

  5 months, 1 weeks ago

  By: Mr. Brian Gale

• Varchar(max) to lines

  I have an issue with a varchar(max) field with up to 7000 characters needing to be put in to lines …

  bswhipp

  5 replies

  5 months, 1 weeks ago

  By: bswhipp

• ERD Tools recommendation

  Hey All, I'm looking for a free ERD tool. Does anyone have any recommendations? Thanks!

  coffee_table

  8 replies

  5 months, 2 weeks ago

  By: mamta25

• Beginner in sql server

  Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id…

  YuChan

  3 replies

  5 months, 3 weeks ago

  By: Steve Collins

• SQL Newbie HELP: The query references an object that is not supported in distr..

  Hi everyone! I'm new to SQL and am trying to query a view (dbo.) made from a D365 table. My goal is…

  WBenning

  1 replies

  6 months ago

  By: Steve Jones - SSC Editor

• repeat results without loops, MSSQL2005 Express

  hello everybody, new here and this is my first question I have a table contains: Name, Id, joinDate…

  Sailor

  7 replies

  6 months, 1 weeks ago

  By: Sailor

• Question about Data Warehouse Management

  Hello SSC, Wishing everyone happiness and health and hope you are all doing well! I have a question…

  Lord Slaagh

  2 replies

  6 months, 1 weeks ago

  By: Lord Slaagh

• sp_prepare and sp_execute vs sp_executesql

  I have noticed sp_executesql also makes a single plan for a stmt with parameter in a loop. q1) Gene…

  rajemessage 14195

  2 replies

  6 months, 2 weeks ago

  By: Chandan Shukla

• Parameter sniffing issue with different minutes as opposed to using midnight

  Hej, I'm not facing this issue but as I was working another parameter sniffing issue I came to thin…

  mikael_ljunghorn

  5 replies

  6 months, 2 weeks ago

  By: mikael_ljunghorn

• XML_COMPRESSION for existing tables

  We are in the process of upgrading to SQL Server 2022 and would like to make use of the XML compres…

  zoggling

  2 replies

  7 months ago

  By: zoggling

• Is there some good routines for updating SQL Server database objects with GitHub

  At work we've been getting better at writing what's known as GitHub Actions (workflows, YAML). I've…

  Rod at work

  3 replies

  7 months ago

  By: Rod at work

• Rounding Off issue in SQL Server

  I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64)  Microsoft Corporat…

  vikramchander90

  5 replies

  7 months ago

  By: pedro.costa