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 |
|
AAAV
Posting Yak Master
152 Posts |
 Posted - 2010-04-05 : 14:38:39
|
| SELECT customer.customerId, customer.namestyle, customer.title, customer.firstname,customer.LastName, c.SYS_CHANGE_VERSION, c.SYS_CHANGE_CONTEXTFROM SalesLt.dbo.Customer CROSS APPLY CHANGETABLE (VERSION Customer, (CustomerID), (e.CustomerID)) AS c; |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-06 : 00:02:53
|
is CHANGETABLE a UDF?. If yes, you should use it asSELECT customer.customerId, customer.namestyle, customer.title, customer.firstname,customer.LastName,c.SYS_CHANGE_VERSION, c.SYS_CHANGE_CONTEXTFROM SalesLt.dbo.Customer CROSS APPLY yourschemanamehere.CHANGETABLE([VERSION Customer], CustomerID, e.CustomerID) AS c; ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-04-06 : 10:20:39
|
quote:
Originally posted by visakh16
is CHANGETABLE a UDF?. If yes, you should use it as
No CHANGETABLE is a built in function to use with Change Tracking (the little brother to Change Data Capture). To the OP, sorry I have not used change tracking so I can't say. I assume you've set up change tracking and such? |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-04-06 : 10:23:40
|
quote:
Originally posted by AAAV
SELECT customer.customerId, customer.namestyle, customer.title, customer.firstname,customer.LastName, c.SYS_CHANGE_VERSION, c.SYS_CHANGE_CONTEXTFROM SalesLt.dbo.Customer CROSS APPLY CHANGETABLE (VERSION Customer, (CustomerID), (Customer.CustomerID)) AS c;
Does that fix it? If not what error message are you getting? |
|
|
|
|
|
|
|
|
what is wrong with this Changetable