Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
SQL
ce
clients
clustering
connect
datamining
datawarehouse
dts
fulltext
jdbcdriver
msde
mseq
newusers
notificationsvcs
odbc
olap
programming
replication
reportingsvcs
security
securitytools
server
setup
sqlxml.viewmapper
tools
xml
  
 
date: Fri, 13 Jun 2008 13:39:22 -0300,    group: microsoft.public.sqlserver.xml        back       


sql:relation and sql:field   
hi
a have a "code" element in my schema
this element maps to the "client" table (wich PK is "client_id" )

i need to get, for a specific node
the whole xml but adding the "client.name" field
without having to write any specific code in the query

thus, i just store the "code"
and later, i will retrieve the "code" and "name"
in a transparent/implicit way
...a kind of "access/get method"...
declared in the schema or associated to it...

it is possible??
thanks
ks
date: Fri, 13 Jun 2008 13:39:22 -0300   author:   keyser soze

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us