|
Home > Archive > MS SQL XML > December 2006 > Schema Collection XMl for Table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Schema Collection XMl for Table
|
|
| sqlextreme 2006-12-05, 7:17 pm |
| It is possible to validate a XML with a plan that be a field of a table?
for example:
tbcs_schema is a field of a table
declare
@Schema xml,
select @shema = tbcs_schema from table
declare
@xml xml(@shema)
something like that
| |
|
| We will be happy if that's possible. However,
No.
You should create xml schema collection first. Even after create it, you
can't use it on the same batch.
"sqlextreme" < sqlextreme@discussio
ns.microsoft.com> wrote in message
news:8B96E62C-8083-4253-8B6E- 75D960C16F6A@microso
ft.com...
> It is possible to validate a XML with a plan that be a field of a table?
> for example:
>
> tbcs_schema is a field of a table
>
> declare
> @Schema xml,
>
> select @shema = tbcs_schema from table
>
> declare
> @xml xml(@shema)
>
> something like that
| |
| Prakash V 2006-12-07, 7:14 pm |
| If you are using stored procedure , you can validate the parameter of the
stored procedure with the same schema which you have used in the table.
Regards,
Prakash.V
"Han" <hp4444@kornet.net.korea> wrote in message
news:uFkx2leGHHA.1064@TK2MSFTNGP04.phx.gbl...
> We will be happy if that's possible. However,
>
> No.
>
> You should create xml schema collection first. Even after create it, you
> can't use it on the same batch.
>
> "sqlextreme" < sqlextreme@discussio
ns.microsoft.com> wrote in message
> news:8B96E62C-8083-4253-8B6E- 75D960C16F6A@microso
ft.com...
>
>
|
|
|
|
|