also, don't you have to exclude NULLS from the underlying emails if you are using NOT IN:

INSERT INTO contacts (email, business)

SELECT email, business

FROM scrapes

WHERE (dbo.vaValidEmail(email) = 1)

AND (NOT email...

GilaMonster (10/12/2010)

---

It's more general than that. It's just about every statement.

SELECT * FROM master.sys.objects -- 74 rows

IF (1=1)

SELECT @@ROWCOUNT AS RowsAffected -- 0, because the IF did not affect...

not enough info to help so far I think, naresh;

does your MatchingOff table have 7 columns, or one column with all the values comma delimited?

you can use a CASE statement...

every insert/update/select/set/delete statement resets the @@rowcount to the rows affected by the executed statement, so it's a best practice to use a variable to capture the rowcount you need,:

begin

declare...

depends on what you want to do with it; the full text engine has the option to open and index the contents of word and pdf documents for example; if...

the easiest way would be to use the Import/Export from SSMS; before you can do that, you need to have the ability to connect from the SQL server to the...

you are missing one closing parenthesis just before that END that raises the error.:

SET @Per = ABS((1.0 * (1-@RN)/(@rows -1)*100)) --<--missing last closing parenthesis...you

also, in the...

no, but a procedure can.

a function is not allowed to do DML operations...UPDATE/DELETE...only select, or calculations based on the select.

a procedure is allowed to update data, and of course an...

here's a skeleton to help you visualize.

I'm assuming:

1. a tracking table in the MASTER database...not the Vendors database.

2. a snippet to initialize the data...you have...

i would go with GSquared suggestion of creating a log table, insert how many rows are in the table right now,a nd then have a job compare the current rowcount...

i see what you were refering to...if you run sp_rev_login with no parameters, every login EXCEPT sa is scripted.

if you pass a specific login name, it gets scripted if it...

???

EXEC sp_help_revlogin 'sa'

/* sp_help_revlogin script

** Generated Oct 11 2010 12:10PM on DBSQL2K5 */

-- Login: sa

CREATE LOGIN [sa] WITH PASSWORD = 0x01004086CEB61FB1FE6C34DEC914CC131938263D12A9FA0B2EF7 HASHED, SID = 0x01, CHECK_POLICY = ON, CHECK_EXPIRATION...

ahh good job Cory! that's a good to know feature.

i noticed any changes there affect newly created tabs only...but that's not an issue.

very nice.

yeah i don't think the display aspects of the tabs are exposed;

I see what you are saying, there's filename, server info, login info and spid all in the tab;

it...

sp_help_revlogin is a script provided by microsoft which scripts out logins and their passwords as...