summaryrefslogtreecommitdiffstats
path: root/emacs.d/snippets/text-mode/sql-mode/create
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--emacs.d/snippets/text-mode/sql-mode/create10
-rw-r--r--emacs.d/snippets/text-mode/sql-mode/create.112
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