exec ('SELECT dept as 报修部门,maintenanceman as 维修人员,[content] as 报修内容,accomplishtime as 完成时间 from maintenance_apply_accept where convert(varchar(20) ,accomplishtime ,111) like '‘'+ @myyear +'/'+ @mymonth+'%’‘ order by maintenanceman ’ )
--没看出错误,感覺與別名無關 set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go create procedure [dbo].[pro_maintenance_cost] @myyear varchar(4), @mymonth varchar(2) as SELECT dept as 报修部门,maintenanceman as 维修人员,[content] as 报修内容,accomplishtime as 完成时间 from maintenance_apply_accept where convert(varchar(20) ,accomplishtime ,111) like @myyear+'/'+@mymonth+'%' order by maintenanceman
上面都不对啦甚至把存储过程改成如下create procedure [dbo].[pro_test] AS ( SELECT * from maintenance_apply_accept order by maintenanceman )还是出错啦,一样的错误
--try create procedure [dbo].[pro_test] AS SELECT * from maintenance_apply_accept order by cast(maintenanceman as varchar(8000))
create procedure [dbo].[pro_test] as begin select * from maintenance_apply_accept order by maintenanceman end go
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
create procedure [dbo].[pro_maintenance_cost]
@myyear varchar(4),
@mymonth varchar(2)
as
SELECT dept as 报修部门,maintenanceman as 维修人员,[content] as 报修内容,accomplishtime as 完成时间
from maintenance_apply_accept
where convert(varchar(20) ,accomplishtime ,111) like @myyear+'/'+@mymonth+'%' order by maintenanceman
AS
(
SELECT *
from maintenance_apply_accept
order by maintenanceman
)还是出错啦,一样的错误
create procedure [dbo].[pro_test]
AS SELECT *
from maintenance_apply_accept
order by cast(maintenanceman as varchar(8000))
create procedure [dbo].[pro_test]
as
begin
select *
from maintenance_apply_accept
order by maintenanceman
end
go