diff options
Diffstat (limited to '')
| -rw-r--r-- | emacs.d/lisp/yasnippet/snippets/sql-mode/create | 10 | ||||
| -rw-r--r-- | emacs.d/lisp/yasnippet/snippets/sql-mode/create.1 | 12 |
2 files changed, 22 insertions, 0 deletions
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 |