Useful Functions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Useful Functions
| Line 240: | Line 240: | ||
##mgr '0024' | ##mgr '0024' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| - | + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##mgr') | |
drop procedure ##mgr | drop procedure ##mgr | ||
go | go | ||
| Line 314: | Line 314: | ||
##psquery 'Query' | ##psquery 'Query' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| - | + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##psquery') | |
drop procedure ##psquery | drop procedure ##psquery | ||
go | go | ||
| Line 421: | Line 421: | ||
##comparetables 'table1','table2','column1,column2...' | ##comparetables 'table1','table2','column1,column2...' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| - | + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##comparetables') | |
drop procedure ##comparetables | drop procedure ##comparetables | ||
go | go | ||
| Line 467: | Line 467: | ||
##comptab 'table1','table2','column1,column2...' | ##comptab 'table1','table2','column1,column2...' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| - | + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##comptab') | |
drop procedure ##comptab | drop procedure ##comptab | ||
go | go | ||
| Line 523: | Line 523: | ||
returns 1 if field there, otherwise 0 | returns 1 if field there, otherwise 0 | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| - | + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##hasField') | |
drop procedure ##hasField | drop procedure ##hasField | ||
go | go | ||
| Line 611: | Line 611: | ||
##abs '00007' | ##abs '00007' | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##abs') | ||
drop procedure ##abs | drop procedure ##abs | ||
go | go | ||
| Line 668: | Line 669: | ||
##findmenu Establishment | ##findmenu Establishment | ||
***************************************************************************************/ | ***************************************************************************************/ | ||
| + | if exists (select * from tempdb..sysobjects where xtype='P' and name='##findmenu') | ||
drop procedure ##findmenu | drop procedure ##findmenu | ||
go | go | ||
