summaryrefslogtreecommitdiffstats
path: root/emacs.d/lisp/yasnippet/snippets/sql-mode
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/.yas-parents1
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/column4
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/constraint4
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/constraint.14
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/create10
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/create.112
-rw-r--r--emacs.d/lisp/yasnippet/snippets/sql-mode/references4
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}])