Can I set the Default Value of FieldA to the current value of FieldB?
In this case FieldB is an auto-incrementing number field.

I'm having this error when I restore a backup on a Windows 2008 64-bit
machine that has MsSqlserver 2005 installed on it.
"This cache contains no result sets, or the current result set contains no
rows"

I have provided a Sample flat file structure which I am trying to automate
using Bulk Insert.
Col1|Col2|Col3
a|b|c

Why am I getting the "Implicit conversion from data type sql_variant to int
is not allowed" error in development environment, but not when executed from
the SSMS query window.
Here are some facts about the stored procedure

Something very strange is happening in my database. I recently added two
columns to a table. About once a day, one random row in this table gets a
random value added for both of the two new columns. The columns are ints.
Here are som examples on the values that are added:

I found this function that accepts any string and returns only the numbers
within the string. It works fine for my needs except it returns a 0 when no
number exists within the string. I need to modify it so it returns NULL if
no numbers are found within the string. It would be ...

I have some queries that return result sets. Where would be the best place
to put them? Stored procs or user defined functions? How do you determine
what one of those to use (is there any guidelines for this?).

I have the following table:
create table [News].[NewsArticles] (
ID int identity(1,1) NOT NULL,
NewsArticle xml(NewsArticle) NOT NULL,

Good afternoon,
I am attempting to carry over the below function which works in access to be
used in visual studio, would someone be so kind as to offer a translation of
sorts? This was used in a criteia line in access, and established the year we

I'm facing a low performance issue in a new development probably someone had
facing before. There is many way to perform the reverse geocoding process (to
know the street address based on a Latitude Longitude Point). the easiest way
is to use the Haversine algorithm to measure ...

I've got a table full of records that have a column for data that I want to
write out to a text file.
the data in the field has CR/LF characters on the end.
I want to write sets of this data out to a file and I don't want bcp to put

I am drawing a blank here.  I have a table that I need to delete a bunch of records in, then repopulate the list with new data as part of a stored proc.  This is going to run several times a day and the table contains an identity field.  I know if you delete from a table, then ...

If I run the following SQL:
CREATE TABLE [dbo].[tblOdds]([Col1] [int] NOT NULL) ON [PRIMARY]
INSERT INTO [tblOdds] ([Col1]) VALUES (1)
INSERT INTO [tblOdds] ([Col1]) VALUES (3)

I have a table and 2 transactions. One of the transactions selects a few
times from the table and then tries to udate the table. The other transaction
works with other tables and then tries to update the table. The updates run
concurrently (guessing from the server trace log). ...

Using SQL 2000
Here is the DDL and some sample data
USE TempDb
Go