From c13334d651b13d8b047cb3dc35ad3e1ef239013f Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Thu, 22 Oct 2009 05:30:58 +0200
Subject: added snippets for loading with module from dotfiles

---
 emacs.d/snippets/text-mode/sql-mode/column       |  4 ++++
 emacs.d/snippets/text-mode/sql-mode/constraint   |  4 ++++
 emacs.d/snippets/text-mode/sql-mode/constraint.1 |  4 ++++
 emacs.d/snippets/text-mode/sql-mode/create       | 10 ++++++++++
 emacs.d/snippets/text-mode/sql-mode/create.1     | 12 ++++++++++++
 emacs.d/snippets/text-mode/sql-mode/references   |  4 ++++
 6 files changed, 38 insertions(+)
 create mode 100644 emacs.d/snippets/text-mode/sql-mode/column
 create mode 100644 emacs.d/snippets/text-mode/sql-mode/constraint
 create mode 100644 emacs.d/snippets/text-mode/sql-mode/constraint.1
 create mode 100644 emacs.d/snippets/text-mode/sql-mode/create
 create mode 100644 emacs.d/snippets/text-mode/sql-mode/create.1
 create mode 100644 emacs.d/snippets/text-mode/sql-mode/references

(limited to 'emacs.d/snippets/text-mode/sql-mode')

diff --git a/emacs.d/snippets/text-mode/sql-mode/column b/emacs.d/snippets/text-mode/sql-mode/column
new file mode 100644
index 0000000..90e4963
--- /dev/null
+++ b/emacs.d/snippets/text-mode/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/snippets/text-mode/sql-mode/constraint b/emacs.d/snippets/text-mode/sql-mode/constraint
new file mode 100644
index 0000000..989e508
--- /dev/null
+++ b/emacs.d/snippets/text-mode/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/snippets/text-mode/sql-mode/constraint.1 b/emacs.d/snippets/text-mode/sql-mode/constraint.1
new file mode 100644
index 0000000..98d89f0
--- /dev/null
+++ b/emacs.d/snippets/text-mode/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/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
diff --git a/emacs.d/snippets/text-mode/sql-mode/references b/emacs.d/snippets/text-mode/sql-mode/references
new file mode 100644
index 0000000..f2e4eab
--- /dev/null
+++ b/emacs.d/snippets/text-mode/sql-mode/references
@@ -0,0 +1,4 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : REFERENCES ...
+# --
+REFERENCES ${1:TableName}([${2:ColumnName}])
-- 
cgit v1.2.3