{

	 "Create Cursor snippet":{
	 "prefix": "sqlCreateCursor",
	 "body": [
		"-- Create a new cursor called '${1:CursorName}' on table '${2:TableName}' with values '${3:ValueName}'",
		"declare @$3 int;",
		"DECLARE $1 CURSOR FOR",
		"   SELECT $3",
		"   FROM $2;",
		"OPEN $1;",
		"FETCH NEXT FROM $1 INTO @$3;",
		"WHILE @@FETCH_STATUS = 0",
		"   BEGIN",
		"       --insert instructions",
		"       FETCH NEXT FROM $1 INTO @$3;",
		"   END;",
		"CLOSE $1;",
		"DEALLOCATE $1;"

	 ],
	"description": "Creating procedure"
	},	 "Create Procedure snippet":{
		"prefix": "sqlCreateProcedure",
		"body": [
			"-- Create a new procedure called '${1:ProcedureName}' in schema '${2:SchemaName}', input '${3:InputName}'",
			"IF OBJECT_ID('$2.$1', 'P') IS NOT NULL",
			"      DROP PROC $2.$1;",
			"GO",
			"CREATE PROC $2.$1",
			"    @$3 AS INT,",
			"    @numrows as INT = 0 OUTPUT",
			"AS",
			"BEGIN",
			"--SET NOCOUNT ON;",
			"SET @numrows = @@ROWCOUNT;",
			"RETURN;",
			"END",
			" ",
			"declare @value int;",
			"exec $2.$1 1,@numrows=@value out"
		],
	   "description": "Creating procedure"
	   },

		"Create Scalar Function snippet":{
		   "prefix": "sqlCreateFunctionScalar",
		   "body": [
			"-- Create a new scalar function called '${1:FunctionName}' in schema '${2:SchemaName}', input '${3:InputName}, input2 '${4:InputName}'",
			"IF OBJECT_ID('$2.$1', 'FN') IS NOT NULL",
			"       DROP FUNCTION $2.$1",
			"GO",
			"CREATE FUNCTION $2.$1",
			"(",
			"       @$3 AS MONEY,",
			"       @$4 AS INT",
			")",
			"RETURNS MONEY",
			"AS",
			"BEGIN",
			"       RETURN @$3 * @$4",
			"END;",
			"GO",
			" ",
			"SELECT $2.$1(1, 2)"
		   ],
		  "description": "Creating Scalar Function"
		  },



		  "Create Inline Function snippet":{
			"prefix": "sqlCreateFunctionInline",
			"body": [
				"-- Create a new inline function called '${1:FunctionName}' in schema '${2:SchemaName}', input '${3:InputName}, input2 '${4:InputName}'",
				"IF OBJECT_ID('$2.$1', 'IF') IS NOT NULL",
				"DROP FUNCTION $2.$1;",
				"GO",
				"CREATE FUNCTION $2.$1",
				"(",
				"       @$3 AS numeric(10),",
				"       @$4 AS numeric(10)",
				")",
				"RETURNS TABLE",
				"AS",
				"RETURN",
				"(",
				"       SELECT *",
				"       FROM table",
				"       WHERE value BETWEEN @$3 AND @$4",
				");",
				"GO",
				" ",
				"select * from $2.$1 (1,2);"
			],
		   "description": "Creating Inline Function"
		   },

		   "Create Table Function snippet":{
			"prefix": "sqlCreateFunctionTable",
			"body": [
				"-- Create a new table function called '${1:FunctionName}' in schema '${2:SchemaName}', input '${3:InputName}, input2 '${4:InputName}'",
				"IF OBJECT_ID('$1.$2', 'TF') IS NOT NULL",
				"DROP FUNCTION $1.$2;",
				"GO",
				"CREATE FUNCTION $1.$2",
				"(",
				"       @$3 AS SMALLINT,",
				"       @$4 AS SMALLINT",
				")",
				"RETURNS @returntable TABLE",
				"(",
				"       data1 INT,",
				"       data2 int,",
				")",
				"AS",
				"BEGIN",
				"       INSERT @returntable",
				"               SELECT data1,data2",
				"               FROM table",
				"               WHERE brc BETWEEN @$3 AND @$4",
				"       RETURN",
				"END;",
				"GO",
				" ",
				"SELECT data1,data2",
				"FROM $1.$2(2,4);"
			],
		   "description": "Creating Table Function"
		   },
	}