Show Menu
Cheatography

MS SQL Cheat Sheet (DRAFT) by

MS Sql server cheatsheet

This is a draft cheat sheet. It is a work in progress and is not finished yet.

Stored procedures

Alter
ALTER procedure [dbo].[­pr­_te­st_­pro­cedure]
@DateFrom datetime,
@UserId int
as
begin
select

Functions

Alter function
ALTER function [dbo].[­fn­c_t­est­_fu­ncton] (@userId int) returns table as return

Common

Refresh module
EXEC sys.sp­_re­fre­shs­qlm­odule module­_name;