存储过程每天运行一次,怎么判断
sisiz 2008-04-11 09:44:06 CREATE PROCEDURE [dbo].[ShowDWSCiTiao]
AS
declare @Everyday datetime
IF @Everyday =convert(varchar(10),getdate(),120)
begin
select top 10 GID, Noun from table where DATALENGTH(Content) < 500 order by NEWID()
end
GO
那里错误??