CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql=''
if (@username<>null and @username<>'' )
set @sql=@sql+'username like '+char(39)+'%'+@username+'%'+char(39)
if (@companyname<>null and @companyname<>'' and @sql<>'')
set @sql=@sql+' and companyname like '+char(39)+'%'+@companyname+'%'+char(39)
else if (@companyname<>null and @companyname<>'' and @sql='')
set @sql=@sql+'companyname like'+char(39)+' %'+@companyname+'%'+char(39)
if (@endtime='1' and @sql<>'')
set @sql=@sql+' and '+datediff+char(40)+'endviptime,'+getDate()+char(41)+'<0'
else if(@endtime='1' and @sql='')
set @sql=@sql+datediff+char(40)+'endviptime,'+getDate()+char(41)+'<0'
if (@endtime='0' and @sql<>'')
set @sql=@sql+' and '+datediff+char(40)+'endviptime,'+getDate()+char(41)+'=0'
else if(@endtime='0' and @sql='')
set @sql=@sql+datediff+char(40)+'endviptime,'+getDate()+char(41)+'=0'
if (@sql<>'')
set @sql='select username,companyname,createtime,endviptime,vb_id from admin_vcompanybase where isvip=1 and '+@sql
else
set @sql='select username,companyname,createtime,endviptime,vb_id from admin_vcompanybase mowhere isvip=1'
exec(@sql)
GO
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
