ArCiGo

SELECT CASE ("column_name") 
  WHEN "value1" THEN "result1" 
  WHEN "value2" THEN "result2" 
  ... 
  [ELSE "resultN"] 
  END
FROM "table_name";

ArCiGo

IF DATENAME(weekday, GETDATE()) IN ('Saturday', 'Sunday')
    SELECT 'Weekend'
ELSE
    SELECT 'Weekday'
            
/** Output **/
-------
Weekend

ArCiGo

IF boolean_expression   
     { sql_statement | statement_block }   
[ ELSE   
     { sql_statement | statement_block } ] 

ArCiGo

DELETE Customer
WHERE Id = 92;
GO

/** Output **/
Id          FirstName                                LastName                                 City                                     Country                                  Phone
----------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- --------------------
(0 row(s) affected)

ArCiGo

DELETE FROM "table_name"
WHERE "condition";

ArCiGo

UPDATE Customer
SET LastName = 'Leal'
WHERE Id = 92

SELECT *
FROM Customer cus
WHERE cus.Id = 92

/** Output **/
Id          FirstName                                LastName                                 City                                     Country                                  Phone

ArCiGo

UPDATE "table_name"
SET column_1 = [value1],
    column_2 = [value2],
    ...
WHERE "condition";

ArCiGo

BULK INSERT Customer	-- Table name
FROM 'yourDirectoryPath\InsertCustomer_Text.txt'	--txt or CSV file
WITH(
	FIELDTERMINATOR= ',',
	ROWTERMINATOR = '\n' 
);

ArCiGo

INSERT INTO Customer(FirstName, LastName, City, Country, Phone)
    VALUES('Pedro', 'DiBella Nava', 'Tampico', 'México', '121-45-53');
GO
    
SELECT *
FROM Customer;
GO

/** Output **/
Id          FirstName                                LastName                                 City                                     Country                                  Phone

ArCiGo

INSERT INTO "table_name" ("column1", "column2", ...)
  VALUES ("value1", "value2", ...);