I don't believe you can pass a cursor as a parameter to a stored procedure. You can, however, pass the results of each loop of the cursor to another stored...

/Begin Rant

I cannot believe I was marked wrong for selecting C.  I think anyone who answered C should be credited.

The question was "Which of...

I ran into a situation where I stumbled across the  hyphen is translated as being a valid numeric value. (converting phone to strip out any non numeric characters in an ETL...

We use a combination of methods to track our ETL jobs. We have a custom logging table that logs the start and stop of the package by Lineage Full GUID....

In my opinion, If you are returning the data to an application that you have control of the source code, the front end UI should be doing a check for...

I'm not sure about product name, but the provider string should be something like this:

DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;

sushila's solution is probably the right way to go, but since you asked about scripting, here is the syntax. 

DENY ALL ON tablename TO username

This will effectively deny all permissions on...

The data you have does not have a true duplicate. As mentioned before, there are duplicate ID's. You're unique key would be ID and First Name.

SELECT ID,FirstName,Country FROM @table...

Got me. I actually sent the article to the db team, then realized it was April 1st... then I scrolled to the bottom...

If you are concerned about NULLS for your variable, you can also do this:

SET @sql = 'SELECT TOP ' + IsNull(str(@number),'100 PERCENT') + ' * FROM table_name'

I've coded in both and honestly have noticed no benefit of one over the other. My preference is C#, but VB.NET works fine as well. Depends on the requirements of...

http://www.sqlservercentral.com/columnists/bszabo/adtsdatastore.asp

http://www.sqlservercentral.com/columnists/bszabo/restoreadtspackagefromadtsstore.asp

"Answer B is just plain wrong"

Answer B is only partially wrong. Primary Keys cannot be changed.

"There must be at least one column participating in the full-text index before it can be activated"

Just based on this sentence from BOL, answer A is not the correct answer.

I more have an issue with the answer reason than the answer. "I don't know why, but" is not an educational explanation of the answer. A better explanation would have...