Does ANSI SQL support conditional selects ?
I have a table with say 15 fields
tblTale1
ID

I have a C# application that creates a SqlConnection object with an ADO
connection string and then sets up a SQlTransaction object for that
connection.  Several records are posted to different tables in the
database within this transaction.  All these tables uses an identity

Im using an ADP to connect to a SQL Sqever DB.
In access it was really easy to say
Inner join on table1 and table2 and update columnA from table1  with
columnC from table2 where table1.key = table2.key and table2 columnB =

I know very little...
I am running Windows XP on a 2 way box as a workstation. I deal with
extremely large databases 10-50 gb on a server running sql server. I am
running MSDE and so can not locally run these databases.

I have an sql query that has specific criteria (like state='PA' or
state = 'NJ'...) and would like to be able to have the user specify
the criteria dynamically either through the web or from MSAccess or
another tool.

Can I use osql to known the database install on a server via 'guest'
account ?
I had over 300 servers with sql server all around France (different
version : 6.5, 7 and 8)

How can I display filed name as a column, can any body help...
There is one table name School and it contain 4 records and in the future
might be it will increase but I want to display that records as a column
like this

I did a SELECT INTO statement to copy a table. If I then edit the newly
created table, can I then rename the original table to something else and
rename the copied table to the name of the original table without problem?
Is there some kind of GUID or something like that attached ...

Is it possible to retrieve all tables that a given one is related to
via foreign keys?

I am trying to connect to different machine (SQL SERVER that is
172.131.31.211) but giving me the following error.
---------------------------
SQL Server Enterprise Manager

I have a scanario like I want to push the data from SQL Server to dBase and
dBase to SQL Server but the problem is that dBase database is on the
different machine so can any body tell me before making the DTS Package what
inforamtion I need ?

I am trying to upgrade SQL Server 2000 SP3a to SP4, running on Windows XP
Professional SP2, i am running into this error message below:
Error running script replcom.sql (1)
Please can someone help me, i logged onto the computer as Administrator.

Am using SQL Server2000 on WINXP.  Have been using this DB since it became
available.  Today, all of a suddent, the Service was not 'started,' even tho
I had it marked as 'automatic.'  Tried to manually start the service, and
received the message that some service start and stop ...

Newbie here. I have a mailing list program that I really like. I also have a
new membership program. The membership program has mailing list signups
built-in, but it isn't nearly as robust as the stand-alone mail program.
If someone signs up for a newsletter when they register ...

Within an INSERT statement where the VALUES are expressed, is it
possible to evaluate one or more of the values with CASE or IF
statements?
Consider the following code;