| define("ace/snippets/sqlserver",["require","exports","module"], 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"; |
| |
| }); |