Does anyone know of any differences between queries in SQL 7 and SQL
2000?  I have a collegue that says there could be "subtle" differences
in the output, though I cannot find any documentation of this.  Any
link to prove him wrong would be very helpful.  Thanks.

Hello, what is the similar function decode of oracle in sqlserver?
Thanks.

How can I store pictures or image in SQL Server 2000?

When I try to use Autorun I get an error message that says "A previous
program installation created pending file operations on the
installation machine. You must restart the computer before running
setup."  I have restarted the computer many times, but I have continued

I created 2 tables with one to one relationship. if I add a record in
table A, how does table B record get created? Does SQL do this
automatically because it is one to one relationship? or do I need to
create a trigger? if  i need a trigger, how do  I get the ID of new

Subject: SQL server job timeouts?
We have a job that uses WinHTTP inside a stored procedure. We have
another SP wrapper that runs this for a couple hundred records.
When we add this as a job using SQLAgent it times out half way. Running

I would like to know how to get rows with duplicate values in certain
columns. Let's say I have a table called "Songs" with the following
columns:
artist

I'm trying to create a database table whose primary key comes from the pubs
database, titles table. The column name from the titles table is title_id.
Its data type is tid. What is tid? Example: BU1032
See the pubs documentation at:

I am trying to use the READTEXT function using a dynamic table name in
T-SQL, but I can't get it to work.  If I just code the name of the table and
column into the request it works fine.  How can I dynamically request the
table and column name - I don't want to have to write a ...

I have a table of zip codes, some with Canadian zips.  I'd like to take
a zip code and search for nearby zips.  For example:
Dim theZip As Integer = textbox1.text
...Parameter.Add(@ziplow, SqlDbType.Int, 5).Value = (theZip - 10)

I have SQL Server 2000 on window Server 2003, I have a laptop client with
Win XP , I want to install MSDE 2000 on this client and keep weekly updated
with Server. Is it possible ,
If yes, How ?

   I have 2 instances of databases in 2 different cities.Data entry /
updations are going on at both the sides.At any point of time data in
both the databases should be same.Currently  every alternate day, i am
performing update / insert / deletes on incremental basis on both the

I have some C++ code which does the following
retcode = SQLFreeStmt(hStmt,SQL_UNBIND);
retcode = SQLFreeStmt(hStmt,SQL_RESET_PA­RAMS);
retcode = SQLFreeStmt(hStmt,SQL_CLOSE);

In which cirumstances we have to use uniqueidentifier column.... like any
specific conditions ?
Thanks

how to do a select ... from select in MSSQL similar to Oracle? eg.
select hour
from (
   select substring( daily, 9,2 ) as hour