SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Setting fill factor on an auto-increment INT clustered index

  Hi all, Please consider the following table structure. CREATE TABLE [dbo].[Transactions]( [Id] [in…

  Mr. Holio

  2 replies

  6 years ago

  By: Mr. Holio

• Execute business rule runtime

  Hi I have set of hundreds of business rules that I need to executed based on certain criteria. Just…

  CoolMoon

  1 replies

  6 years ago

  By: John Mitchell-245523

• Trigger for only updating specific column

  Hi, using Merge I can sync table A with Table B at ROW level. However 'how to update only specific …

  sizal0234

  1 replies

  6 years ago

  By: ScottPletcher

• Range of values not from a table

  Hi, I want a range of values between a start number and end number say 10000 to 50000 using SQL, bu…

  datsun

  3 replies

  6 years ago

  By: datsun

• Replace cr/lf not working with Japanese characters

  I tried many different ways and built a function to basically go character by character checking th…

  Keith DuAime

  2 replies

  6 years ago

  By: Keith DuAime

• Passing variable into xp_cmdshell

  Hi all, I need your help. I need passing variable into xp_cmdshell. This is my code : DECLARE @cmd…

  guido1971

  6 replies

  6 years ago

  By: guido1971

• Question on the use of schemas for access control

  I know that this is a long article, so, I totally understand if there are no replies. This seemed l…

  chuck.forbes

  3 replies

  6 years ago

  By: chuck.forbes

• is WITH (ROWLOCK) hint a culprit in this code?

  In the attached Stored Procedure, the yellow-highlighted code causes major blocking, especially whe…

  VoldemarG

  21 replies

  6 years ago

  By: x

• How to add Computed column with URL (Fixed string + another column value)

  Hi,   I want to add a new column to the table. Eg Table A ID 1 2 3   Desire Output  …

  Sangeeth Raj

  1 replies

  6 years ago

  By: Andrew P

• Dynamically Choose Columns Names

  Hi, From the following script, I am able to choose one column rows from #TableB to columns Headers …

  Sangeeth Raj

  4 replies

  6 years ago

  By: Jason A. Long

• adding reasons to temporal tables

  Hello   I've created a temporal table and can record changes. With temporal tables, it writes …

  DamianC

  1 replies

  6 years ago

  By: DamianC

• Filtering data from a subquery

  Hi all. I've got a query that pulls data from a Progressor database. I need to get the customer and…

  snert

  7 replies

  6 years ago

  By: snert

• Script to get distinct count and column name

  Hi, declare @table varchar(500) ='person' Select 'select count(*), count(distinct('+ STRING_AGG( na…

  ebooklub

  2 replies

  6 years ago

  By: ebooklub

• CTE - a simpler solution?

  All, I'm trying to get the average number of relatedpostid counts per postid. The following achieve…

  as_1234

  6 replies

  6 years ago

  By: as_1234

• Query stops retuning records after 6:00pm - Datetime datatype

  Hi ,  I have a query that uses a where clause to return records today.  however  it seems at 6:00pm…

  gjoelson 29755

  9 replies

  6 years ago

  By: ScottPletcher