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 |
|
hanumanth
Starting Member
21 Posts |
 Posted - 2008-07-31 : 01:48:49
|
| Input xml format :<Request><Profile><Name>Hanu</Name><Name>Siva</Name><Name>Ram</Name></Profiel></Request>i want to get all the names listoutput:NameHanuSivaRami written SELECT NAMES FROM OPENXML(@hxmldoc,'/Request/Profile',2)WITH (NAMES nvarchar(50))but null values are displaying ..can anyone help on this.plz |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
openxml fetching values from xml