A função OPENROWSET do T-SQL pode ser muito útil quando precisamos acessar uma informação de uma outra base de dados. Apesar do usuário DBO não ter permissão de executar a stored procedure sp_addlinkedserver, é possível informar as configurações de acesso na própria função OPENROWSET.
A sintaxe da função é assim: OPENROWSET ( 'provider_name' , { 'datasource' ; 'user_id' ; 'password' | 'provider_string' } , { [ catalog. ] [ schema. ] object | 'query' } )
No exemplo abaixo, retornamos o resultado de uma consulta feita em outra base de dados MS SQL:
SELECT a.coluna1, a.coluna2 FROM OPENROWSET('SQLOLEDB','SERVIDOR';'LOGIN';'SENHA', 'SELECT coluna1, coluna2 FROM tabela') AS a
Veja mais informações sobre este recurso, no Books On Line do MS SQL:
http://msdn.microsoft.com/en-us/library/ms190312%28SQL.90%29.aspx
Obs 1: Não é possível acessar um banco de dados MS Access com esta função em um servidor compartilhado, pois os clientes não tem acesso para hospedar o arquivo MDB neste mesmo servidor. Isso poderá ser feito apenas em um servidor MS SQL dedicado.
Obs 2: Acesso a servidores externos à rede da Locaweb pode gerar sobrecarga nos servidores. Caso alguma sobrecarga proveniente deste acesso venha a prejudicar o desempenho do servidor e conseqüentemente o desempenho do site de outros clientes no mesmo servidor compartilhado, desativaremos temporariamente a base de dados e entraremos em contato.
Veja também
- Senha da base MS SQL Server
- Usuário Adicional no MS SQL Server
- Conectando-se no MS SQL Server através Asp.Net
- Função para Conexão ao MS-SQL via Php
- Conectando-se ao MS SQL Server através do Asp
You be struck by an dazzling capability faculty to write attractive content.
You’ve ìåéä a complex thesis accessible Great job https://realmoneypokeronlinebtr.com/.
Your post was both insightful and wonderfully written.
What a pronounced read Your points were incredibly persuasive play poker Texas Holdem.
This is top-notch writing You’ve earned a new follower https://onlinegamblingtit.com/.
Every paragraph was a delight to read Thank you.
Every paragraph was a delight to read Thank you online sports betting.
Your collection was both insightful and delightfully written.
Solely brilliant You have a way with words Sports Betting webSites.
I’m amazed past how much I au fait from this post.
This post is a gem So overjoyed I found it casino online real money.
You’re a eccentric writer This dispatch proves it up till again https://bikcasinogamesonline.com/.
I without exception look disrespectful to your posts This was another chef-d’oeuvre love cannabis oil near me.
This is top-notch writing You’ve earned a new follower cbdoilsiv.com/.
I’m amazed during how much I learned from this post enjoy installment loan from direct lender.
I’m blown away before your familiarity and journalism leading article style seo platform reviews.
Your non-fiction is captivating I academic so much can i order sildenafil.
I’ve just finished reading your latest blog post, and I must say, it’s outstanding! The depth of your analysis coupled with your engaging writing style made for an exceptional read. What struck me most was your ability to break down complex ideas into digestible, relatable content. Your examples and real-life applications brought the topic to life. I’ve gained a lot from your insights and am grateful for the learning. Keep up the fantastic work – your blog is a treasure trove of knowledge!
동크 벳(Donk Bet) : 눈에 띄지 않고 돈을 잃기만 하던 플레이어가 얼리 포지션에서 베팅에 나서는 것. 주로 실력이 없는 플레이어, 즉 동키(Donkey)가 많이 하는 행위.
We’re a group of volunteers and starting a new scheme in our community. Your website provided us with valuable info to work on. You have done an impressive job and our whole community will be grateful to you.
Unquestionably believe that which you said. Your favorite reason seemed to be on the web the easiest thing to be aware of. I say to you, I certainly get irked while people consider worries that they just don’t know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people could take a signal. Will likely be back to get more. Thanks
You are a very intelligent individual!
Woah! I’m really enjoying the template/theme of this site. It’s simple, yet effective. A lot of times it’s challenging to get that “perfect balance” between user friendliness and appearance. I must say you have done a very good job with this. Also, the blog loads extremely fast for me on Firefox. Outstanding Blog!
Generally I don’t read post on blogs, but I would like to say that this write-up very forced me to try and do so! Your writing style has been amazed me. Thanks, very nice article.
Wonderful work! This is the type of info that should be shared around the internet. Shame on the search engines for not positioning this post higher! Come on over and visit my site . Thanks =)
Hi! This is kind of off topic but I need some help from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty quick. I’m thinking about creating my own but I’m not sure where to begin. Do you have any points or suggestions? With thanks
Keep working ,fantastic job!
Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something. I think that you could do with some pics to drive the message home a bit, but other than that, this is magnificent blog. A great read. I will definitely be back.
was such a great read!
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik
I am not sure where you’re getting your info, but great topic. I needs to spend some time learning more or understanding more. Thanks for magnificent information I was looking for this info for my mission.
I have read some just right stuff here. Definitely value bookmarking for revisiting. I surprise how much effort you place to create such a wonderful informative website.
what a great read!
You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog.betflik
There are actually a lot of details like that to take into consideration. That could be a nice level to bring up. I offer the thoughts above as general inspiration however clearly there are questions like the one you carry up where crucial factor will likely be working in sincere good faith. I don?t know if greatest practices have emerged round issues like that, but I’m certain that your job is clearly recognized as a fair game. Each boys and girls really feel the impact of only a moment’s pleasure, for the remainder of their lives.
thank you
You could certainly see your skills in the work you write. The world hopes for more passionate writers like you who aren’t afraid to say how they believe. Always go after your heart.