More Snippets

malcolm.daughtree

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

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()