存储过程相关

select * from sysobjects where xtype='p' --查看存储过程
select * from sysobjects where xtype='u'  --查看表

select Ad_Complain as c,Ad_date as d from Advice

 

 

left()

in()

convert(varchar(10),getdate(),120)  //yyyy-dd-mm