完全同意楼上的做法,比如
可以这样:
create procedure mysp_test
as
select * from pubs.dbo.authors
--或
update northwind.dbo.emplyees set lastname='jiang' where employeeid='1'
可以这样:
create procedure mysp_test
as
select * from pubs.dbo.authors
--或
update northwind.dbo.emplyees set lastname='jiang' where employeeid='1'
实际做法如下
/*create procedure mysp_test
as
select * from pubs.dbo.authors
--或
update northwind.dbo.emplyees set lastname='jiang' where employeeid='1'
实际做法如下
/*create procedure mysp_test
as
select * from pubs.dbo.authors
--或
update northwind.dbo.emplyees set lastname='jiang' where employeeid='1'
create view
as
select *
from
xx.xx.xx