日期:2014-05-17 浏览次数:20766 次
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'sp_select_suiji' AND type = 'P')
DROP PROCEDURE sp_select_suiji
GO
create procedure sp_select_suiji
as
SELECT top 3* FROM Heigth
WHERE 0.01 >= CAST(CHECKSUM(NEWID(), xuhao ) & 0x7fffffff AS float) / CAST (0x7fffffff AS int)
And CONVERT(varchar(20),shijian , 120 ) like '2013-06-01%'
go
exec sp_select_suiji