| 类别： |
Javascript, function
|
| 标签： |
func, table, tsql, exists, proc, fExists
|
| 摘要： |
..
|
| 正文： |
- if EXISTS(select 1 from sysobjects where type='fn' and name='fExists')
- Begin
- Drop Function fExists
- End
- Go
- Create Function dbo.fExists
- (-- shawl.qiu TSql
- @vChrTableName varchar(200)
- ,@vChrType varchar(200) = 'u'
- )
- Returns Bit
- As
- Begin
- Set @vChrType = Lower(@vChrType)
- declare @MyVar varchar(200)
-
- set @MyVar =
- Case @vChrType
- when 'p' then
- 'p'
- when 'fn' then 'fn'
- else
- 'u'
- End
- if EXISTS(select 1 from sysobjects where type=@MyVar and name=@vChrTableName)
- Begin
- Return(1)
- End
-
- Return(0)
- End -- end function fExists
- Go
- -- if dbo.fExists('Mytest', default)=1
- -- print 'exists'
- -- else
- -- print 'no exists'
- --
- --
- -- print dbo.fExists('Mytest', default)
- -- print dbo.fExists('Mytestx', default)
- -- print dbo.fExists('pMyTest', 'p')
- -- print dbo.fExists('pMyTestx', 'p')
- --
- -- print dbo.fExists('fExistsTable', 'fn')
- -- print dbo.fExists('fExistsTablex', 'fn')
|
| 文章相关信息: |
|
| 主题: |
检测 存储过程/表/函数是否存在函数 fExists
|
| 发表者: |
shawl.qiu
|
| 电子邮件: |
shawl.qiu@gmail.com
|
| QQ: |
908202921
|
| MSN: |
btbtd@msn.com
|
| Homepage: |
http://www.btbtd.org/
|
| Blog: |
http://blog.csdn.net/btbtd/
|
| 发表日期: |
2007-6-13 18:18:48
|
| 更新日期: |
2007-6-13 18:18:48
|
| 来源引用: |
shawl.qiu CSharp DotNet 个人资料管理系统
|
| 引用本页: |
http://gi.2288.org/mod/code/display/Default.aspx?aid=467
|