hello sir
I am using MS sql7.I am using a transaction table of  
having 10 columns  A,B,C,D-char(15), E,F-varchar(30),
G,H,I-numeric(15,3),J-datetime, each.Yearly approximtelly

sorry for my poor engish :
I can't exécute à very complexe query automatiquely make
by People Soft. This Query use 6 tables with no more 80
000 rows each.

I have a table of data storing the following fields
Stock_Code (varchar 10)
Location (varchar 10)
Quantity (int)

I am getting unwanted whitespaces returned from a select
statement.
I understand my table definition has stated a "char" with
field length 10. However if my value stored is only 5

I apologize if this isn't the right place to ask this,
but I'm looking for a way to copy an SQL/Server ODBC
connection from one PC to another (actually, many
others).  I tried copying the ODBC.INI file but that

Is there a way to create a column that will show the
value of field1 unless field1 is null in which case it
will show the value of field2?  I do it all the time in
Access but can't seem to figure out if SQL Server can do

The object name 'pic_db.pubs.dbo.authors' contains more
than the maximum number of prefixes.  The maximum is 2.
when i tried selecting from a linkedserver i get this
message. help anyone?

Looking at http://www.databasejournal.com/features/mssql/article.php/3112381 the guy creates a table called Orders, then has the quer
select OrderId, OrderDate, O.OrderAm
    ,(select sum(OrderAmt) from Orders
                         where OrderID <= O.OrderID

Good day,
[SQL Server 7.0, SP4]
I have a table wich contains only one column [varchar
(1500)] filled with some texts (different length, ranging

I'm try to set an IIF statement in a query/view for a
column.  I repeatedly get an error message stating the IIf
function doesn't exist.  When I try IF, it put my function
in 'quote marks'.

How do we limit the number of sql statements that are
running at a time in order to prevent transaction log to
grow infinitely.
This is urgent!!!!

I want to drop FK constraints while I do mass delete from
tables which has several steps relationships.
And then when deletions are done I have to set back.
In the tables even after the deletion there are over 300

amount
before
82.758
960.000

Hello, I am trying to figure out how to write a query
that can update only part of a string in a given column.
Example:
Table = WebSites

I am new to SQL 2000.  We have bought the full version and
we have created some tables with large numbers of records
(20m, 60m etc...) but I wish to know more about Indexes
and all the different types within SQL 2000 and which one