SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  1 replies

  8 hours, 25 minutes ago

  By: pietlinden

• 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

  3 days, 13 hours 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

  6 days, 18 hours ago

  By: bswhipp

• best tool for documenting your databases (more design decisions etc)

  Any suggestions for a good tool for documenting a database and all the important objects in it? I'm…

  pietlinden

  5 replies

  6 days, 23 hours ago

  By: carwalk

• ERD Tools recommendation

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

  Coffee_&_SQL

  8 replies

  1 weeks, 2 days ago

  By: mamta25

• 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

  3 replies

  1 weeks, 6 days ago

  By: Steve Jones - SSC Editor

• 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

  2 weeks ago

  By: Steve Collins

• Deleting data in large table

  I have a large table with 17M+ rows for our package record audits.  I've decided to clear out anyth…

  Jackie Lowery

  6 replies

  2 weeks, 2 days ago

  By: Uwe Ricken

• Connecting ERP system E2 and Extract Data , perform Transformation

  Hello, May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server.…

  Rahulmsb5

  2 replies

  2 weeks, 6 days ago

  By: Chandan Shukla

• 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

  3 weeks, 4 days 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

  1 months 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

  1 months 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

  1 months, 1 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

  1 months, 1 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

  1 months, 3 weeks ago

  By: zoggling