sql 查询如何取一个数据库字段的前几位字段
(2009-02-10 14:04:40)
标签:
杂谈 |
分类: SQL Server |
select titleid,Title,Uploaddate,ClassType1,isVidate,brief,conimages
from writings where isvidate=1 and (LEFT(classtype1,2)=@kcodes or
LEFT(classtype2,2)=@kcodes) order by titleid desc