diff options
Diffstat (limited to 'emacs.d/lisp/yasnippet/snippets/sql-mode')
7 files changed, 39 insertions, 0 deletions
diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/.yas-parents b/emacs.d/lisp/yasnippet/snippets/sql-mode/.yas-parents new file mode 100644 index 0000000..eed5b44 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/.yas-parents @@ -0,0 +1 @@ +text-mode diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/column b/emacs.d/lisp/yasnippet/snippets/sql-mode/column new file mode 100644 index 0000000..90e4963 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/column @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : , ColumnName ColumnType NOT NULL... +# -- + , ${1:Name} ${2:Type} ${3:NOT NULL} diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint new file mode 100644 index 0000000..989e508 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : CONSTRAINT [..] PRIMARY KEY ... +# -- +CONSTRAINT [${1:PK_Name}] PRIMARY KEY ${2:CLUSTERED} ([${3:ColumnName}]) diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint.1 b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint.1 new file mode 100644 index 0000000..98d89f0 --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/constraint.1 @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : CONSTRAINT [..] FOREIGN KEY ... +# -- +CONSTRAINT [${1:FK_Name}] FOREIGN KEY ${2:CLUSTERED} ([${3:ColumnName}]) diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/create b/emacs.d/lisp/yasnippet/snippets/sql-mode/create new file mode 100644 index 0000000..a34624d --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/create @@ -0,0 +1,10 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : create table ... +# -- +CREATE TABLE [${1:dbo}].[${2:TableName}] +( + ${3:Id} ${4:INT IDENTITY(1,1)} ${5:NOT NULL} +$0 + CONSTRAINT [${6:PK_}] PRIMARY KEY ${7:CLUSTERED} ([$3]) +) +GO diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/create.1 b/emacs.d/lisp/yasnippet/snippets/sql-mode/create.1 new file mode 100644 index 0000000..1323daf --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/create.1 @@ -0,0 +1,12 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : create procedure ... +# -- +CREATE PROCEDURE [${1:dbo}].[${2:Name}] +( + $3 $4 = ${5:NULL} ${6:OUTPUT} +) +AS +BEGIN +$0 +END +GO diff --git a/emacs.d/lisp/yasnippet/snippets/sql-mode/references b/emacs.d/lisp/yasnippet/snippets/sql-mode/references new file mode 100644 index 0000000..f2e4eab --- /dev/null +++ b/emacs.d/lisp/yasnippet/snippets/sql-mode/references @@ -0,0 +1,4 @@ +#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx> +#name : REFERENCES ... +# -- +REFERENCES ${1:TableName}([${2:ColumnName}]) |