corrade-nucleus-nucleons – Blame information for rev 20

Subversion Repositories:
Rev:
Rev Author Line No. Line
20 office 1 ace.define("ace/snippets/sqlserver",["require","exports","module"], function(require, exports, module) {
2 "use strict";
3  
4 exports.snippetText = "# ISNULL\n\
5 snippet isnull\n\
6 ISNULL(${1:check_expression}, ${2:replacement_value})\n\
7 # FORMAT\n\
8 snippet format\n\
9 FORMAT(${1:value}, ${2:format})\n\
10 # CAST\n\
11 snippet cast\n\
12 CAST(${1:expression} AS ${2:data_type})\n\
13 # CONVERT\n\
14 snippet convert\n\
15 CONVERT(${1:data_type}, ${2:expression})\n\
16 # DATEPART\n\
17 snippet datepart\n\
18 DATEPART(${1:datepart}, ${2:date})\n\
19 # DATEDIFF\n\
20 snippet datediff\n\
21 DATEDIFF(${1:datepart}, ${2:startdate}, ${3:enddate})\n\
22 # DATEADD\n\
23 snippet dateadd\n\
24 DATEADD(${1:datepart}, ${2:number}, ${3:date})\n\
25 # DATEFROMPARTS \n\
26 snippet datefromparts\n\
27 DATEFROMPARTS(${1:year}, ${2:month}, ${3:day})\n\
28 # OBJECT_DEFINITION\n\
29 snippet objectdef\n\
30 SELECT OBJECT_DEFINITION(OBJECT_ID('${1:sys.server_permissions /*object name*/}'))\n\
31 # STUFF XML\n\
32 snippet stuffxml\n\
33 STUFF((SELECT ', ' + ${1:ColumnName}\n\
34 FROM ${2:TableName}\n\
35 WHERE ${3:WhereClause}\n\
36 FOR XML PATH('')), 1, 1, '') AS ${4:Alias}\n\
37 ${5:/*https://msdn.microsoft.com/en-us/library/ms188043.aspx*/}\n\
38 # Create Procedure\n\
39 snippet createproc\n\
40 -- =============================================\n\
41 -- Author: ${1:Author}\n\
42 -- Create date: ${2:Date}\n\
43 -- Description: ${3:Description}\n\
44 -- =============================================\n\
45 CREATE PROCEDURE ${4:Procedure_Name}\n\
46 ${5:/*Add the parameters for the stored procedure here*/}\n\
47 AS\n\
48 BEGIN\n\
49 -- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.\n\
50 SET NOCOUNT ON;\n\
51 \n\
52 ${6:/*Add the T-SQL statements to compute the return value here*/}\n\
53 \n\
54 END\n\
55 GO\n\
56 # Create Scalar Function\n\
57 snippet createfn\n\
58 -- =============================================\n\
59 -- Author: ${1:Author}\n\
60 -- Create date: ${2:Date}\n\
61 -- Description: ${3:Description}\n\
62 -- =============================================\n\
63 CREATE FUNCTION ${4:Scalar_Function_Name}\n\
64 -- Add the parameters for the function here\n\
65 RETURNS ${5:Function_Data_Type}\n\
66 AS\n\
67 BEGIN\n\
68 DECLARE @Result ${5:Function_Data_Type}\n\
69 \n\
70 ${6:/*Add the T-SQL statements to compute the return value here*/}\n\
71 \n\
72 END\n\
73 GO";
74 exports.scope = "sqlserver";
75  
76 });