Interesting ! Update query with alias ?

Hi,
I have a below Oracle query :
UPDATE test1 a SET a.sno = 3
I need the equivalent SQL Server query for the above along with with alias name 'a' set for the table test1. Please advise.
Thanks,
SamI'd use:UPDATE test1 AS a
SET a.sno = 3-PatP|||I too tried the same, but I am getting the error 'Incorrect syntax near AS' in SQL Server 2000|||How about this :

UPDATE a SET a.sno = 3 FROM test1 a

This is working fine...

Integration Services won't install

I am installing Visual Studio 2005 Professional on Windows XP.

I have finished installing Visual Studio 2005 Professional along with Service Pack 1. Now I am installing the Developer version of SQL 2005 that comes with Visual Studio 2005 Professional .

During the installation of SQL Server 2005, I got the following error during
the integration services installation portion:

Failed to install and configure assemblies: c:\program files\microsoft sql
server\90\dts\tasks\microsoft.sqlserver.msmqtask.d ll in the COM+ catalog.
Error -2146233087

Error message: unknown error 0x80131501
Error description: You must have administrative credentials to perform this
task.

I'm logged into Windows as Administrator.

This machine did previously have VS 2005 Standard and SQL 2005 Standard loaded. The software was RTM software as provided by Microsoft at their launch event. I did uninstall both products before attempting the upgrade.

Any help would be much appreciated.

Hi,

Refer below links for workaround

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136467&SiteID=1

http://geekswithblogs.net/waterbaby/archive/2006/08/03/87048.aspx

HTH

Hemantgiri S. Goswami

|||

This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:

1. Open Administrative Tools\Component Services

2. Go to Component Services\Computers\My Computer\COM+ Applications

3. Delete Microsoft.SqlServer.MSMQTask