There will be no difference.

I would advise to use the join keyword as it makes things clearer, stops you missing out a join accidentally and there are things you can...

where (name = 'Paul' and position = 'manager')

or name = 'Jim'

Not sure what you are asking

You can run the following in a query window in management studio and get the output - but will be left with the table in...

select id

from tbl

where type in ('A','B')

group by id

having count(distinct type) <> 2

This will do something like that.

It caters for any number of fields - just amend the final select for the number required

declare @s-2 varchar(8000)

select @s-2 =...

Best would be to create a new table and copy the data but you can do it by adding a new column, updating to copy the data then dropping the...

Does the SP do anything outside sql server?

Send emails, run dos commands, access other servers, create a new spid...

These could all be blocked and the cause the kill to be...

A full backup shouldn't truncate the tr log.

Get rid of the conditional drop of the temp table.

Add error handling.

Could it be that sometimes a calling batch has created a temp table with the same name which is...

What do you mean by execute?

Do you want to add them to the tables in the database - if so see my previous post.

Do you want to cause the triggers...

Try an integrity check on the table.

If that's ok then it could be that the application has the structure of the table from before you updated the column and it...

See

http://www.sqlservercentral.com/scripts/Indexing/70737/

You could probably add an xpath clause ot your query to concatenate the column names but depends on how far you want to go with this.

Do you mean you want to copy the triggers to the other database?

Right click on the database and generate scripts.

Under scripting options, advanced you can select to script triggers.

You should...

How about something like

select WeekStartDate, ID

from [Weeks]

where WeekStartDate betwen @datestart and @dateend

Are you specifying the column list on the insert? If not it might not be inserting that data into the column you expect.

Otherwise maybe there is a trigger or constraint...