Opendatasource

I'm trying to use OPENDATASOURCE in t-sql to update data on our AS/400 from MSSQL but don't know the property value for provider_name. Please help!!!"Control Panel"\"Administrative Tools"\"Data Sources(ODBC)"
Select a tab "File DSN", click "Add..", select server and click "Advanced".
Now you see sub-driver for ODBC (MSDASQL)

For MS SQL Server in MS SQL Server
select *
from OpenRowset('MSDASQL', 'Driver={SQL Server};Server=MyServer;User=MyUser','select * from sysobjects')

I do not have A/400 driver installed, that is why I cannot test this for A/400.

Good luck !|||my diagnosis is the your transactional properties of your neural defilibrator is going to require that you just replace the AS400 with SQL Server.

you better get to work.sql

online sites

What are the good online sites for T-SQL Queries, Joins and stored
procedures?Hi
For the syntax of your statements and some examples see Books Online or the
online equivalent at
http://msdn.microsoft.com/library/d... />
n_6lyk.asp
for learning T-SQL you may want to look at subscribing to SQL Server
Magazine http://www.windowsitpro.com/SQLServer/ and SQL Server professional
http://www.pinpub.com/ME2/Audiences/Default.asp Many other sites are listed
on http://www.aspfaq.com/show.asp?id=2423
John
"intermediate" <enlight.v@.gmail.com> wrote in message
news:1136150275.405829.321770@.z14g2000cwz.googlegroups.com...
> What are the good online sites for T-SQL Queries, Joins and stored
> procedures?
>