Click here to Skip to main content
15,795,789 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

1.I need a query to join 2 databases
eg: 1st database contain dbo. employee table and second database contains dbo.attendance table
i would like to join these to tables and store it in a storeprocedure in 1 of the database
2.I would like to perform crud operation with the same storeprocedure
Updated 12-Jun-13 19:43pm
Ron Beyer 13-Jun-13 0:32am    
CRUD is 4 operations, all separate and distinct. Also, you can't store a database join in a stored procedure, you have to create a new database or table to store the merged data. Its difficult to answer this without more information on what you are really wanting to do.
_Amy 13-Jun-13 1:47am    
What have you tried for it? Simply "i need" doesn't explains much about your question. Click on Improve question and provide the code block which you've tried.

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900