问题1:
/*--查询090101-090103排班--*/
use Attendance
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
as
declare @sql varchar(8000)
set @sql='select * from personbanzhong where convert(varchar(10),pbz_date,121) between '''+2010-09-01+''' and '''+2010-09-03''''
exec(@sql)
go
exec proc_pbz9
服务器: 消息 170,级别 15,状态 1,过程 proc_pbz9,行 4
第 4 行: ''' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: 'and2010' 附近有语法错误。问题2:
/*---求特定月份班种表---*/use Attendance
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
@year varchar(10) ,
@month varchar(10),
as
declare @sql varchar(8000)
/*----------------条件不会,请帮忙----------------------*/
set @sql='select * from personbanzhong where pbz_data(时间格式是2010-09-03 00:00:00) 条件 ???'
exec(@sql)
go
exec proc_pbz9
/*--查询090101-090103排班--*/
use Attendance
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
as
declare @sql varchar(8000)
set @sql='select * from personbanzhong where convert(varchar(10),pbz_date,121) between '''+2010-09-01+''' and '''+2010-09-03''''
exec(@sql)
go
exec proc_pbz9
服务器: 消息 170,级别 15,状态 1,过程 proc_pbz9,行 4
第 4 行: ''' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: 'and2010' 附近有语法错误。问题2:
/*---求特定月份班种表---*/use Attendance
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
@year varchar(10) ,
@month varchar(10),
as
declare @sql varchar(8000)
/*----------------条件不会,请帮忙----------------------*/
set @sql='select * from personbanzhong where pbz_data(时间格式是2010-09-03 00:00:00) 条件 ???'
exec(@sql)
go
exec proc_pbz9
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
as
declare @sql varchar(8000)
set @sql='select * from personbanzhong
where convert(varchar(10),pbz_date,121) between
''2010-09-01'' and ''2010-09-03'''
exec(@sql)
go
exec proc_pbz9use Attendance
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
@year varchar(10) ,
@month varchar(10),
as
declare @sql varchar(8000)
/*----------------条件不会,请帮忙----------------------*/
set @sql='select * from personbanzhong where pbz_data=''2010-09-03 00:00:00'''
exec(@sql)
go
exec proc_pbz9
declare @str varchar(100)
declare @str2 varchar(100)
set @str='2010-08-04'
set @str2 = '2010-08-16'
set @sql='select * from personbanzhong where convert(varchar(10),pbz_date,121) between '''+@str+''' and '''+@str2+''''
print @sql
问题2:
/*---求特定月份班种表---*/use Attendance
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
@year varchar(10) ,
@month varchar(10),
as
declare @sql varchar(8000)
/*----------------条件不会,请帮忙----------------------*/
set @sql='select * from personbanzhong where pbz_data 条件 ???'
exec(@sql)
go
exec proc_pbz9
use Attendance
if exists (select * from sysobjects where name='pro_pbz9')
drop proc proc_pbz9
go
create proc proc_pbz9
(
@year int,
@month int
)
as
declare @sql varchar(8000)
/*----------------条件不会,请帮忙----------------------*/
set @sql='select * from personbanzhong where datepart(yy,pbz_date)='+cast(@year as varchar(10))+'and datepart(mm,pbz_date)='+cast(@month as varchar(10))+''print(@sql)
go
exec proc_pbz9 2010,09把年,月单独出来