in the SQL Query Analyzer I can use
select {fn UPDATELINEAGE(0x0, 1)}
and get result set like 0x0100000001000000FF back from SQL server, no
document describes what the syntax is for {fn UPDATELINEAGE(0x0, 1)}. Does
any one know this?
Thank you
Xinmin zhouThere won't be. There are quite a few odbc functions that are used
internally by MS. This one in particular is used in sp_MSaddmergetriggers.
You probably want to stay away from undocumented functions anyway...
-oj
"Syntax of {fn UPDATELINEAGE(0x0, 1)}" <Syntax of {fn UPDATELINEAGE(0x0, 1)}
@.discussions.microsoft.com> wrote in message
news:860742F2-A336-4BD2-8BEF-CB9EF31A00E4@.microsoft.com...
> in the SQL Query Analyzer I can use
> select {fn UPDATELINEAGE(0x0, 1)}
> and get result set like 0x0100000001000000FF back from SQL server, no
> document describes what the syntax is for {fn UPDATELINEAGE(0x0, 1)}. Does
> any one know this?
> Thank you
> Xinmin zhou
>
>|||...and from what I could find, the number of parameters went from 2 to 3
with SP1.
That's why you should stay away from undocumented system procedures and
functions.
The function could even be dropped in the next upgrade or service pack.
"oj" <nospam_ojngo@.home.com> wrote in message
news:OnQ5tPBTFHA.544@.TK2MSFTNGP15.phx.gbl...
> There won't be. There are quite a few odbc functions that are used
> internally by MS. This one in particular is used in sp_MSaddmergetriggers.
> You probably want to stay away from undocumented functions anyway...
> --
> -oj
>
> "Syntax of {fn UPDATELINEAGE(0x0, 1)}" <Syntax of {fn UPDATELINEAGE(0x0,
> 1)} @.discussions.microsoft.com> wrote in message
> news:860742F2-A336-4BD2-8BEF-CB9EF31A00E4@.microsoft.com...
>
No comments:
Post a Comment