写一个sql中视图和存储过程的简单创建和调用方法!!!自我备忘用····
刚才想写个存储过程,想不起语法了。在网上查了查找到了!!
写完了又忘了怎么调用了 !晕死!···
赶快写个简单备忘·······················
select * from login
select * from userinfo
select max(id) from login
select * from login a,userinfo b where a.id=b.id
--创建视图
create view LogAndUser
as
select a.id,a.uname,a.upwd,a.lasttime,b.turename,b.age from login a,userinfo b where a.id=b.id
--修改视图
alter view LogAndUser
as
select a.id,a.uname,a.upwd,a.lasttime,b.turename,b.age from login a left join userinfo b on a.id=b.id
--测试视图
select * from LogAndUser
--创建存储过程
alter proc TestProc
(
@id int
)
as
(
select * from login where id=@id
)
--测试存储过程
exec TestProc 3