Click here to Skip to main content
       

Database

 
Questioncolumn length select query Pinmemberplayout18-Mar-07 20:31 
AnswerRe: column length select query PinmemberZiyad Mohammad18-Mar-07 20:47 
GeneralRe: column length select query Pinmemberplayout18-Mar-07 21:53 
Questioninstalled in server and run from client Pinmemberhamid_m17-Mar-07 23:21 
AnswerRe: installed in server and run from client PinmvpColin Angus Mackay18-Mar-07 3:38 
Questionupdating table of one database with data from another database? Pinmember111917-Mar-07 19:55 
AnswerRe: updating table of one database with data from another database? Pinmembermghiassi18-Mar-07 9:56 
AnswerRe: updating table of one database with data from another database? PinmemberZiyad Mohammad18-Mar-07 20:50 
Here we go!!
 
Use joins (normal, left or right) between tables across the databases. You can call different databases in TSQL with dot operators (..).
 
Eg:-
 
Select n.name from northwind..authors n, pubs..aurhors p
where p.authorid = n.authorid

 

AnswerRe: updating table of one database with data from another database? PinmemberPete O'Hanlon18-Mar-07 23:58 
Questionhow to use trigger in sql server 2005 ? Pinmemberhdv21217-Mar-07 7:26 
AnswerRe: how to use trigger in sql server 2005 ? PinmemberPete O'Hanlon18-Mar-07 23:54 
QuestionHow can I Inserting to a table Pinmembermghiassi17-Mar-07 6:41 
AnswerRe: How can I Inserting to a table PinmvpColin Angus Mackay18-Mar-07 3:35 
GeneralRe: How can I Inserting to a table Pinmembermghiassi18-Mar-07 9:35 
GeneralRe: How can I Inserting to a table PinmvpColin Angus Mackay18-Mar-07 11:58 
Questiona problem with sql server 2005 in window vista ! Pinmembermrkeivan17-Mar-07 2:58 
QuestionExporting data from sqlserver to Excel PinmemberTech_spidy17-Mar-07 2:11 
AnswerRe: Exporting data from sqlserver to Excel Pinmemberkubben17-Mar-07 2:20 
GeneralRe: Exporting data from sqlserver to Excel PinmemberTech_spidy17-Mar-07 3:50 
QuestionCan i Copy paste sql table Pinmembernikhil123417-Mar-07 0:21 
AnswerRe: Can i Copy paste sql table Pinmembermghiassi17-Mar-07 7:00 
GeneralRe: Can i Copy paste sql table PinmemberZiyad Mohammad18-Mar-07 20:52 
GeneralRe: Can i Copy paste sql table Pinmembermghiassi19-Mar-07 8:30 
Questionstored procedure vs sql query Pinmemberghumman6316-Mar-07 16:07 
AnswerRe: stored procedure vs sql query Pinmemberkubben16-Mar-07 16:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140916.1 | Last Updated 15 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid