Re: Comparing two "identical" tables

From: J O Holloway (respond.to.group_at_your.convenience)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 13:02:44 -0500

Yep, text, ntext, and image. Good point. I don't know what sort of fields
Scott's database has.

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:esvLGTJVEHA.808@tk2msftngp13.phx.gbl...
> > from (
> > select *
> > from authors
> > union
> > select *
> > from authors2
> > ) as x
>
> I thought that if a TEXT column is involved, you would get an error about
> using DISTINCT when you try to UNION as opposed to UNION ALL.
>
>

Relevant Pages

  • Re: Establishing Precedence In ORDERBY Condition Causing Problems.
    ... tab4.login_date from (select distinct emailAddress from Users union ... I created the UserPrecedence table that describes the ordered ... ORDER BY CASE @sort ... The sp_ prefix is reserved for system procedures, and SQL Server first ...
    (comp.databases.ms-sqlserver)
  • Re: Increase field size
    ... UNION, GROUP, SORT, etc but I would want to limit the length, restrict ... the contents (allow Unicode and you will get Unicode ), ... Ah yes, table-level CHECK constraints, the DECIMAL data type (including ...
    (microsoft.public.access.formscoding)
  • RE: Query sort not working after NULL column
    ... There is no sorting in any of the queries except the last one. ... that and sort when the query is run from VB. ... UNION ALL but I'm sure that will complicate things even more and lead me to ... have to insert even another extra query to get rid of the duplicates. ...
    (microsoft.public.access.queries)
  • How to use UNION ALL and SORT BY
    ... I have an asp site where I sell some products. ... UNION ALL ... I'd like to sort the results by "productid", ... following error message from my editor: ...
    (comp.databases.ms-access)
  • Re: Sorting problem
    ... It works but its sorting data like this: ... You add an order by clause to the last query, using the field names in the ... So if you want to sort by Data, ... UNION ALL ...
    (microsoft.public.access.queries)