Viewing 15 posts - 691 through 705 (of 8,760 total)
Quick question, what else is running on this server?
😎
Few thoughts and questions:
February 24, 2019 at 6:45 am
Here is one way of doing this
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.Task_Header') IS NOT NULL DROP TABLE dbo.Task_Header;
February 24, 2019 at 6:20 am
February 24, 2019 at 5:13 am
I have a requirement where i need to encrypt all my stored procedures in...
February 23, 2019 at 6:38 am
Suggest you add a calculated column for the constraint
😎
Here is an example
ROW_HASH AS (HASHBYTES('MD5',CONCAT(,[whatStatus]))) PERSISTED CONSTRAINT UNQ_DBO_FIRSTTIMEREG_USRCOMMUNITY_EMAIL_STATUS UNIQUE
February 23, 2019 at 3:47 am
February 18, 2019 at 10:04 am
February 18, 2019 at 10:01 am
Quick thought, would that be the 53rd week of each year unless the 31st of December falls on Saturday?
😎
February 17, 2019 at 6:08 am
February 17, 2019 at 6:02 am
February 17, 2019 at 5:56 am
Just to underline the bad performance of the FORMAT function, here is a simple test set
😎
USE TEEST;
GO
SET NOCOUNT ON;
February 16, 2019 at 7:48 am
sean.r.mason - Friday, February 15, 2019 6:00 PMThis worked Perfect thank you very much.Where disch_yyyymm = FORMAT(DATEADD(MONTH, -2, GetDate()), 'yyyyMM');
DO NOT use...
February 16, 2019 at 2:39 am
Viewing 15 posts - 691 through 705 (of 8,760 total)