CREATE FUNCTION [dbo].[uf_getsysid] ()
RETURNS decimal AS
BEGIN
declare @id numeric
execute master..XP_GETSYSID @id output
return @id
END
CREATE TABLE TB
(
RQ DATETIME NOT NULL,
SPID BIGINT NOT NULL,
CKID BIGINT NOT NULL,
PCID BIGINT NOT NULL,
JCSL INT,
JCDJ INT,
JCJE INT
)
DECLARE @n INT
SET @n=0
WHILE @n<100000
BEGIN
SELECT RQ=GETDATE(),SPID=uf_getsysid(),CKID=uf_getsysid(),PCID=uf_getsysid(),JCSL=NULL,JCDJ=NULL,JCJE=NULL
INTO TB
@n=@n+1
END