diff options
| author | Alexander Sulfrian <alexander@sulfrian.net> | 2012-04-24 23:29:38 +0200 |
|---|---|---|
| committer | Alexander Sulfrian <alexander@sulfrian.net> | 2012-04-24 23:29:38 +0200 |
| commit | 7a6bb0f05e349068b0a89514f1da33d6d7de30a9 (patch) | |
| tree | c202b81dfaf524e71e881c15aa509c45445a64b3 /emacs.d/lisp/yasnippet/snippets/sql-mode/create | |
| parent | 66b95ab46d870f41c12c489eb21c9c82846d6112 (diff) | |
| download | dotfiles-7a6bb0f05e349068b0a89514f1da33d6d7de30a9.tar.gz dotfiles-7a6bb0f05e349068b0a89514f1da33d6d7de30a9.tar.xz dotfiles-7a6bb0f05e349068b0a89514f1da33d6d7de30a9.zip | |
emacs.d/lisp/yasnippet: added yasnippet
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 |