Forum Replies Created

Viewing 15 posts - 1 through 15 (of 27 total)

  • RE: Check Contraint VS Unique Index

    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

    #1833330

  • RE: Alter Table Add 2 Fields Takes Too Long

    Sean Lange (9/25/2015)

    zulmanclock (9/25/2015)

    Hello all. I have a strange one that i have never encountered and at this point am totally lost. We have a proc that adds some fields...

    September 25, 2015 at 12:50 pm

    #1829627

  • RE: How to insert result from dynamic openquery into an existing table?

    sql84 (9/25/2014)

    How can I insert the result of below dynamic openquery into an existing table

    DECLARE @TSQL varchar(8000), @VAR char(2)

    ...

    September 25, 2014 at 2:51 pm

    #1748318

  • RE: Table locks

    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

    #1709637

  • RE: Table locks

    GilaMonster (4/29/2014)

    Nothing to do with a procedure.

    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

    #1709630

  • RE: Get all the Child Tables up to N level

    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

    #1668466

  • RE: Count number of leading character

    Mark-101232 (9/9/2013)

    DECLARE @s-2 VARCHAR(20)

    SET @s-2 = ' =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

    #1648581

  • RE: Date

    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

    #1614287

  • RE: Date Format

    vishnus (4/18/2013)

    There is a bug in DateFormat function

    E.g.: SELECT dbo.fnDateFormat('5/5/2013','MON')

    O/P: 5AY

    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

    #1608190

  • RE: Date Format

    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

    #1597055

  • RE: Date Format

    No problem. Thank you for your comments.

    March 11, 2013 at 11:00 am

    #1595673

  • RE: Date Format

    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

    #1595648

  • RE: Date Format

    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

    #1595641

  • RE: xp_sendmail not sending @message text

    No problem at all.

    March 11, 2013 at 9:25 am

    #1595623

  • RE: xp_sendmail not sending @message text

    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

    #1595616

Viewing 15 posts - 1 through 15 (of 27 total)