Interview Question in Sql Server 2000


 

Interview Question :: Im using sqlserver2000,ive 2 database v1 amp; v2,table on each databse,iwant to retrive datafrom both using asp

i'm creating stored procedure in sql server 2000 that take data/row from two databses and display output ,i'm using asp script to display output.
i've 2databse namely vishal& vishal1,each databse there is 1 table ,iwant to take 1 row from vishal & 1 row from vishal1 & disply it using asp.
by ksk