October 5, 2009 at 10:39 pm
Hi Friends,
What is difference between OPENROWSET & OPENDATASOURCE.
To use OPENROWSET & OPENDATASOURCE, what parameters should enable.
Give an example for OPENROWSET & OPENDATASOURCE using query.
How to transfer bulk data to different table in a database from external file using query.
October 5, 2009 at 10:58 pm
Are these interview questions, homework questions, or test questions?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 7, 2009 at 5:20 am
October 7, 2009 at 5:29 am
nigel. (10/7/2009)
Click here
LoL 🙂 :hehe::-D
October 7, 2009 at 8:43 am
nigel. (10/7/2009)
Click here
Heh... I always get a kick out of lmgtfy.com. It's more fun than "Please visit BOL."
--Jeff Moden
Change is inevitable... Change for the better is not.
October 7, 2009 at 4:25 pm
What an answer!!!!!!!!!!!!!!
Fabulous!!
Manu
October 7, 2009 at 9:27 pm
Like your response Nigel. What a way to tell the person to initiate and try to learn yourself. 😛
October 8, 2009 at 1:55 am
Don't think I was too harsh do you? I know he's only a newbie but there is a limit!!
Obviously homework or something,as Jeff alluded to earlier. His question clearly shows he hasn't even tried.
October 8, 2009 at 1:59 am
What about this?
I might add this to the links in my sig just for these sort of occassions. 🙂
October 8, 2009 at 2:38 am
October 8, 2009 at 7:22 am
I don't think that you are being too harsh. 🙂
Some people want to learn how to do things themselves and just need to be pointed in the right direction. The rest think they are too busy (or too important) to dig in and understand a subject and expect someone to do it for them.
Goes with the old saying "Give a man a fish and you have fed him for today. Teach a man HOW to fish and he can feed himself for the rest of his life."
BTW, I have never seen TMGTFY.com before. This is GREAT! :w00t: I will use this for a lot of things in the future!
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
October 8, 2009 at 7:42 am
RandMan-585256 (10/8/2009)
I don't think that you are being too harsh. 🙂Some people want to learn how to do things themselves and just need to be pointed in the right direction. The rest think they are too busy (or too important) to dig in and understand a subject and expect someone to do it for them.
Goes with the old saying "Give a man a fish and you have fed him for today. Teach a man HOW to fish and he can feed himself for the rest of his life."
BTW, I have never seen TMGTFY.com before. This is GREAT! :w00t: I will use this for a lot of things in the future!
Cheers RandMan,
By the way it's lmgtfy.com (a slip of your fingers I guess). I found someone else quoting it in this forum some time back.
October 8, 2009 at 7:44 am
Yeah - fat fingers . . . . . . you ought to see me code!:w00t:
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
October 8, 2009 at 9:06 am
To sum up, openrowset() allows you to create an ad-hoc connection to oledb
provider and execute a query.
e.g.
select * from openrowset('conn','query')
Opendatasource() also allows you to create an ad-hoc connection but it allows
you to reference the provider in a 4-part-name.
e.g.
select * from opendatasource('conn').db.owner.obj
October 26, 2009 at 3:41 pm
jmichaud (10/8/2009)
To sum up, openrowset() allows you to create an ad-hoc connection to oledbprovider and execute a query.
e.g.
select * from openrowset('conn','query')
Opendatasource() also allows you to create an ad-hoc connection but it allows
you to reference the provider in a 4-part-name.
e.g.
select * from opendatasource('conn').db.owner.obj
But you can also reference a provider object using OpenRowSet...
SELECT a.*
FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',
'SELECT GroupName, Name, DepartmentID
FROM AdventureWorks.HumanResources.Department
ORDER BY GroupName, Name') AS a;
no?
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply