When I submit a sql :
select * from view from column=''
the view is pointing to oracle table with ole db provider for oracle
In mssql2000, the result return rows which containing a space ' '

Table2 has multiple records joined to single record in Table1. I want to
UPDATE column in Table1 only if all joined records in Table2 are True.
Help would much apprec.

Hello everyone,
I'm on MS  SQL SERVER 2000.
When runing this simple delete statement:  
delete from sd50.cdm_locations where loc_oid =146836832983830528

I would like to write a select statement in query analyzer which would return
the last order number per customer given a specific order type.  (Which would
be 1 record per customer)  Thanks.

I have this transaction:
 BEGIN TRANSACTION
    INSERT INTO logs (message) VALUES ('SQL will inserts a new register')  
    INSERT INTO products (id, name) VALUES (1, 'book')