SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Backup a line of a table if a row is updated

  Hi there! I have an SQL table called ORIGIN with 5 fields. Each time one of the field in changing, …

  jbeclapez

  5 replies

  3 years ago

  By: Jeff Moden

• Issue with Schema Removal from Table or view

  Example 1 declare @statement varchar(100) = '[dbo].[vw_EmployeeData]' select @statement, CHARINDEX(…

  mcfarlandparkway

  7 replies

  3 years ago

  By: ScottPletcher

• Row limit for Updates before transaction log fills up

  Hello SSC, I hope everyone is staying safe and healthy. I am using SQL 2017 and I have over 17 mill…

  Lord Slaagh

  3 replies

  3 years ago

  By: Jeff Moden

• Job is empty SQL

  Hi guys,   I really do not understand why I still receive empty emails. Please check my code: …

  Barendrecht82

  11 replies

  3 years ago

  By: Phil Parkin

• Extract/export embedded files from binary in SQL 2017 Standard

  Hi Everyone ! If I run SELECT * FROM [QPulse5Training].[dbo].[RevisionAttachmentItem] I get a gener…

  Xunil

  10 replies

  3 years ago

  By: mjhytre

• Best practice to store - How many days, minute and second ?

  Hi, I plan to create HelpDesk Database. One of the table will store - Response Time & Resolutio…

  Adelia

  21 replies

  3 years ago

  By: kuopaz

• Truncate vs Delete for Bulk Removal of (some not all ) records

  EDIT : the table is not 1gb its 1tb 🙁   Hi I have a table with 351,495,000 records (about 1…

  simon_s

  11 replies

  3 years ago

  By: Jeff Moden

• how to solve parse error?

  here is my code for parse data but here I have error like this 'StoreSurvey' has fewer columns than…

  saskee

  1 replies

  3 years ago

  By: Site Owners

• Calculate HR

  Please assist me? I would like to calculate:my code: SELECT * from [dbo]. where LeaveTypeName Not …

  yrstruly

  3 replies

  3 years, 1 month ago

  By: aaron.reese

• Distinct Count

  I am using the following code for distinct count, seem to give me the same number for count and dis…

  yrstruly

  3 replies

  3 years, 1 month ago

  By: ktflash

• How is TableAlias in the MergeSpecification class in ScriptDom to be understood?

  Hello, everyone am currently learning Microsoft.SqlServer.TransactSql.ScriptDom. Have already imple…

  frank.kress

  2 replies

  3 years, 1 month ago

  By: topsmartservices

• arabic digits stored in varchar column with Arabic_* collation

  Hello, FYI Database collation is Arabic_100_CS_AS Why do Arabic characters in a varchar column (c…

  Mark T.

  3 replies

  3 years, 1 month ago

  By: stevenb 14609

• Creating appropriate data type from varchar(max)

  This is something I am thinking someone may have done already. Basically we have data loader which …

  dva2007

  4 replies

  3 years, 1 month ago

  By: MMartin1

• Need help on T-SQL

  I've table and data as script below, CREATE TABLE [dbo].[ClientProjects]( [Id] [int] IDENTITY(1,1) …

  Adelia

  2 replies

  3 years, 1 month ago

  By: Adelia

• replace chain of function calls with better code

  We have a scalar function that is used to add a specific number of business days to a date however …

  david_h_edmonds

  14 replies

  3 years, 1 month ago

  By: ScottPletcher