Comments posted to this topic are about the item 10 SQL Snippets For Faster, More Effective Code
Some I end up using a lot.
WHERE TABLE_NAME = ''
FROM INFORMATION_SCHEMA.ROUTINES r
WHERE r.ROUTINE_DEFINITION LIKE '%%'
RANK ( ) OVER (PARTITION BY $CURSOR$ ORDER BY )
RAISERROR ('Error raised in TRY block.', -- Message text.
16, -- Severity.
1 -- State.
Group by and order by were already in my snippets and I'm pretty sure I didn't put them there. Nice examples, though.
I /think/ gb and ob may have been more recently added 🙂
I particularly like 'ra' out of these.
Do you want to submit them to the github repo as a pull request :-)?
Viewing 5 posts - 1 through 4 (of 4 total)