Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
parvathaneni.vk
Starting Member
3 Posts |
 Posted - 2008-06-18 : 03:01:46
|
| i have the stored procedure...ALTER procedure [dbo].[xmlpaths]asDeclare @xml VARCHAR(MAX)Declare @i as int select @xml=BulkColumn from openrowset(bulk 'C:\Documents and Settings\Kasi\Desktop\note.xml', single_clob)as cseEXEC sp_xml_preparedocument @i OUTPUT,@xmlSelect * From OpenXML(@i,'/college/cse',2) With (name varchar(50), rollno int, year int)i got the output...but i want to give path as parameter during execution of procedure name. can anyone help me..thanks in advance |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
|
|
bulk load of xml file in sqlserver