Easy Question!

Easy Question!

Post by Nish » Sat, 06 Mar 1999 04:00:00

Hi people. This should be easy to most of you but I'm very new to all this.
The question is :

Qn : How do I sort my data when I create a view in SQL 7.0?

a) I have tried using ORDER BY but SQL says I need to use it together with

Thanks in advance.


1. Give this newbe easy answers on easy questions!

Hi Reppies.

These questions are bothering me:

1. I use replication for fault tolerant purposes. When the primary
(sending) server fails. Is it allowed to switch clients to the
subscribing server and let them alter the data ?

2. It seems like the command 'truncate table' is not allowed when the
table is published to another server. Is 'delete from' the only
alternative to accomplish a full delete ?

3. For existing data to be published, do I first have to transfer/copy
the database to another server before I switch on replication for it ?
In other words: initial replication does not synchronise the database
in a way that the destination database is being synced so that it is
an exact copy of the publishing database ?

4. Only data in published tables is replicated, not the permissions
and database properties, right ?
So, every option (i.e. select bulk into or truncate on checkpoint) for
the publishing database must be manually set on the destination
database, right again ?

Thanks for you time and happy sync'ing
Ray Arts

The Netherlands.

2. CDML - SetCookie - Set to [FMP-Link]

3. easy question

4. XML API Standards, do they exist?

5. DTS Easy Question

6. Raising Events from SQL Server - Event Handling from .NET

7. 1 very hard and 1 very Easy question

8. Migration, Informix to SQL 7.0

9. This should be an easy question regarding Triggers

10. Easy question on sql profiler

11. Easy question

12. SQL Server on a LAN (easy question)

13. Easy Question - Copying images into a database