PluginProbe ʕ •ᴥ•ʔ
Tracking Code Manager / trunk
Tracking Code Manager vtrunk
trunk 1.11.8 1.11.9 1.12.0 1.12.1 1.12.2 1.12.3 1.4 1.5 2.0.0 2.0.1 2.0.13 2.0.14 2.0.15 2.0.16 2.0.2 2.0.3 2.0.4 2.0.5 2.0.6 2.0.7 2.1.0 2.2.0 2.3.0 2.4.0 2.5.0 2.6.0
tracking-code-manager / assets / js / ace / snippets / sqlserver.js
tracking-code-manager / assets / js / ace / snippets Last commit date
abap.js 3 years ago abc.js 3 years ago actionscript.js 3 years ago ada.js 3 years ago alda.js 3 years ago apache_conf.js 3 years ago apex.js 3 years ago applescript.js 3 years ago aql.js 3 years ago asciidoc.js 3 years ago asl.js 3 years ago assembly_x86.js 3 years ago autohotkey.js 3 years ago batchfile.js 3 years ago c9search.js 3 years ago c_cpp.js 3 years ago cirru.js 3 years ago clojure.js 3 years ago cobol.js 3 years ago coffee.js 3 years ago coldfusion.js 3 years ago crystal.js 3 years ago csharp.js 3 years ago csound_document.js 3 years ago csound_orchestra.js 3 years ago csound_score.js 3 years ago csp.js 3 years ago css.js 3 years ago curly.js 3 years ago d.js 3 years ago dart.js 3 years ago diff.js 3 years ago django.js 3 years ago dockerfile.js 3 years ago dot.js 3 years ago drools.js 3 years ago edifact.js 3 years ago eiffel.js 3 years ago ejs.js 3 years ago elixir.js 3 years ago elm.js 3 years ago erlang.js 3 years ago forth.js 3 years ago fortran.js 3 years ago fsharp.js 3 years ago fsl.js 3 years ago ftl.js 3 years ago gcode.js 3 years ago gherkin.js 3 years ago gitignore.js 3 years ago glsl.js 3 years ago gobstones.js 3 years ago golang.js 3 years ago graphqlschema.js 3 years ago groovy.js 3 years ago haml.js 3 years ago handlebars.js 3 years ago haskell.js 3 years ago haskell_cabal.js 3 years ago haxe.js 3 years ago hjson.js 3 years ago html.js 3 years ago html_elixir.js 3 years ago html_ruby.js 3 years ago ini.js 3 years ago io.js 3 years ago ion.js 3 years ago jack.js 3 years ago jade.js 3 years ago java.js 3 years ago javascript.js 3 years ago json.js 3 years ago json5.js 3 years ago jsoniq.js 3 years ago jsp.js 3 years ago jssm.js 3 years ago jsx.js 3 years ago julia.js 3 years ago kotlin.js 3 years ago latex.js 3 years ago latte.js 3 years ago less.js 3 years ago liquid.js 3 years ago lisp.js 3 years ago livescript.js 3 years ago logiql.js 3 years ago logtalk.js 3 years ago lsl.js 3 years ago lua.js 3 years ago luapage.js 3 years ago lucene.js 3 years ago makefile.js 3 years ago markdown.js 3 years ago mask.js 3 years ago matlab.js 3 years ago maze.js 3 years ago mediawiki.js 3 years ago mel.js 3 years ago mips.js 3 years ago mixal.js 3 years ago mushcode.js 3 years ago mysql.js 3 years ago nginx.js 3 years ago nim.js 3 years ago nix.js 3 years ago nsis.js 3 years ago nunjucks.js 3 years ago objectivec.js 3 years ago ocaml.js 3 years ago partiql.js 3 years ago pascal.js 3 years ago perl.js 3 years ago pgsql.js 3 years ago php.js 3 years ago php_laravel_blade.js 3 years ago pig.js 3 years ago plain_text.js 3 years ago powershell.js 3 years ago praat.js 3 years ago prisma.js 3 years ago prolog.js 3 years ago properties.js 3 years ago protobuf.js 3 years ago puppet.js 3 years ago python.js 3 years ago qml.js 3 years ago r.js 3 years ago raku.js 3 years ago razor.js 3 years ago rdoc.js 3 years ago red.js 3 years ago redshift.js 3 years ago rhtml.js 3 years ago robot.js 3 years ago rst.js 3 years ago ruby.js 3 years ago rust.js 3 years ago sac.js 3 years ago sass.js 3 years ago scad.js 3 years ago scala.js 3 years ago scheme.js 3 years ago scrypt.js 3 years ago scss.js 3 years ago sh.js 3 years ago sjs.js 3 years ago slim.js 3 years ago smarty.js 3 years ago smithy.js 3 years ago snippets.js 3 years ago soy_template.js 3 years ago space.js 3 years ago sparql.js 3 years ago sql.js 3 years ago sqlserver.js 3 years ago stylus.js 3 years ago svg.js 3 years ago swift.js 3 years ago tcl.js 3 years ago terraform.js 3 years ago tex.js 3 years ago text.js 3 years ago textile.js 3 years ago toml.js 3 years ago tsx.js 3 years ago turtle.js 3 years ago twig.js 3 years ago typescript.js 3 years ago vala.js 3 years ago vbscript.js 3 years ago velocity.js 3 years ago verilog.js 3 years ago vhdl.js 3 years ago visualforce.js 3 years ago wollok.js 3 years ago xml.js 3 years ago xquery.js 3 years ago yaml.js 3 years ago zeek.js 3 years ago
sqlserver.js
8 lines
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"}); (function() {
2 ace.require(["ace/snippets/sqlserver"], function(m) {
3 if (typeof module == "object" && typeof exports == "object" && module) {
4 module.exports = m;
5 }
6 });
7 })();
8