Dominic85 Posted March 30, 2006 Share Posted March 30, 2006 i'm doing a project now and i'm stack with this problem..can anyone tell mi how to link the 2 database together? use wad command to do it? i'm using microsoft SQL server 2005.. Link to comment Share on other sites More sharing options...
aspnetguy Posted March 30, 2006 Share Posted March 30, 2006 Do you mean link 2 tables together? Everything for a project should be stored in 1 database.When linking 2 tables they have to each have a column that is the sameieitems---------------item_ID int PKName varchar Desc Varcharcustomers---------------cust_ID int pkitem_ID int FKAddress varcharYou can link the 2 tables like this SELECT * FROM items i, customers cWHERE i.item_ID = c.item_ID This will select everything from both tables. Link to comment Share on other sites More sharing options...
Dominic85 Posted April 3, 2006 Author Share Posted April 3, 2006 Do you mean link 2 tables together? Everything for a project should be stored in 1 database.When linking 2 tables they have to each have a column that is the sameieitems---------------item_ID int PKName varchar Desc Varcharcustomers---------------cust_ID int pkitem_ID int FKAddress varcharYou can link the 2 tables like thisSELECT * FROM items i, customers cWHERE i.item_ID = c.item_ID This will select everything from both tables. <{POST_SNAPBACK}> I want to link 2 database together, that is database 1 OMIM and database 2 Human and i want to search the key words from this 2 database... but i can't find it in the book.. can someone help mi out? is urgent.. thx a million.. Link to comment Share on other sites More sharing options...
aspnetguy Posted April 3, 2006 Share Posted April 3, 2006 You cannot link 2 databases. You can store both sets of data in different tables within 1 database.If you make 2 databases you are going to run into to problems trying to maintain it and it will be a nightmare making simple join queries. Link to comment Share on other sites More sharing options...
Dominic85 Posted April 4, 2006 Author Share Posted April 4, 2006 I have put this into one database.. how to search the keywords from the tables? i mean every tables.. wad is the code? can someone help mi out? is urgent.. thx a million.. Link to comment Share on other sites More sharing options...
vijay Posted April 4, 2006 Share Posted April 4, 2006 HiGet help with coomand sp_addlinkedserver in Sql ServerVijay Link to comment Share on other sites More sharing options...
Dominic85 Posted April 4, 2006 Author Share Posted April 4, 2006 HiGet help with coomand sp_addlinkedserver in Sql ServerVijay<{POST_SNAPBACK}> can u help mi with the code? Link to comment Share on other sites More sharing options...
Dominic85 Posted April 6, 2006 Author Share Posted April 6, 2006 can someone pls help mi? Link to comment Share on other sites More sharing options...
Dominic85 Posted April 6, 2006 Author Share Posted April 6, 2006 HiGet help with coomand sp_addlinkedserver in Sql ServerVijay<{POST_SNAPBACK}> is there any books i can refer to? pls help mi.. Link to comment Share on other sites More sharing options...
aspnetguy Posted April 6, 2006 Share Posted April 6, 2006 do a google search for SQL Server sp_addlinkedserverYou will get lots of help with this function Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now