sql批量添加数据（id为bigint类型）

批量初始化企业菜单权限

insert into MenuEnterprise(Id,QYID,MenuDisplayName, MenuID,IsDeleted,CreateTime,EditTime)
select dbo.fn_NewID(NEWID()),企业ID,MenuName,MenuID,IsDelete,GETDATE(),GETDATE() from MENU where ISNULL(IsUseEnterprise,0)=1

函数fn_NewID

Create function [dbo].[fn_NewID]
(
 @Newid nvarchar(50)
)
returns bigint
as
begin
    declare @resultBigint bigint
    DECLARE @resultStr VARCHAR(19),@dateStr VARCHAR(50),@randStr1 VARCHAR(9);
    SELECT    @randStr1 = RIGHT(100000000000 + CONVERT(bigint, ABS(CHECKSUM(@Newid))), 10),
            --@dateStr = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(20),SYSDATETIME(),120),'-',''),':',''),' ','')
            @dateStr =left(replace(replace(replace(replace(CONVERT(varchar, SYSDATETIME() ),'-',''),' ',''),':',''),'.',''),8)
    set @resultStr=@dateStr+@randStr1
    SET @resultBigint = CONVERT(BIGINT, @resultStr);

    return @resultBigint
end