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
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
这样可以分页，但是我在后面想加个条件
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
数据库表中有一列（TranXml）类型是xml，存储的是类似
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
的信息，并且通过查询方� ......
