if exists(select name from sysobjects where name= 'Tview ' and type= 'P ')
drop procedure Tview
go
create procedure Tview
(@deptname varchar(15))
as
declare @sql varchar(2000)
set @sql= 'create view choice_view as select * from choice where left(course_no,2)
in
(select dept_no from dept where dept_name= '+ ' ' '[email protected]+ ' ' '+ ') '
exec （@sql）
go
------解决方案--------------------
可以實現的，樓主的代碼只要稍微修改即可。
if exists(select name from sysobjects where name= 'Tview ' and type= 'P ')
drop procedure Tview
go
create procedure Tview
(@deptname varchar(15))
as
if exists(select name from sysobjects where name= 'choice_view ' and type= 'V ')
drop view choice_view --加上代碼判斷choice_view是否存在，存在就先刪除
declare @sql varchar(2000)
set @sql= 'create view choice_view as select * from choice where left(course_no,2)
in
(select dept_no from dept where dept_name= ' ' '+ @deptname+ ' ' ') ' --你的拼結語句寫的有問題，需要修改為如此
exec(@sql) --全角的括號改為半角的
go