数据库存储过程+视图模板

最新推荐文章于 2025-05-28 21:39:25 发布

weixin_30410999

最新推荐文章于 2025-05-28 21:39:25 发布

阅读量192

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/baixiaoyuan/p/9098976.html

/*存储过程创建*/
USE [BookDB]
go
set ansi_nulls on
go
set quoted_identifier on
go
create procedure [dbo].[book_selectBookName]
@BookName varchar(100)
as
begin
select gi_xuetangzhishu.xietangbianhao,gi_xuetangzhishu.shiwumingcheng,gi_xuetangzhishu.xuetangzhishu,gi_type.type
from gi_xuetangzhishu,gi_type where gi_xuetangzhishu.typeid=gi_type.typeid
end

/*调用存储过程*/
exec book_selectBookName '2'

/*c创建视图*/
use [BookDB]
go
create view v_Name
as
select * from dbo.Book where BookName=123

/*调用视图*/
select * from v_Name

转载于:https://www.cnblogs.com/baixiaoyuan/p/9098976.html