Skip to main content

SQL Server

Select with limit​

SELECT TOP 3 * FROM Users

Insert into select vs select into​

  • INSERT INTO SELECT inserts data into an existing table
  • SELECT INTO creates a new table and puts the data in it.
  • Insert into select:
CREATE TABLE MyTable (name varchar(255));
INSERT INTO MyTable
   SELECT name FROM sys.databases;
  • Select into:
SELECT name INTO MyTable FROM sys.databases;

Stored Procedures​

  • Create a Stored Procedure↗️ 
    CREATE PROCEDURE SelectAllCustomers
    AS
    SELECT * FROM Customers
    GO;
  • Execute Stored Procedure 
    EXEC SelectAllCustomers
  • Create Stored Procedure with one Parameter 
    CREATE PROCEDURE SelectAllCustomers
    @City NVARCHAR(30)
    AS
    SELECT * FROM Customers WHERE City = @City
    GO;
  • Execute Stored Procedure with one Parameter 
    EXEC SelectAllCustomers @City = 'London';
  • Create Stored Procedure with Multiple Parameters 
    CREATE PROCEDURE SelectAllCustomers
    @City NVARCHAR(30), @PostalCode NVARCHAR(10)
    AS
    SELECT * FROM Customers WHERE City = @City AND PostalCode = @PostalCode
    GO;
  • Execute Stored Procedure with Multiple Parameters 
    EXEC SelectAllCustomers @City='London', @PostalCode='WA11DP';

Query​

Others​