Useful Functions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Useful Functions
(Created page with "<pre> /************************************************************************************** aaaaUsefulFunctions.sql - a useful set of global temporary procedures for use with ...") |
|||
| Line 10: | Line 10: | ||
##emp '0024' | ##emp '0024' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##emp') | ||
drop procedure ##emp | drop procedure ##emp | ||
go | go | ||
| Line 56: | Line 57: | ||
##findemp 'Ander' | ##findemp 'Ander' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##findemp') | ||
drop procedure ##findemp | drop procedure ##findemp | ||
go | go | ||
| Line 114: | Line 116: | ||
##jstar '0024' | ##jstar '0024' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##jstar') | ||
drop procedure ##jstar | drop procedure ##jstar | ||
go | go | ||
| Line 134: | Line 137: | ||
##msg 'text' | ##msg 'text' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##msg') | ||
drop procedure ##msg | drop procedure ##msg | ||
go | go | ||
| Line 170: | Line 174: | ||
##posstar '6000008' | ##posstar '6000008' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##posstar') | ||
drop procedure ##posstar | drop procedure ##posstar | ||
go | go | ||
| Line 191: | Line 196: | ||
where 321 is the TBH Sequence number (blank is latest) | where 321 is the TBH Sequence number (blank is latest) | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##tbh') | ||
drop procedure ##tbh | drop procedure ##tbh | ||
go | go | ||
