diff options
| author | Mario Vavti <mario@mariovavti.com> | 2016-06-10 12:22:01 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2016-06-10 12:22:01 +0200 |
| commit | 86985b454f75ac7f87e0dfe94fd754d7cbb0bf09 (patch) | |
| tree | 42094d12360158d96bf8149d1b7a4c25e5445430 /library/ace/snippets/sqlserver.js | |
| parent | 9d5d3a946817c1b1a9dc18dead85bc989e820564 (diff) | |
| parent | c55a7b5f362e62696ef7d44cc972cb46c2802646 (diff) | |
| download | volse-hubzilla-86985b454f75ac7f87e0dfe94fd754d7cbb0bf09.tar.gz volse-hubzilla-86985b454f75ac7f87e0dfe94fd754d7cbb0bf09.tar.bz2 volse-hubzilla-86985b454f75ac7f87e0dfe94fd754d7cbb0bf09.zip | |
Merge branch 'dev' into sabre32
Diffstat (limited to 'library/ace/snippets/sqlserver.js')
| -rw-r--r-- | library/ace/snippets/sqlserver.js | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/library/ace/snippets/sqlserver.js b/library/ace/snippets/sqlserver.js new file mode 100644 index 000000000..57eb98625 --- /dev/null +++ b/library/ace/snippets/sqlserver.js @@ -0,0 +1 @@ +ace.define("ace/snippets/sqlserver",["require","exports","module"],function(e,t,n){"use strict";t.snippetText="# ISNULL\nsnippet isnull\n ISNULL(${1:check_expression}, ${2:replacement_value})\n# FORMAT\nsnippet format\n FORMAT(${1:value}, ${2:format})\n# CAST\nsnippet cast\n CAST(${1:expression} AS ${2:data_type})\n# CONVERT\nsnippet convert\n CONVERT(${1:data_type}, ${2:expression})\n# DATEPART\nsnippet datepart\n DATEPART(${1:datepart}, ${2:date})\n# DATEDIFF\nsnippet datediff\n DATEDIFF(${1:datepart}, ${2:startdate}, ${3:enddate})\n# DATEADD\nsnippet dateadd\n DATEADD(${1:datepart}, ${2:number}, ${3:date})\n# DATEFROMPARTS \nsnippet datefromparts\n DATEFROMPARTS(${1:year}, ${2:month}, ${3:day})\n# OBJECT_DEFINITION\nsnippet objectdef\n SELECT OBJECT_DEFINITION(OBJECT_ID('${1:sys.server_permissions /*object name*/}'))\n# STUFF XML\nsnippet stuffxml\n STUFF((SELECT ', ' + ${1:ColumnName}\n FROM ${2:TableName}\n WHERE ${3:WhereClause}\n FOR XML PATH('')), 1, 1, '') AS ${4:Alias}\n ${5:/*https://msdn.microsoft.com/en-us/library/ms188043.aspx*/}\n# Create Procedure\nsnippet createproc\n -- =============================================\n -- Author: ${1:Author}\n -- Create date: ${2:Date}\n -- Description: ${3:Description}\n -- =============================================\n CREATE PROCEDURE ${4:Procedure_Name}\n ${5:/*Add the parameters for the stored procedure here*/}\n AS\n BEGIN\n -- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.\n SET NOCOUNT ON;\n \n ${6:/*Add the T-SQL statements to compute the return value here*/}\n \n END\n GO\n# Create Scalar Function\nsnippet createfn\n -- =============================================\n -- Author: ${1:Author}\n -- Create date: ${2:Date}\n -- Description: ${3:Description}\n -- =============================================\n CREATE FUNCTION ${4:Scalar_Function_Name}\n -- Add the parameters for the function here\n RETURNS ${5:Function_Data_Type}\n AS\n BEGIN\n DECLARE @Result ${5:Function_Data_Type}\n \n ${6:/*Add the T-SQL statements to compute the return value here*/}\n \n END\n GO",t.scope="sqlserver"})
\ No newline at end of file |