SELECT * INTO OPENDATASOURCE

[jojoba2011]

<pre lang="sql">SELECT *
INTO OPENDATASOURCE('SQLNCLI',
'Data Source=.\sqlexpress;User ID=sa;Password=sa')
.[fuzzyTest].dbo.tblGroup
FROM [CMS].[Common].[File];</pre>

This is not working and giving error !

I dont wanna to use

<pre lang="sql">INSERT INTO [CMS].[Common].[File]
(Name,IdParent,[Desc])
SELECT [Name],[IdOstan]+30,''
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=.\sqlexpress;User ID=sa;Password=sa'
).[fuzzyTest].dbo.tblGroup</pre>

[Lost User]

jojoba2011 wrote:

This is not working and giving error !

What error? Syntax error?

jojoba2011 wrote:

I dont wanna to use

Why? What's wrong with that?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]