Viewing 15 posts - 1 through 15 (of 27 total)
Thanks for the info. I never used the check constraints before so was wondering.
As always your help is greatly appreciated.
October 14, 2015 at 2:03 pm
Sean Lange (9/25/2015)
September 25, 2015 at 12:50 pm
DECLARE @TSQL varchar(8000), @VAR char(2)
September 25, 2014 at 2:51 pm
GilaMonster (4/29/2014)Once the statement completes and any triggers on the table have fired and have completed.
Thank you very much for your answer. Now this places me back at the start...
April 29, 2014 at 2:40 pm
Locks taken by data modifications are released when the transaction finishes (commit/rollback). If you aren't using an explicit transaction, that means the locks are...
April 29, 2014 at 2:35 pm
Thank you for this post,
How could i use this to find the order in which to delete tables so i do not receive foreign key violations?
November 22, 2013 at 9:20 am
Mark-101232 (9/9/2013)DECLARE @S VARCHAR(20)SET @S = ' =10 02=5608= 'SELECT LEN(@s) - LEN(LTRIM(@s))
DECLARE @S VARCHAR(20)SET @S = ' =10 02=5608= 'SELECT LEN(@s) - LEN(LTRIM(@s))
DECLARE @S VARCHAR(20)
SET @S = ' =10 02=5608= '
SELECT LEN(@s) - LEN(LTRIM(@s))
Thank you Mark. Its funny because i used that in...
September 9, 2013 at 9:24 am
Figured it out. Had to do some string manipulation but i got it:) Would have been easy if i wasnt working with data that came from Unix.
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,Cast(Field1 as...
May 10, 2013 at 12:10 pm
vishnus (4/18/2013)There is a bug in DateFormat functionE.g.: SELECT dbo.fnDateFormat('5/5/2013','MON')O/P: 5AY
E.g.: SELECT dbo.fnDateFormat('5/5/2013','MON')
Please make sure you have the revised function code, there was a bug found and i adjusted the code. ...
April 19, 2013 at 6:56 am
In its current format it does not recognize the difference. If you chance the line
IF (CHARINDEX ('MON',@DateValue)>0)
March 14, 2013 at 8:49 am
No problem. Thank you for your comments.
March 11, 2013 at 11:00 am
Ok I see the problem. In the code you function lost the single quotes around the 0.
IF (CHARINDEX ('DD',@DateValue) > 0)
March 11, 2013 at 10:18 am
Can you show me the function as it is on your system? I wonder if maybe when you copied and pasted from the article maybe it missed or added...
March 11, 2013 at 10:04 am
No problem at all.
March 11, 2013 at 9:25 am
To avoid this you can use:
SET CONCAT_NULL_YIELDS_NULL OFF
This will prevent a field where the value is NULL from making the entire result NULL as well.
March 11, 2013 at 9:17 am