diff options
| author | Alexander Sulfrian <alexander@sulfrian.net> | 2009-10-22 05:30:58 +0200 |
|---|---|---|
| committer | Alexander Sulfrian <alexander@sulfrian.net> | 2009-10-22 05:30:58 +0200 |
| commit | c13334d651b13d8b047cb3dc35ad3e1ef239013f (patch) | |
| tree | ce0361f3bbbe502af91b33f896644d5695680223 /emacs.d/snippets/text-mode/sql-mode/create | |
| parent | ff21663ded2283850f175e6de619feb5da91fef4 (diff) | |
| download | dotfiles-c13334d651b13d8b047cb3dc35ad3e1ef239013f.tar.gz dotfiles-c13334d651b13d8b047cb3dc35ad3e1ef239013f.tar.xz dotfiles-c13334d651b13d8b047cb3dc35ad3e1ef239013f.zip | |
added snippets for loading with module from dotfiles
Diffstat (limited to '')
| -rw-r--r-- | emacs.d/snippets/text-mode/sql-mode/create | 10 | ||||
| -rw-r--r-- | emacs.d/snippets/text-mode/sql-mode/create.1 | 12 |
2 files changed, 22 insertions, 0 deletions
diff --git a/emacs.d/snippets/text-mode/sql-mode/create b/emacs.d/snippets/text-mode/sql-mode/create new file mode 100644 index 0000000..a34624d --- /dev/null +++ b/emacs.d/snippets/text-mode/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/snippets/text-mode/sql-mode/create.1 b/emacs.d/snippets/text-mode/sql-mode/create.1 new file mode 100644 index 0000000..1323daf --- /dev/null +++ b/emacs.d/snippets/text-mode/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 |