摘要：create proc sp_GenerateSalesNumberasdeclare @sqlstr varchar(255) if exists (select * from sysobjects where id = object_id(N'v_temp') and OBJECTPROPERTY(id, N'IsView') = 1) begin select @sqlstr = 'drop view v_temp' exec(@sqlstr) end begin select @sqlstr = 'create view v_te 阅读全文