Options

More Snippets

malcolm.daughtreemalcolm.daughtree Posts: 16
edited September 4, 2008 7:09AM in SQL Prompt Previous Versions
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
CodeOn ;-)
· Share on Twitter

Comments

  • Options
    MikeONeillMikeONeill Posts: 131
    edited August 1, 2017 9:21AM
    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()
    · Share on Twitter
Sign In or Register to comment.