create procedure proceemployee
@var char(10)
as
select code,name,ime,sex,age,isteacher,department
from employee
where code = @var
当没有参数时就成功,但加了'@var'参数之后就失败了
...全文
20421打赏收藏
怎样用储存过程创建数据窗口
create procedure proceemployee @var char(10) as select code,name,ime,sex,age,isteacher,department from employee where code = @var 当没有参数时就成功,但加了'@var'参数之后就失败了
TO lzheng2001(1加1=0
不行呀!试过了
(选中 MANUAL RESULT SET )
是可以做出数据窗口,但只要一检索就出错了
new->datawindow->store procedure->选择一个sp -> next -> ...->ready to create grid
datawindow
提示是:'SQLSTATE = 22005
Invalid character value for cast speicification
1 execute dbo.proceemployee;1 @var = :var'