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
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