SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• get column names and values in each row in SQL Server

  I Have ask from my vendor to send csv file with label and data in each row for the columns data i s…

  dhanekulakalyan

  9 replies

  1 year, 7 months ago

  By: Jeff Moden

• How do I query to exclude the "first position of a 3 digit number"

  How do I set up a query for the following example (where "HOTEL_A" is the table, and ROOM_NUMBER is…

  bkufleitner

  32 replies

  1 year, 7 months ago

  By: ScottPletcher

• query take long time when execute it so how to solve issue ?

  I work on sql server 2019 i face issue i can't reduce high cost of sort it reach to 86 percent so H…

  ahmed_elbarbary.2010

  12 replies

  1 year, 7 months ago

  By: Jonathan AC Roberts

• Convert Excel formulas to SQL language automatically

  Is it possible convert Excel formula to SQL? I mean like this site for convert VB.NET to C#. I have…

  niksirat

  2 replies

  1 year, 7 months ago

  By: aaron.reese

• FullText Search on PDF files

  Hi We have an existing solution where we store documents in the database in FileStream tables. The …

  Anders Hansen

  4 replies

  1 year, 7 months ago

  By: Anders Hansen

• Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)

  Beginner here and trying to solve a problem from which I cannot find any clear solutions. I am supp…

  joJo4146

  7 replies

  1 year, 7 months ago

  By: Jeff Moden

• Renaming JUST THE EXTENSION OF multiple files in a folder using SSIS

  Hi, I have three files in a folder - SourceFolder ABC.edifact DEF.edifact NJF.edifact I need to ren…

  ntreelevel

  3 replies

  1 year, 7 months ago

  By: Ed B

• Problem : Passing a Variable is not working in Dynamic Query

  Hi all, I am not able to pass the table name as a constant in Dynamic Query: The logic is to loop t…

  oneteabag

  4 replies

  1 year, 7 months ago

  By: oneteabag

• Convert Mysql to TSQL

  I am trying to correct the following code in SQL Server, please assist?   -- SQLINES LICENSE F…

  yrstruly

  12 replies

  1 year, 7 months ago

  By: Ed B

• Send Alert Email On Disabling DDL Trigger

  Is there anyway to send alert email if someone disable the DDL trigger? Alert notification should i…

  RCRock

  4 replies

  1 year, 7 months ago

  By: Jeff Moden

• Add another column with some commands

  i have a script below to find all the db fixed role db_datawriter. this is working fine, no issues.…

  lan2022nguyen

  12 replies

  1 year, 7 months ago

  By: Steve Jones - SSC Editor

• Generate a script to drop a DB user

  I have a script below to search ALL DBs for a specific user: DECLARE @DBuser_sql VARCHAR(4000) DECL…

  lan2022nguyen

  2 replies

  1 year, 7 months ago

  By: lan2022nguyen

• There is no recursion in my CTE SQL request

  I have very simple table I want to receive table with i,id and text column like 67->304->303…

  Alex1337

  2 replies

  1 year, 7 months ago

  By: Alex1337

• URGENT - Visio Diagram from SQL Server Database

  Can Someone tell me how to import database from SQL server to Microsoft Visio to create Database Di…

  Kajal

  1 replies

  1 year, 7 months ago

  By: Jeff Moden

• between is not working the way I would think?

  Can someone tell me why this does not pull any data? Data consists of fcinvoice, finvdate, fcstatus…

  bswhipp

  21 replies

  1 year, 7 months ago

  By: drew.allen