CREATE DATABASE ebap
GO
USE ebap
GO
DROP table dbtime;
CREATE TABLE dbtime
(id INT IDENTITY(1,1),
time datetime)
select CONVERT(varchar,GETDATE(),120)
DECLARE @i INT
SET @i=1
WHILE @i>0
BEGIN
INSERT INTO dbtime(time) VALUES (CONVERT(varchar,GETDATE(),120))
waitfor delay '00:00:30:00'
END
SELECT * FROM dbtime;