SQL Server TSQL Cheat Sheet For Database Programmers

SELECT Day = CASE 
WHEN (DateAdded IS NULL) THEN
'Unknown'
WHEN (DateDiff(day, DateAdded,
getdate()) = 0) THEN 'Today'
WHEN (DateDiff(day, DateAdded,
getdate()) = 1) THEN 'Yesterday'
WHEN (DateDiff(day, DateAdded,
getdate()) = -1) THEN 'Tomorrow'
ELSE DATENAME(dw , DateAdded)
END
FROM Table

ALTER TABLE YourTableName 
ADD[ColumnName] [int] NULL;

EXEC sp_rename
'TableName.OldColName',
'NewColName','COLUMN';

EXEC sp_rename 'OldTableName',
'NewTableName';

ALTER TABLE Products WITH CHECK
ADD CONSTRAINT [FK_Prod_Man]
FOREIGN KEY(ManufacturerID)
REFERENCES Manufacturers (ID);

ALTER TABLE TableName 
ALTER COLUMN ColumnName int NOT NULL;

ALTER TABLE TableName 
ADD CONSTRAINT
DF_TableName_ ColumnName DEFAULT 0 
FOR ColumnName;

ALTER TABLE TableName 
ADD CONSTRAINT CK_CheckName CHECK 
(ColumnValue > 1)

SET @mojo = 1 --THIS IS A COMMENT

/* This is a comment that can span multiple lines*/

BEGIN TRY
-- try / catch requires
SQLServer 2017
-- run your code here
END TRY
BEGIN CATCH
PRINT 'Error Number: ' +
str(error_number())
PRINT 'Line Number: ' +
str(error_line())
PRINT error_message()
-- handle error condition
END CATCH

DECLARE @i int
SET @i = 0
WHILE (@i < 10)
BEGIN
		SET @i = @i + 1
		PRINT @i
		IF (@i >= 10)
			BREAK
		ELSE
			CONTINUE
END

CREATE TABLE TheNameOfYourTable (
	ID INT NOT NULL IDENTITY(1,1),
	DateAdded DATETIME
DEFAULT(getdate()) NOT NULL,
	Description VARCHAR(100) NULL,
	IsGood BIT DEFAULT(0) NOT NULL,
	TotalPrice MONEY NOT NULL,
	CategoryID int NOT NULL
	REFERENCES Categories(ID),
	PRIMARY KEY (ID)
);

CREATE FUNCTION dbo.DoStuff(@ID int)
RETURNS int
AS
BEGIN
DECLARE @result int
IF @ID = 0
BEGIN
RETURN 0
END
SELECT @result = COUNT(*)
FROM table WHERE ID = @ID 
RETURN @result
END
GO
SELECT dbo.DoStuff(0)