SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• product version result

  SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I…

  mtz676

  3 replies

  5 years, 5 months ago

  By: Jonathan AC Roberts

• table variable

  deleted code resolved issue   This topic was modified 5 years, 5 months ago by mtz676.

  mtz676

  1 replies

  5 years, 5 months ago

  By: Grant Fritchey

• Unique value constraint among active records

  I have a lookup table that implements a system-generated Id for DRI purposes.  The lookup table has…

  CanuckBuck

  12 replies

  5 years, 5 months ago

  By: Sergiy

• Help Writing a Udf that get Number of "Years in a row"

  Hello. I have a table (say orderlines) with orderrows,    There is a column that holds the "Year"  …

  Pucko

  2 replies

  5 years, 5 months ago

  By: ktflash

• Trying to get a arithmetic operation from an Variable

  Hi, I am not sure if this can be done, but I seem to remember there is some format thing that can b…

  itmasterw 60042

  6 replies

  5 years, 5 months ago

  By: Mr. Brian Gale

• Does T-SQL have a way of truncating real and float values?

  I'm working on a new app and database, which has real data types in some of the tables. Due to some…

  Rod at work

  7 replies

  5 years, 5 months ago

  By: Sergiy

• SQL_variant to varchar error

  DECLARE @Temptable TABLE ( TotalPhysicalMemory varchar(1000), MemoryValueinUse varchar(1000), MaxMe…

  mtz676

  4 replies

  5 years, 5 months ago

  By: ScottPletcher

• The File location can't be opened error occurs when try to open a FileTable path

  Hi Every one, I hope you doing good. I need your help here. I am new to SQL server filestreeam conc…

  manavairajan

  1 replies

  5 years, 5 months ago

  By: Mr. Brian Gale

• Determining whether a parameter has been established.

  I have a ssrs report with 6 parameters 4 or which are cascading and one parameter (pTimeZoneID) tha…

  csalerno

  1 replies

  5 years, 5 months ago

  By: Site Owners

• SQL remove part of String Question

  Hello All, I have a string something like below("inputstring" column) and i want to exclude part of…

  dhanekulakalyan

  2 replies

  5 years, 5 months ago

  By: dhanekulakalyan

• Adding columns in case statements

  SELECT CASE WHEN EXISTS ( SELECT name FROM msdb.dbo.sysjobs WHERE name = 'JobA' ) THEN 'Exists' ELS…

  mtz676

  2 replies

  5 years, 5 months ago

  By: mtz676

• Need help. Find matchng Substring

  Friends Bit confused query for me. Dunno how to ask correctly. I have two tables. One with only one…

  meelan

  4 replies

  5 years, 5 months ago

  By: Jeff Moden

• A real challenge and I need suggestions on efficient ways to solve it

  I have a need to determine the site of cancer given some complexities. Each cancer patient has up t…

  diana.bodell 56517

  11 replies

  5 years, 5 months ago

  By: diana.bodell 56517

• Un-queried tables

  Hi, Is there a way to know which tables from a DB are NOT being queried? Context : We do a lot of r…

  d_martins

  6 replies

  5 years, 5 months ago

  By: ScottPletcher

• Varchar to datetime

  Hi, How can I convert SCHEDSTART varchar(25)  '2020-06-07-12.30.00.00000'   to datetime  '2020-06-0…

  Unniarcha

  21 replies

  5 years, 5 months ago

  By: ZZartin