Click here to Skip to main content
   

Database

 
Questioncolumn length select query Pinmemberplayout18-Mar-07 21:31 
AnswerRe: column length select query PinmemberZiyad Mohammad18-Mar-07 21:47 
GeneralRe: column length select query Pinmemberplayout18-Mar-07 22:53 
Questioninstalled in server and run from client Pinmemberhamid_m18-Mar-07 0:21 
AnswerRe: installed in server and run from client PinmvpColin Angus Mackay18-Mar-07 4:38 
Questionupdating table of one database with data from another database? Pinmember111917-Mar-07 20:55 
AnswerRe: updating table of one database with data from another database? Pinmembermghiassi18-Mar-07 10:56 
AnswerRe: updating table of one database with data from another database? PinmemberZiyad Mohammad18-Mar-07 21: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'Hanlon19-Mar-07 0:58 
Questionhow to use trigger in sql server 2005 ? Pinmemberhdv21217-Mar-07 8:26 
AnswerRe: how to use trigger in sql server 2005 ? PinmemberPete O'Hanlon19-Mar-07 0:54 
QuestionHow can I Inserting to a table Pinmembermghiassi17-Mar-07 7:41 
AnswerRe: How can I Inserting to a table PinmvpColin Angus Mackay18-Mar-07 4:35 
GeneralRe: How can I Inserting to a table Pinmembermghiassi18-Mar-07 10:35 
GeneralRe: How can I Inserting to a table PinmvpColin Angus Mackay18-Mar-07 12:58 
Questiona problem with sql server 2005 in window vista ! Pinmembermrkeivan17-Mar-07 3:58 
QuestionExporting data from sqlserver to Excel PinmemberTech_spidy17-Mar-07 3:11 
AnswerRe: Exporting data from sqlserver to Excel Pinmemberkubben17-Mar-07 3:20 
GeneralRe: Exporting data from sqlserver to Excel PinmemberTech_spidy17-Mar-07 4:50 
QuestionCan i Copy paste sql table Pinmembernikhil123417-Mar-07 1:21 
AnswerRe: Can i Copy paste sql table Pinmembermghiassi17-Mar-07 8:00 
GeneralRe: Can i Copy paste sql table PinmemberZiyad Mohammad18-Mar-07 21:52 
GeneralRe: Can i Copy paste sql table Pinmembermghiassi19-Mar-07 9:30 
Questionstored procedure vs sql query Pinmemberghumman6316-Mar-07 17:07 
AnswerRe: stored procedure vs sql query Pinmemberkubben16-Mar-07 17: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
Web01 | 2.8.150414.1 | Last Updated 21 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid