<code> create table tblEmp ( empid int identity(1,1), empDesc xml ) GO declare @i int set @i=1 while @i < 200 begin insert into tblEmp values( '<employees> <employee dept="ITS"> <id>'+convert(varchar, @i)+'</id> <name>NAME'+convert(varchar, @i)+'</name> <address>ADDRESS'+convert(varchar, @i)+'</address> <phone> <homeph valid="true">HOMEPHONE'+convert(varchar, @i)+'</homeph> <workph>WORKPH'+convert(varchar, @i)+'</workph> </phone> </employee> </employees>') set @i = @i +1 end Go</code>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)