sql操作记录

use qswl_cjwz
declare @a int
set @a=5

if @a>9
print 'this num more than 9'
else
print 'this num less than 9'

==========================================

---------------------------------------
--select * from news
select replicate(title,2)from news

结果:政务公开政务公开 (本来只有一个政务公开)
政务公开政务公开
政务公开政务公开
政务公开政务公开
新农村1新农村1