The question asked to amend the value in Column1, yet options 1,2 & 3 used a field called col1, so leaving #4 as an answer - not possible ... using...

So I learnt about a new feature of the INSERT statement in SQL 2008.

Definitely use feature that when systems finally upgraded to SQL 2008.

Perhaps I should have paid closer attention...

You need the option

Must declare the scalar variable "@Dec".

When running on a Case Sensitive collation.

Once that select statement on line 2 is adjusted then it would work.

------

Robert

When MDX is considered part of mainstream t-sql language construct then fine. Otherwise it should have being labelled MDX as the topic.

------

Robert

I couldn't believe it! I have had the same situation occur during the week for one of the SQL Servers. The notifications for jobs were not being received. The event...

What are the results of using

exec msdb.dbo.sp_notify_operator @name = '<operator>'

a) in query window of SQL Server Mgt Studio

b) as the code in a job step of an SQL Agent

1....

So you can control the name of the attachment, use the @attachments parameter for xp_sendmail.

I suggest you also review the online help for the @separator parameter since you mention you...

The roll back for all transactions is documented in the BOL.

Quote

"ROLLBACK TRANSACTION without a savepoint_name or transaction_name rolls back to the beginning of the transaction. When nesting transactions, this same...

When the loop is up to @id = 6, you will have 7 pending transactions.

The commit tran will only commit the inner most of these, still leaving 6 'Begin tran'...

Thanks ALZDBA for the method.

I am going to define a new step 3 which will then change what the starting step will be for the job on its next execution,...

Thanks to Greg and Catherine for pointing out how to migrate existing DTS packages from SQL2000 to SQL2005 and keeping them as legacy format.

I had assumed that the Migration wizard...

It would appear that the ability to send scripts, one per file, when selecting multiple objects, is not in the Script Wizard of MS SQL Server Management Studio in SQL...

From within SQL-EM, highlight the list of stored procedures within the database.

After right click and choosing Tasks-->Generate SQL Scripts, the "Generate SQL Scripts" window appears.

the [General] tab will show those...

Sometimes I use a 'select * into', other times 'create table', but always followed by 'insert table'.

The reason being that whilst the 'select * into ' statement is processing the...

Given you know that the first part of the string you want to search, use the BETWEEN rather than LIKE.

This does require you to determine the lowest rank character in...