10 SQL Snippets For Faster, More Effective Code

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Some I end up using a lot.

isc ->

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = ''

isr ->

SELECT *

FROM INFORMATION_SCHEMA.ROUTINES r

WHERE r.ROUTINE_DEFINITION LIKE '%%'

ra->

RANK ( ) OVER (PARTITION BY $CURSOR$ ORDER BY )

rai ->

RAISERROR ('Error raised in TRY block.', -- Message text.

16, -- Severity.

1 -- State.

);

jiblack SSC Enthusiast Points: 114 More actions · Answer 2

Group by and order by were already in my snippets and I'm pretty sure I didn't put them there. Nice examples, though.

gaurav.vohra SSC Enthusiast Points: 123 More actions · Answer 3

Thanks!

I /think/ gb and ob may have been more recently added

gaurav.vohra SSC Enthusiast Points: 123 More actions · Answer 4

I particularly like 'ra' out of these.

Do you want to submit them to the github repo as a pull request :-)?

Cookies on SQLServerCentral