Hi All: I'm trying to build a sproc with the following logic:
I have a table of registered shoppers with unique email addresses, and a
contest form where they enter their email address to enter the contest. Only
registered shoppers can enter, but I don't know if they're registered ...

Hi: I have a sql2005 table of email addresses with a uniqueidentifier for
each email address. I need to check if the uniqueidentifier exists and
update the row if it does, and return the email address. Can/Should that be
done in a single EXISTS statement in a stored procedure?  ...

In query analyzer when I performed a results to text query, within the
results pane on the status line on the bottom, the line number and character
position of the cursor placement was presented when going thru the results.
Is that available in SSMS for 2008 and if so, how do I ...

I was wondering if anyone here can tip me about the most efficient way
of indexing massive data that is stored in SQL 2005. We have about 60
million rows and growing at about 1 million records every month. I
want to write a web app to return the results based on customer

Can you SELECT from a user-defined function with BCP?  If so, what is
wrong with the following statement?
bcp "SELECT * FROM LpsPrime.dbo.GetActiveStatic(205, 166, 1)" queryout
bcptest.txt -T -c

I know that SP3a for SQL2K is no longer supported, but I still have
occasional use for it (during intermediate steps of application
upgrades).  Microsoft has taken down their download page, and everywhere
else on the web seemed to just have links to Microsoft's page.  Does

I'm using SQL Express 2005. Can you someone give me few pointers on how to
* Force the ERRORLOG to rotate at a certain file size?
or
* Cause new entries to write the old at a certain file size?

Dear Sir,
In my Visual Basic 6 application I am using Access 2000 with ADO 2.5.
To Insert & Update Record I Generate parameter Query  in application.
PARAMETERS p_AccountCode TEXT(6), p_AccountName TEXT(40);

I have been trying since Christmas to post a question on this group. I use
Vista's version of Outlook Express, for this and other groups, and have
never had problems posting elsewhere. The message appears briefly in the "To
Be Sent" folder, then vanishes and appears in the "Sent ...

I have a table that I have created that holds the SQL code I need for
30-40 queries to run daily.  
I have managed to get my SQL to the point of retrieving the information
but I would would like to take that information just a count and

I've just installed SQL server 2008 having been used to 2000 and am
experiencing problems using the import wizard for the first time.
I have created a DB on my local machine and at the choose destination
step I receive the error below.

I've run into a system, where string inputs from asp to mssql is filtered
through a function, which removes quotes ' and pipes |
I understand that ' is "dangerous" when sql-queries are built in asp:
sql = "update tab set fld='" & value &"' where key = "' & key &"'"

Hello, I'm  trying to improve some SQL commands my company is using.
-- taken from another post so it may look familiar
CREATE TABLE samples
(

After CREATE VIEW intellisense will not recognize the VIEW until SSMS
is closed and reopened.   Shouldn't F5 refresh or at least
Disconnect/Connect  Object Explorer work?

I'm trying to install SQL Server 2005 Std Ed. on a Windows SBS 2008 but in
the features selections I only have the client tools for install... This
never happened before. Can someone help me?
Just to be sure, i've installed a w2k3 VM and tried to install the sql