SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  3 years 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

  3 years 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

  3 years 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

  3 years 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

  3 years 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

  3 years 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

  3 years 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

  3 years 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

  3 years 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

  3 years ago

  By: drew.allen

• Logic that looks at min value of one field and populates value of another field

  Hello everyone, I am trying to understand how to build a logic in SQL which will create a field "AC…

  JeremyU

  8 replies

  3 years ago

  By: drew.allen

• Joining tables

    I'm a real beginner of SQL and have not managed to solve this. I'm trying to join all the in…

  pelusch

  1 replies

  3 years ago

  By: Ant-Green

• SQL Break-Up

  Please help me break this code? I have my understanding, would you break it up by colour/function a…

  yrstruly

  2 replies

  3 years ago

  By: frederico_fonseca

• Replacing a Db with another

  Please assist. I have a database on a live Production Server that is out of sync and not giving the…

  yrstruly

  5 replies

  3 years ago

  By: frederico_fonseca

• Calculations in TSQL

  Please check if my calculation(s) are correct, in accordance to this policy: "The general fuel levy…

  yrstruly

  3 replies

  3 years ago

  By: Eirikur Eiriksson