/script-kiddie/002_script_kiddie/script-kiddie/node_modules/ace-builds/src-noconflict/snippets/sqlserver.js |
@@ -0,0 +1,76 @@ |
ace.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"; |
|
}); |