Microsoft SQL Server Snippets

Snippets are available with TeamSQL Pro Plan.

First item is the label of snippet so you can start writing one of the labels in TeamSQL Query Editor and use them.

 

 

 

SELECT * FROM…

Simple SELECT command

SELECT * FROM with WHERE clause…

Simple SELECT command with WHERE clause

SELECT with INNER JOIN…

SELECT Command with INNER JOIN

INSERT INTO…

Insert into a table on “dbo”

INSERT INTO with SELECT…

Insert into a table on “dbo” using SELECT

DELETE FROM…

Delete rows from a table on “dbo”

UPDATE with WHERE clause…

Update records in a table on “dbo”

CREATE PROCEDURE…

Create procedure on “dbo”

DROP PROCEDURE…

Drop a procedure from “dbo”

EXECUTE… (Stored Procedure)

Call a stored procedure on “dbo”

CREATE FUNCTION…

Create a function on “dbo”

DROP FUNCTION…

Drop a function on “dbo”

CALL FUNCTION…

Call a function on “dbo”

CREATE TABLE (Simple)

Create a table on “dbo”

CREATE TABLE (with Primary Key)

Create a table on “dbo” with primary key

DROP TABLE…

Drop a table on “dbo”

ALTER TABLE…

Alter a table on “dbo”

SELECT INTO (Structure only)

Create a table (only structure) on “dbo” like another one

SELECT INTO (Structure & Data)

Create a table (structure & data) on “dbo” like another one