Revision: 9327
Updated Code
at November 21, 2008 09:56 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)<CR>
\BEGIN<CR>DROP PROCEDURE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name"}><CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $func IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'FUNCTION'<CR><BS>)<CR>
\BEGIN<CR>DROP FUNCTION dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE FUNCTION dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>SELECT dbo.<{"name"}>()<CR><BS>*/<CR>)<CR>
\RETURNS <{"return_type"}><CR>AS BEGIN<CR>
\<Tab><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS
\WHERE TABLE_NAME = '<{"name"}>') BEGIN<CR>
\DROP VIEW dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name"}><CR>AS<CR>
\/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name"}><CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>
\WHERE TABLE_NAME = '<{"name"}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name"}> (<CR>
\<{}><CR>)<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Snippet $tv DECLARE @<{"name"}> table (<CR><{}><CR>)
Snippet $tt CREATE TABLE #<{"name"}> (<CR><{}><CR>)
Revision: 9326
Updated Code
at November 20, 2008 11:30 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)<CR>
\BEGIN<CR>DROP PROCEDURE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name"}><CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $func IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'FUNCTION'<CR><BS>)<CR>
\BEGIN<CR>DROP FUNCTION dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE FUNCTION dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>SELECT dbo.<{"name"}>()<CR><BS>*/<CR>)<CR>
\RETURNS <{"return_type"}><CR>AS BEGIN<CR>
\<Tab><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS
\WHERE TABLE_NAME = '<{"name"}>') BEGIN<CR>
\DROP VIEW dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name"}><CR>AS<CR>
\/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name"}><CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>
\WHERE TABLE_NAME = '<{"name"}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name"}> (<CR>
\<{}><CR>)<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Snippet $tv DECLARE @<{"name"}> table (<CR><{}><CR>)
Snippet $tt CREATE TABLE #<{"name"}> table (<CR><{}><CR>)
Revision: 9325
Updated Code
at November 19, 2008 16:27 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)<CR>
\BEGIN<CR>DROP PROCEDURE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name"}> <CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $func IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'FUNCTION'<CR><BS>)<CR>
\BEGIN<CR>DROP FUNCTION dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE FUNCTION dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>SELECT dbo.<{"name"}>()<CR><BS>*/<CR>)<CR>
\RETURNS <{"return_type"}><CR>AS BEGIN<CR>
\<Tab><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS
\WHERE TABLE_NAME = '<{"name"}>') BEGIN<CR>
\DROP VIEW dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name"}><CR>AS<CR>
\/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name"}> <CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>
\WHERE TABLE_NAME = '<{"name"}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name"}> (<CR>
\<{}><CR>)<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Snippet $tv DECLARE @<{"name"}> table (<CR><{}><CR>)
Snippet $tt CREATE TABLE #<{"name"}> table (<CR><{}><CR>)
Revision: 9324
Updated Code
at November 18, 2008 11:55 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)<CR>
\BEGIN<CR>DROP PROCEDURE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name"}> <CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $func IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name"}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'FUNCTION'<CR><BS>)<CR>
\BEGIN<CR>DROP FUNCTION dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE FUNCTION dbo.<{"name"}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>SELECT dbo.<{"name"}>()<CR><BS>*/<CR>)<CR>
\RETURNS <{"return_type"}><CR>AS BEGIN<CR>
\<Tab><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS
\WHERE TABLE_NAME = '<{"name"}>') BEGIN<CR>
\DROP VIEW dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name"}><CR>AS<CR>
\/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name"}> <CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>
\WHERE TABLE_NAME = '<{"name"}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name"}><CR>
\PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name"}> (<CR>
\<{}><CR>)<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Snippet $tv DECLARE @<{"name"}> table (<CR><{}><CR>)
Snippet $tt CREATE TABLE #<{"name"}> table (<CR><{}><CR>)
Revision: 9323
Updated Code
at November 6, 2008 10:36 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name":expand("%:t:r")}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)<CR>
\BEGIN<CR>DROP PROCEDURE dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name":expand("%:t:r")}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name":expand("%:t:r")}> <CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $func IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name":expand("%:t:r")}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'FUNCTION'<CR><BS>)<CR>
\BEGIN<CR>DROP FUNCTION dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE FUNCTION dbo.<{"name":expand("%:t:r")}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>SELECT dbo.<{"name":expand("%:t:r")}>()<CR><BS>*/<CR>)<CR>
\RETURNS <{"return_type"}><CR>AS BEGIN<CR>
\<Tab><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS
\WHERE TABLE_NAME = '<{"name":expand("%:t:r")}>') BEGIN<CR>
\DROP VIEW dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name":expand("%:t:r")}><CR>AS<CR>
\/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name":expand("%:t:r")}> <CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>
\WHERE TABLE_NAME = '<{"name":expand("%:t:r")}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name":expand("%:t:r")}> (<CR>
\<{}><CR>)<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Revision: 9322
Updated Code
at November 6, 2008 10:33 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name":expand("%:t:r")}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)<CR>
\BEGIN<CR>DROP PROCEDURE dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name":expand("%:t:r")}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name":expand("%:t:r")}> <CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $func IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name":expand("%:t:r")}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'FUNCTION'<CR><BS>)<CR>
\BEGIN<CR>DROP FUNCTION dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE FUNCTION dbo.<{"name":expand("%:t:r")}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>SELECT dbo.<{"name":expand("%:t:r")}> <CR><BS>*/<CR>)<CR>
\RETURNS <{"return_type"}><CR>AS BEGIN<CR>
\<Tab><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS
\WHERE TABLE_NAME = '<{"name":expand("%:t:r")}>') BEGIN<CR>
\DROP VIEW dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name":expand("%:t:r")}><CR>AS<CR>
\/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name":expand("%:t:r")}> <CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>
\WHERE TABLE_NAME = '<{"name":expand("%:t:r")}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name":expand("%:t:r")}> (<CR>
\<{}><CR>)<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Revision: 9321
Updated Code
at November 6, 2008 10:03 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>
\WHERE ROUTINE_NAME = '<{"name":expand("%:t:r")}>'<CR>
\AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)<CR>
\BEGIN<CR>DROP PROCEDURE dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name":expand("%:t:r")}> (<CR>
\/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name":expand("%:t:r")}> <CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS
\WHERE TABLE_NAME = '<{"name":expand("%:t:r")}>') BEGIN<CR>
\DROP VIEW dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name":expand("%:t:r")}><CR>AS<CR>
\/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name":expand("%:t:r")}> <CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>
\WHERE TABLE_NAME = '<{"name":expand("%:t:r")}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name":expand("%:t:r")}><CR>
\PRINT 'Dropped dbo.<{"name":expand("%:t:r")}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name":expand("%:t:r")}> (<CR><{}><CR>)<CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>PRINT 'Created dbo.<{"name":expand("%:t:r")}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Revision: 9320
Updated Code
at November 5, 2008 12:11 by hoffstein
Updated Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>WHERE ROUTINE_NAME = '<{"name"}>'
\<CR>AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)
\<CR>BEGIN<CR>DROP PROCEDURE dbo.<{"name"}><CR>PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name"}> (<CR>/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name"}> <CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = '<{"name"}>') BEGIN
\<CR>DROP VIEW dbo.<{"name"}><CR>PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name"}><CR>AS<CR>/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name"}> <CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $table IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.TABLES<CR>WHERE TABLE_NAME = '<{"name"}>'
\AND TABLE_SCHEMA = 'dbo'<CR><BS>)<CR>BEGIN<CR>
\DROP TABLE dbo.<{"name"}><CR>PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE TABLE dbo.<{"name"}> (<CR><{}><CR>)<CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Snippet $vc varchar(<{"size"}>)<{}>
Snippet $c char(<{"size"}>)<{}>
Snippet $d decimal(<{"size"}>,<{"precision"}>)<{}>
Revision: 9319
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at October 30, 2008 09:47 by hoffstein
Initial Code
if !exists('loaded_snippet') || &cp
finish
endif
Snippet $proc IF EXISTS (<CR>SELECT 1 FROM INFORMATION_SCHEMA.ROUTINES<CR>WHERE ROUTINE_NAME = '<{"name"}>'
\<CR>AND ROUTINE_SCHEMA = 'dbo'<CR>AND ROUTINE_TYPE = 'PROCEDURE'<CR><BS>)
\<CR>BEGIN<CR>DROP PROCEDURE dbo.<{"name"}><CR>PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE PROCEDURE dbo.<{"name"}> (<CR>/*<CR> Sample calls:<CR>
\<BS><Tab>EXEC <{"name"}> <CR><BS>*/<CR>)<CR>AS BEGIN<CR>
\<Tab>SET NOCOUNT ON<CR><{}><CR>END<CR>GO<CR><CR>IF @@ERROR = 0<CR>
\PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $view IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = '<{"name"}>') BEGIN
\<CR>DROP VIEW dbo.<{"name"}><CR>PRINT 'Dropped dbo.<{"name"}>'<CR>
\END<CR>GO<CR><CR>CREATE VIEW dbo.<{"name"}><CR>AS<CR>/* Sample calls:<CR>
\<Tab>SELECT * FROM <{"name"}> <CR><BS>*/<CR><{}><CR>GO<CR>
\<CR>IF @@ERROR = 0<CR>PRINT 'Created dbo.<{"name"}>'<CR><BS>GO<CR>
Snippet $sum SUM(<{"field"}>) AS <{"field"}>,<{}>
Initial URL
http://www.vim.org/scripts/script.php?script_id=1318
Initial Description
These snippets can be used with TSQL files (assuming .sql extension) by saving the below code to vimfiles/after/ftplugin/sql_snippets.vim. * **$proc** - creates the skeleton for a TSQL stored procedure, including dropping the old procedure if it already exists. * **$func** - creates the skeleton for a TSQL user-defined function (scalar), including dropping the old function if it already exists. * **$view** - creates the skeleton for a TSQL view, including dropping the old view if it already exists. * **$table** - creates the skeleton for a TSQL table, including dropping the old table if it already exists. * **$sum** - creates a TSQL SUM statement using the specified field and creates an alias to preserve the field name. * **$vc** - creates a varchar definition using the specified size. * **$c** - creates a char definition using the specified size. * **$d** - creates a decimal definition using the specified size and precision. * **$tv** - creates a table variable definition. * **$tt** - creates a temp table definition.
Initial Title
TSQL snippets for snippetsEmu
Initial Tags
Initial Language
Other