Viewing 15 posts - 1 through 15 (of 22 total)
Most often this error crops up when you are referencing a variable and you do not prefix it with the "@". Cursors are "variables" whose naming convention does NOT call...
November 15, 2006 at 9:03 am
Lots of very helpful advice here which, unfortunately, answered the wrong question.
The question is how to duplicate complex functionality that is in a "legacy" application.
The "legacy" application is Excel's...
October 20, 2006 at 9:38 am
I fail to understand why a primary key is ever a "workaround"!
October 6, 2006 at 9:12 am
The assertion that Oracle is cheaper works for a "green field" enterprise where there is no pre-existing investment in the MS architecture at both the server and the user levels....
October 6, 2006 at 7:20 am
Agree re closing paren. Looks like something replaced it with a smiley face emoticon! Pretty dumb "feature" in a technically oriented forum
September 28, 2006 at 10:41 am
Billsalkin:
I certainly not excuse that atrocious, delicious pun! Ciddify, indeed!
That one goes into my collection.
September 25, 2006 at 9:47 am
More specifically, you need to make the field for the submitter id into a Dropdown List (ddl) instead of a textbox. You bind the target table's (the one you are...
September 5, 2006 at 9:40 am
Try this:
SET
NOCOUNT ON
DROP
table Questions
go
CREATE
Table Questions
(
qnId
September 2, 2006 at 10:39 am
All of the above assumes that you have no related tables with foreign keys referencing one or more of the duplicates.
If everything in a row is duplicated in one or more...
September 1, 2006 at 9:57 am
Your requirement is not very clear. Given what I can guess about it, looks like you want to use dynamic SQL and the EXEC command.
Here is an example:
SET
September 1, 2006 at 9:41 am
Excellent article, easy read.
I am not a dot NET developer, but am trying mightily to come up to speed on it. I have been involved in relational databases since...
August 20, 2006 at 8:06 am
I had a project with a similar requirement. We used replication to reference the common database into each of the client databases. Then FK constraints could be set up in...
August 4, 2006 at 1:56 pm
This requirement seems to be a self-fulfilling prophecy.
(1) Users usually want a progress bar because the query in question has a history/experience of being long-running.
(2) Original design may have used...
July 7, 2006 at 9:41 am
Perhaps this is obvious to most, but I noted Gino is a newbie and might not appreciate that @@error is very transient, in that its value does not persist beyond...
July 5, 2006 at 11:43 am
I haven't examined the SQL 2005 PIVOT operator. However, the approach herein should work in 2000 and 2005. Everything is in a single, rolled back transaction so as not to cause...
June 22, 2006 at 1:25 pm
Viewing 15 posts - 1 through 15 (of 22 total)