create function isnumber (@dt varchar(20)) returns int as begin return isdate(@dt) end go select dbo.isnumber('2011-12-15') /* ----------- 1(1 行受影响) */ select dbo.isnumber('2011-15-55') /* ----------- 0(1 行受影响) */ go drop function dbo.isnumber
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[isnumber]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[isnumber] go create function isnumber (@datetime varchar(20)) returns int as begin return isdate(@datetime) end go
declare @ints int declare @InfoTime varchar(100) declare @Note varchar(200) set @InfoTime = '448978' set @ints = (select isdate(@InfoTime) ) if @ints = 1 set @Note ='您输入的是时间' else set @Note ='您输入的不是时间' print @Note
if object_id('isnumber','FN') is not null drop table isnumber go create function isnumber(@date varchar(10)) returns int as begin return isdate(@date) end go select dbo.isnumber('abc'),dbo.isnumber('2011-01-01')
(@dt varchar(20))
returns int
as
begin
return isdate(@dt)
end
go
select dbo.isnumber('2011-12-15')
/*
-----------
1(1 行受影响)
*/
select dbo.isnumber('2011-15-55')
/*
-----------
0(1 行受影响)
*/
go
drop function dbo.isnumber
drop function [dbo].[isnumber]
go
create function isnumber
(@datetime varchar(20))
returns int
as
begin
return isdate(@datetime)
end
go
declare @InfoTime varchar(100)
declare @Note varchar(200)
set @InfoTime = '448978'
set @ints = (select isdate(@InfoTime) )
if @ints = 1
set @Note ='您输入的是时间'
else
set @Note ='您输入的不是时间'
print @Note
if object_id('isnumber','FN') is not null
drop table isnumber
go
create function isnumber(@date varchar(10))
returns int
as
begin
return isdate(@date)
end
go
select dbo.isnumber('abc'),dbo.isnumber('2011-01-01')