如此存储过程
create proc Pr_MtUsed
(@dt datetime,@room nvarchar(20))
as
begin
if exists(select * from meeting where (@dt between mt_startdate and mt_enddate)
and mt_room=@room)
print '该会议室已经被预定'
else
print '该会议室可以被使用'
end这个print 出来的数据 如何用在asp.net ,让它显示出来
create proc Pr_MtUsed
(@dt datetime,@room nvarchar(20))
as
begin
if exists(select * from meeting where (@dt between mt_startdate and mt_enddate)
and mt_room=@room)
print '该会议室已经被预定'
else
print '该会议室可以被使用'
end这个print 出来的数据 如何用在asp.net ,让它显示出来
as
begin
if exists(select * from meeting where (@@dt between mt_startdate and mt_enddate)
and mt_room=@@room)
SELECT @@result='该会议室已经被预定'
else
SELECT @@result='该会议室可以被使用'
end
create proc Pr_MtUsed
(
@dt datetime output,
@room nvarchar(20),
@status bit output
)
as
begin
if exists(select * from meeting where (@dt between mt_startdate and mt_enddate)
and mt_room=@room)
set @status=1
else
set @status=0
enddeclare @dt datetime
declare @room nvarchar(20)
declare @s bit
execute studentDelete @dt='日期',@room='房间',@status=@s output
if (@s=1)
print '该会议室可以被使用'
else
print '该会议室可以被使用'
------------------------------------------------------------------------------
看看这样对不....
as
begin
if exists(select * from meeting where (@@dt between mt_startdate and mt_enddate)
and mt_room=@@room)
SELECT @result='该会议室已经被预定'
else
SELECT @result='该会议室可以被使用'
end
create proc( Pr_MtUsed @dt datetime,@room nvarchar(20),@result nvarchar(20) output )
as
begin
if exists(select * from meeting where (@dt between mt_startdate and mt_enddate)
and mt_room=@room)
SELECT @result='该会议室已经被预定'
else
SELECT @result='该会议室可以被使用'
end
我执行
exec Pr_MtUsed '2008-7-15 15:00:00','第一会议室','这边该写什么呢'
这是在SQL服务器上执行存储过程,而不是。NET前端程序调用SQL中的存储过程