ace.define("ace/snippets/sqlserver",[], function(require, exports, module) { "use strict"; exports.snippetText = "# ISNULL\n\ snippet isnull\n\ ISNULL(${1:check_expression}, ${2:replacement_value})\n\ # FORMAT\n\ snippet format\n\ FORMAT(${1:value}, ${2:format})\n\ # CAST\n\ snippet cast\n\ CAST(${1:expression} AS ${2:data_type})\n\ # CONVERT\n\ snippet convert\n\ CONVERT(${1:data_type}, ${2:expression})\n\ # DATEPART\n\ snippet datepart\n\ DATEPART(${1:datepart}, ${2:date})\n\ # DATEDIFF\n\ snippet datediff\n\ DATEDIFF(${1:datepart}, ${2:startdate}, ${3:enddate})\n\ # DATEADD\n\ snippet dateadd\n\ DATEADD(${1:datepart}, ${2:number}, ${3:date})\n\ # DATEFROMPARTS \n\ snippet datefromparts\n\ DATEFROMPARTS(${1:year}, ${2:month}, ${3:day})\n\ # OBJECT_DEFINITION\n\ snippet objectdef\n\ SELECT OBJECT_DEFINITION(OBJECT_ID('${1:sys.server_permissions /*object name*/}'))\n\ # STUFF XML\n\ snippet 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\n\ snippet 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\n\ snippet 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"; exports.scope = "sqlserver"; }); (function() { ace.require(["ace/snippets/sqlserver"], function(m) { if (typeof module == "object" && typeof exports == "object" && module) { module.exports = m; } }); })();