SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• SQL to display HTML for Dropdown

  I have created a webpage with a form that allows people to register for an event. The event will oc…

  netguykb

  4 replies

  4 years ago

  By: netguykb

• The actual file SQLServerManager15.msc is missing from my computer

  I did a fresh install of Windows 10 Pro and loaded SSMS on it.  My database is on a different compu…

  Jocar26

  1 replies

  4 years ago

  By: Ant-Green

• Issue with the format of calculation

  Hello friends, This issue is a little hard to explain, but I hope you will be able to understand wh…

  JeremyU

  3 replies

  4 years ago

  By: JeremyU

• Capture login information

  I want to Capture Login information in table or view. who connected to database and when they conne…

  mcfarlandparkway

  9 replies

  4 years ago

  By: Johan Bijnens

• How to grant Exec ON multiple Stored Procedures

  Hi, I have multiple Stored Procedures that are named like _Test_01, _Test_02 _Test_03 I would like …

  ArnolddG

  12 replies

  4 years ago

  By: ArnolddG

• Get value of rows based on condition

  Hello, I have the table with data as bellow : create table tbl_Fact( IdCmd int, DateDEP date…

  IdealPR

  1 replies

  4 years ago

  By: Steve Collins

• Need some help with tsql code

  I have 4 tables (DevDB, TestDB, StageDB, ProdDB). All those tables have 2 columns (DatabaseName, En…

  Chitown

  1 replies

  4 years ago

  By: ScottPletcher

• XML data extract

  Hi I've been tasked with extracting information for a report where the field type is XML. THe SQL t…

  dbayliss1978

  2 replies

  4 years ago

  By: dbayliss1978

• Implicit conversion on hash key column is causes very slow insert

  I am trying to insert some data into some stage tables where the insert is taking far too long. For…

  eseosaoregie

  6 replies

  4 years ago

  By: Jeff Moden

• Formatting issue with percent

  I have an issue that may be an easy fix for someone, but is not for me. I need to calculate Instock…

  JeremyU

  4 replies

  4 years ago

  By: JeremyU

• Query with a column containing JSON text

  Hi I have a table MyFiles with columns Id, FileName, FolderName, KeyPairs. The last one (nvarchar(M…

  Roust_m

  1 replies

  4 years ago

  By: Mark Cowne

• Stored procedure Error converting data type varchar to bigint

  I have been using below stored procedure which works very well for SQL Server 2012 but in SQL Serve…

  SQlLogic

  18 replies

  4 years ago

  By: frederico_fonseca

• Copy files from folder using SQL Server.

  Good day everyone. I hope someone can help me on that one. I have a database that include file fold…

  Charles Bilodeau-369032

  3 replies

  4 years, 1 month ago

  By: ikooruhq

• Assign multiple fields to one variable

  Hi I need to write a query / procedure that will create the following string - Column1Name=Column1V…

  Jeepisfun

  2 replies

  4 years, 1 month ago

  By: Jeff Moden

• Inserting records in bulk, but check total quantity of all products first

  Lets say I am creating orders and each order can have same product. I am inserting orders in bulk, …

  MountainEve

  7 replies

  4 years, 1 month ago

  By: ScottPletcher