Sql Prompt Snippets 快捷键学习

蔚落 2021-06-26 16:06 328阅读 0赞

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
    cseq	Create a sequence (start, end, optional: cycle, cache)
    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
    df      DELETE FROM fragment
    dfn     Drop a function
    di      Drop an index
    dl      Drop a login
    dp      Drop a stored procedure
    dseq	Drop a sequence
    dt      Drop a table
    du      Drop a user
    dupk	Check for duplicated values on a column
    dv      Drop a view
    err     Inserts @@ERROR function call
    fj      FULL JOIN fragment
    foj     FULL OUTER JOIN fragment
    gb      GROUP BY
    gep		Grant Execute on procedures
    git		Grant Insert on table
    giust	Grant Insert, Select, Update on table
    gst		Grant Select on table
    gut		Grant Update on table
    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
    nvseq	Next value for a sequence
    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