I have an application that bounces two different recordsets against one
another and I would like to be able to tell the user that there were not any
duplicates or display the duplicates found.  
I have been playing around with @@rowcount but can't seem to get it to work.

I am trying to fetch system table and column related data in sql 2000. I
have used a subquery to get column constraint types by joining few system
tables. But i also need to get constraint_name and count on the constraint
types. How can i modify the existing query to get the ...

I have a table called Contact. It has rows of contact people and business in
it. One of the things I want to do is to somehow make possible the ability
for a contact to be more than one contact type without repeating the actual
contact data. What are some solutions to fix this ...

What would I use for a datatype to store timezone offsets in?

I am going to be creating a table that stores timezones in it. I have an
excel spreadsheet of the data. Is there a way I can import this into the
table?

Using SQL Server 2000 & 2005.
I am wondering how small a varchar field can be before it is worth
using a char field.
Is there any penalty using a varchar filed of 5 characters compared to

sql server 2005
select    a.Id,
           p.Thumbnail,
           p.PhotoName,

Is microsoft.public.sqlserver.integrationsvcs a managed newsgroup?
Thank you,
Max

sql server 2005 express
I'm trying to create an select where I need to test a column (datetime)
against another value. It is this value I'm having trouble calculating
This value chould be any date, but with the highest time part on that date,

First a quick clarification - I did not write the underlying code that
generates this information.. Only the scripts that update it.  I am
currenctly using a cursor but would love to get rid of it since it is very
inefficient.

I need to write an app that reads data in name/value pairs from a
socket and inserts it in to a SQL 2005.  Four or five of these values
should be converted to foreign keys prior to inserting into DB.  There
are other (old) similar apps that pass the entire name value string

I have a database that we are migrating to a SQL 2005 box.  We are
backing it up on the SQL 2000 box, and restoring it on the SQL 2005
box.  This stored procedure is somewhat complex in that it calls
several functions, returns a subset build off of temporary tables.  I

datestr='3/24/2009 11:00:52 AM'
select DATEDIFF(day,CONVERT(datetime,datestr),GETDATE())
This query gives error to convert string to date
please suggest

What data standards should a database designer know about?
Some are so general they jump out at you --
ISO-8601  temporal display formats.
ISO-3166  Country codes

Hi, I am having difficulties calling a stored procedure with parameters by
name.
Test script:
drop TABLE #foo