snippet-list.txt

GitHub /sqlpromptsnippets File Index

File    Description
------- -------------------------------------------------------------------------------
ac      ALTER COLUMN
af      ALTER FUNCTION
ap      ALTER PROCEDURE
at      ALTER TABLE
ata     Add column
atac    Modify column 
atd     Drop column
atdc    Drop constraint
atdt    Disable a trigger on table
atdta   Disable all triggers on table
atet    Enable a trigger on table 
ateta   Enable all triggers on table
be      BEGIN...END
bt      BEGIN TRANSACTION
ccc     CREATE CELL CALCULATION fragment
cci     Create non-unique clustered index
cdb     CREATE DATABASE
cdbsnap Create a database snapshot
citf    Create inline table-valued function
cj      CROSS JOIN fragment
cl      Create a new SQL Server login
clrp    Create a CLR stored procedure
cni     Create non-unique nonclustered index
cp      Create a stored procedure
csf     Create scalar function
ct      Create a table
cte     Create a new common table expression
ctf     Create table-valued function
ctr     Commit transaction
ctt     Create temp table (drops if exists)
cu      Create a database user
cuci    Create unique clustered index
cuni    Create unique nonclustered index
curff   Boilerplate code for fast-forward read-only cursor
cv      Create a view
cw      CASE WHEN
dd      Drop a database
decc    Declare cursor
dect    Declare and manage temp table variable
decv    Declare variable
df      DELETE FROM fragment
dfn     Drop a function
di      Drop an index
dl      Drop a login
dp      Drop a stored procedure
dt      Drop a table
du      Drop a user
dv      Drop a view
err     Inserts @@ERROR function call
fj      FULL JOIN fragment
foj     FULL OUTER JOIN fragment
gb      GROUP BY
header  Template header for stored procedure
hhmm    string to HH:mm format
ifs     IF fragment
ii      INSERT INTO fragment
ij      INNER JOIN fragment
j       JOIN fragment
inn     IS NOT NULL fragment
is      Shortcut for INFORMATION_SCHEMA
isc     Column Information Grabber
isns    Wraps the currently selected column (text) in an ISNULL Function, with a default empty string (this is an inline selected text function)
isnn    Wraps the currently selected column (number) in an ISNULL Function, with a default to zero (this is an inline selected text function)
lin     Line
linn    Double line with space for text comment
lj      LEFT JOIN
lk      LIKE '% %' fragment
loj     LEFT OUTER JOIN fragment
mmddyyyy String to mmddyyyy format
mmddyyyyhhmm String to mmddyyyyhhmm format
mro     Retrieves information about 20 most recently created objects from database
neo     A word from one of our sponsors
num     Format a big number into a readable format
numc    Nicely formatted COUNT(*) as numRows
ob      ORDER BY
rj      RIGHT JOIN fragment
rnum    ROW_NUMBER() OVER () fragment
roj     RIGHT OUTER JOIN fragment
rt      Rollback transaction
san     Change the current ANSI_NULLS setting
scf     Count number of records returned by query, formatted nicely
sd      SELECT DISTINCT
setvar  SQL CMD setvar fragment
smf     SELECT SUM() FROM
sph     Execute sp_help
spt     Execute sp_helptext
sqi     Change the current QUOTED_IDENTIFIER setting
ss0     SELECT TOP 0 * FROM
ssf     SELECT * FROM fragment
ssf2    SELECT * FROM fragment, formatted nicely with tabs and newline.
sst     SELECT TOP 1000 * FROM
st100   SELECT top 100 rows
sxa     Change the current XACT_ABORT setting
tc      TRY ... CATCH fragment
today   CAST(GETDATE() as date) fragment
trim    Trim a string: LTRIM(RTRIM($CURSOR$))
trims   Wrap selected text in LTRIM(RTRIM($SELECTEDTEXT$))
uci     Unique Clustered Index
w2      Execute sp_who2
wdc     WITH (DATA_COMPRESSION = PAGE) fragment
wt      WITH (TABLOCK) fragment
xpfd    Retrieve free space on all fixed drives
yell    Vent your frustration