• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Creating Multitable and Cros... > Updating Table Data with Queries

Updating Table Data with Queries

Queries you create with the Unique Values property set to Yes to add the ANSI SQL DISTINCT modifier to the SQL statement aren’t updatable. If you set the Unique Records property, instead of the Unique Values property, to Yes, some queries are updatable because Unique Records substitutes Jet SQL’s DISTINCTROW modifier for DISTINCT.

T-SQL

T-SQL doesn’t support Jet SQL’s DISTINCTROW modifier and the rules that determine the updatability of SQL Server views and table-returning, user-defined functions differ from those of Jet. Chapter 21, “Moving from Jet Queries to Transact-SQL,” covers updatability issues with SQL Server views and functions. Recordsets returned by SQL Server stored procedures aren’t updatable.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint