abap.js
1 year ago
abc.js
1 year ago
actionscript.js
1 year ago
ada.js
1 year ago
alda.js
1 year ago
apache_conf.js
1 year ago
apex.js
1 year ago
applescript.js
1 year ago
aql.js
1 year ago
asciidoc.js
1 year ago
asl.js
1 year ago
assembly_x86.js
1 year ago
autohotkey.js
1 year ago
batchfile.js
1 year ago
c9search.js
1 year ago
c_cpp.js
1 year ago
cirru.js
1 year ago
clojure.js
1 year ago
cobol.js
1 year ago
coffee.js
1 year ago
coldfusion.js
1 year ago
crystal.js
1 year ago
csharp.js
1 year ago
csound_document.js
1 year ago
csound_orchestra.js
1 year ago
csound_score.js
1 year ago
csp.js
1 year ago
css.js
1 year ago
curly.js
1 year ago
d.js
1 year ago
dart.js
1 year ago
diff.js
1 year ago
django.js
1 year ago
dockerfile.js
1 year ago
dot.js
1 year ago
drools.js
1 year ago
edifact.js
1 year ago
eiffel.js
1 year ago
ejs.js
1 year ago
elixir.js
1 year ago
elm.js
1 year ago
erlang.js
1 year ago
forth.js
1 year ago
fortran.js
1 year ago
fsharp.js
1 year ago
fsl.js
1 year ago
ftl.js
1 year ago
gcode.js
1 year ago
gherkin.js
1 year ago
gitignore.js
1 year ago
glsl.js
1 year ago
gobstones.js
1 year ago
golang.js
1 year ago
graphqlschema.js
1 year ago
groovy.js
1 year ago
haml.js
1 year ago
handlebars.js
1 year ago
haskell.js
1 year ago
haskell_cabal.js
1 year ago
haxe.js
1 year ago
hjson.js
1 year ago
html.js
1 year ago
html_elixir.js
1 year ago
html_ruby.js
1 year ago
ini.js
1 year ago
io.js
1 year ago
ion.js
1 year ago
jack.js
1 year ago
jade.js
1 year ago
java.js
1 year ago
javascript.js
1 year ago
json.js
1 year ago
json5.js
1 year ago
jsoniq.js
1 year ago
jsp.js
1 year ago
jssm.js
1 year ago
jsx.js
1 year ago
julia.js
1 year ago
kotlin.js
1 year ago
latex.js
1 year ago
latte.js
1 year ago
less.js
1 year ago
liquid.js
1 year ago
lisp.js
1 year ago
livescript.js
1 year ago
logiql.js
1 year ago
logtalk.js
1 year ago
lsl.js
1 year ago
lua.js
1 year ago
luapage.js
1 year ago
lucene.js
1 year ago
makefile.js
1 year ago
markdown.js
1 year ago
mask.js
1 year ago
matlab.js
1 year ago
maze.js
1 year ago
mediawiki.js
1 year ago
mel.js
1 year ago
mips.js
1 year ago
mixal.js
1 year ago
mushcode.js
1 year ago
mysql.js
1 year ago
nginx.js
1 year ago
nim.js
1 year ago
nix.js
1 year ago
nsis.js
1 year ago
nunjucks.js
1 year ago
objectivec.js
1 year ago
ocaml.js
1 year ago
partiql.js
1 year ago
pascal.js
1 year ago
perl.js
1 year ago
pgsql.js
1 year ago
php.js
1 year ago
php_laravel_blade.js
1 year ago
pig.js
1 year ago
plain_text.js
1 year ago
powershell.js
1 year ago
praat.js
1 year ago
prisma.js
1 year ago
prolog.js
1 year ago
properties.js
1 year ago
protobuf.js
1 year ago
puppet.js
1 year ago
python.js
1 year ago
qml.js
1 year ago
r.js
1 year ago
raku.js
1 year ago
razor.js
1 year ago
rdoc.js
1 year ago
red.js
1 year ago
redshift.js
1 year ago
rhtml.js
1 year ago
robot.js
1 year ago
rst.js
1 year ago
ruby.js
1 year ago
rust.js
1 year ago
sac.js
1 year ago
sass.js
1 year ago
scad.js
1 year ago
scala.js
1 year ago
scheme.js
1 year ago
scrypt.js
1 year ago
scss.js
1 year ago
sh.js
1 year ago
sjs.js
1 year ago
slim.js
1 year ago
smarty.js
1 year ago
smithy.js
1 year ago
snippets.js
1 year ago
soy_template.js
1 year ago
space.js
1 year ago
sparql.js
1 year ago
sql.js
1 year ago
sqlserver.js
1 year ago
stylus.js
1 year ago
svg.js
1 year ago
swift.js
1 year ago
tcl.js
1 year ago
terraform.js
1 year ago
tex.js
1 year ago
text.js
1 year ago
textile.js
1 year ago
toml.js
1 year ago
tsx.js
1 year ago
turtle.js
1 year ago
twig.js
1 year ago
typescript.js
1 year ago
vala.js
1 year ago
vbscript.js
1 year ago
velocity.js
1 year ago
verilog.js
1 year ago
vhdl.js
1 year ago
visualforce.js
1 year ago
wollok.js
1 year ago
xml.js
1 year ago
xquery.js
1 year ago
yaml.js
1 year ago
zeek.js
1 year 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 |