|
Posted by Rafal Bielecki on 05/22/07 11:42
Uzytkownik "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> napisal w
wiadomosci news:JOz4i.22889$JZ3.9830@newssvr13.news.prodigy.net...
> A UNION ALL query will combine multiple result sets:
>
> SELECT *
> FROM dbo.transaction_0701
> UNION ALL
> SELECT *
> FROM dbo.transaction_0702
> UNION ALL
> SELECT *
> FROM dbo.transaction_0703
> UNION ALL
> SELECT *
> FROM dbo.transaction_0704
>
> You can specify an explicit column list (a Best Practice) and encapsulate
> the query in a view to facilitate reuse. You might also consider creating
> a partitioned view (or a partitioned table if you are running SQL 2005
> Enterprise Edition). See the Books Online for more information.
thank you Dan, your help is very important to me
Rafal
Navigation:
[Reply to this message]
|