sumansuman
Replies to this thread:
More by sumansuman
What people are reading
Subscribers
Please log in to subscribe to sumansuman's postings.
:: Subscribe
|
Tips for SQL Server 2000/2005 - III
|
[VIEWED 1807
TIMES]
|
SAVE! for ease of future access.
|
|
|
|
sumansuman
Please log in to subscribe to sumansuman's postings.
Posted on 05-15-08 11:22
AM
Reply
[Subscribe]
|
Login in to Rate this Post:
0 
? 
|
| |
Part III
If you need to join the result set with another table here is the step
..................................................................................................................
exec sp_serveroption 'IRVN78', 'data access', true
--Example:
use CCL36
go
create table #test1( i int )
insert #test1 values (1)
insert #test1 values (2)
go
create proc sp_test
as
SELECT 2 AS id
go
select *
from #test1 t1 join openquery([IRVN78], '{call CCL36..sp_test}') t2
on t1.i = t2.id
To be continue........
|
| |
|
|
|
|
rawbee
Please log in to subscribe to rawbee's postings.
Posted on 05-15-08 11:32
AM
Reply
[Subscribe]
|
| Login in to Rate this Post:
0
?
|
| |
hey suman can we start a single thred on SQL instead of Part n Part. and if you use adventureWorks database then it will help to run a query
thanks
|
| |
Please Log in! to be able to reply! If you don't have a login, please register here.
YOU CAN ALSO
IN ORDER TO POST!
Within last 7 days
| Recommended Popular Threads |
Controvertial Threads |
| I hope all the fake Nepali refugee get deported |
| Travel Document for TPS (approved) |
| All the Qatar ailines from Nepal canceled to USA |
| MAGA and all how do you feel about Trumps cabinet pick? |
| Those who are in TPS, what’s your backup plan? |
| MAGA मार्का कुरा पढेर दिमाग नखपाउनुस ! |
|
|
NOTE: The opinions
here represent the opinions of the individual posters, and not of Sajha.com.
It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address
if you want any posting to be considered for deletion. Your request will be
handled on a one to one basis. Sajha.com is a service please don't abuse it.
- Thanks.
|
