You can only use = to assign values to variables. If you need to filter on >=0, you need to put that logic in the body of your stored procedure.

You likely were connected to master when you ran the script. The adventureworks database failed to create, and I'm guessing the script has a "USE adventureworks" statement that would have...

Great reply, Jacob. I need to start referencing the documentation in my answers.

select statements are not technically a transaction, since it is not modifying any data. They can still cause locking/blocks though. sp_who2 will show you all running processes, including selects.

I do however see a pointless predicate in your where clause. What is the point of ti.ItemCode LIKE '%'? That will cause a scan to determine...well it can be anything...

When I first started using spatial indexes, I found this article very helpful. It does a pretty good job at explaining some spatial indexing concepts and how to tune spatial...

Yeah, scenario 2 examples are the same as scenario 1.

select id,right(webpage,charindex('/',reverse(webpage))-1) from page

If you just want to replace /user/ do

select id, replace(webpage,'/user/','') from page

Do you always just want to replace /user/ or do you always just want everything after the final /

This would work provided there are always 2 and only 2 names separated by a single space:

select

substring(fullname,charindex(' ',fullname) + 1,len(fullname) - charindex(' ',fullname)) + ', ' + left(fullname,charindex(' ',fullname)-1)

from...

Personally, I would use BCP. It performs well for large amounts of data.

No problem, Judging by your original post, you knew what was happening, just not where.

Yes, there it is. Either use a create table statement and make that column numeric, or select a number into it instead of a space. Personally, I would use a...

when you create ##UpdateTest are you explicitly defining the temp table or doing a select into?