ALTER PROCEDURE [dbo].[aapro]
AS
declare @n int
set @n=0
while @n<1000
begin
insert into dome.dbo.aa(RESOURCE_TYPE_STATICNAME,RESOURCE_TYPE_NAME,RESOURCE_TYPE_EXTAND_FIELD,RESOURCE_TYPE_STATE)VALUES ('PLACE','办公地点',CAST('<FieldDefine><Field FieldID="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" Name="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" StaticName="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" Type="Integer" DisplayName="数量" Hidden="FALSE" Sealed="TRUE" /><Field FieldID="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" Name="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" StaticName="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" Type="Integer" DisplayName="数量" Hidden="FALSE" Sealed="TRUE" /><Field FieldID="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" Name="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" StaticName="{'+ (SELECT CAST(NEWID() AS NVARCHAR(36))) +'}" Type="Integer" DisplayName="数量" Hidden="FALSE" Sealed="TRUE" /></FieldDefine>' AS xml),'TRUE')
set @n=@n+1
END