corrade-nucleus-nucleons – Blame information for rev 20
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
20 | office | 1 | 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 | }); |