Snippets (75) (Custom IntelliSenses) Add (0)1 2 3 8 Remove 9 Refresh7 Show Settings? Transact SQL / Commands 5Select From A WHERE B Transact SQL / Data Definition Language 6Add Column G Alter Column H Audit Columns I Computed Column J Computed Column Name K Create Relationship L Drop Column M Table Value Function N Unique Index Ignore Nulls O Transact SQL / Date Functions 7Date Add P Date Difference Q Date Name String R Date Part Integer S Day Integer T Extract just the date from date time U Get Date Time V Get UTC Date Time W Get yesterday and today X Month Integer Y Year Integer Z Transact SQL / Functions 8CAST COALESCE CONVERT Cast Month Year to Date Describe a table ROUND SUM is null Function Transact SQL / Logical Functions 9Choose In line If Statement Is Numeric Transact SQL / Snippet 10Drop table if exists Get 1st item in list that is not null Get users and roles Give a User Membership to a Role Insert into General Lookups Long Running Queries Search User Tables Select Count From Select From Top Select Into / Insert Into Select Select Star From Set Passwords to Mine For Testing Transactions Variable Character View Roles for a User With no lock Transact SQL / Statements 11Computed Column Visual Studio Create Table Create Unique Index If Else Statement If Statement Merge Statement Raise Error Rank Over While Loop remove time function Transact SQL / String Functions 12Char Index Length Lower Case Reverse String Right Sub String Upper Case Transact SQL / Structured Query Language 13Case Statement Case Statement 1 Line Case Statement Single Column Delete Statement INNER JOIN Insert Statement Order by with Offset Select Statement Update Statement UPDATE dbo.<table_name, sysname, sample_table> Set <column_name, sysname, columnname=0> WHERE <where_column_name, sysname, ID=1>