Just a few embellishments on the standard Snippets

-- Select Single Star from
sssf
Select TOP 1 * from $CURSOR$

-- Left Trim - Right Trim
ltrt
LTRIM(RTRIm($CURSOR$))

lk
Like Like
LIKE '%$CURSOR$%'


Have fun
CodeOn :D
malcolm.daughtree
0

Comments

1 comment

  • MikeONeill
    Maybe an idea is a "Code Gallery" for snippets somewhere on the site

    I know I have created a fair number of personalised ones as I'm sure many people have.

    "Share and Enjoy" --- HHG
    sded = 
    
    DECLARE @StartDate DateTime
    DECLARE @EndDate DateTime
    
    Set @StartDate = DateAdd(d,-1,GETDATE())
    Set @EndDate = GETDATE()
    
    MikeONeill
    0

Add comment

Please sign in to leave a comment.