Click here to Skip to main content
11,712,241 members (77,176 online)
   

Database

 
Questioncolumn length select query Pin
playout18-Mar-07 20:31
memberplayout18-Mar-07 20:31 
AnswerRe: column length select query Pin
Ziyad Mohammad18-Mar-07 20:47
memberZiyad Mohammad18-Mar-07 20:47 
GeneralRe: column length select query Pin
playout18-Mar-07 21:53
memberplayout18-Mar-07 21:53 
Questioninstalled in server and run from client Pin
hamid_m17-Mar-07 23:21
memberhamid_m17-Mar-07 23:21 
AnswerRe: installed in server and run from client Pin
Colin Angus Mackay18-Mar-07 3:38
mvpColin Angus Mackay18-Mar-07 3:38 
Questionupdating table of one database with data from another database? Pin
111917-Mar-07 19:55
member111917-Mar-07 19:55 
AnswerRe: updating table of one database with data from another database? Pin
mghiassi18-Mar-07 9:56
membermghiassi18-Mar-07 9:56 
AnswerRe: updating table of one database with data from another database? Pin
Ziyad Mohammad18-Mar-07 20:50
memberZiyad 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? Pin
Pete O'Hanlon18-Mar-07 23:58
memberPete O'Hanlon18-Mar-07 23:58 
Questionhow to use trigger in sql server 2005 ? Pin
hdv21217-Mar-07 7:26
memberhdv21217-Mar-07 7:26 
AnswerRe: how to use trigger in sql server 2005 ? Pin
Pete O'Hanlon18-Mar-07 23:54
memberPete O'Hanlon18-Mar-07 23:54 
QuestionHow can I Inserting to a table Pin
mghiassi17-Mar-07 6:41
membermghiassi17-Mar-07 6:41 
AnswerRe: How can I Inserting to a table Pin
Colin Angus Mackay18-Mar-07 3:35
mvpColin Angus Mackay18-Mar-07 3:35 
GeneralRe: How can I Inserting to a table Pin
mghiassi18-Mar-07 9:35
membermghiassi18-Mar-07 9:35 
GeneralRe: How can I Inserting to a table Pin
Colin Angus Mackay18-Mar-07 11:58
mvpColin Angus Mackay18-Mar-07 11:58 
Questiona problem with sql server 2005 in window vista ! Pin
mrkeivan17-Mar-07 2:58
membermrkeivan17-Mar-07 2:58 
QuestionExporting data from sqlserver to Excel Pin
Tech_spidy17-Mar-07 2:11
memberTech_spidy17-Mar-07 2:11 
AnswerRe: Exporting data from sqlserver to Excel Pin
kubben17-Mar-07 2:20
memberkubben17-Mar-07 2:20 
GeneralRe: Exporting data from sqlserver to Excel Pin
Tech_spidy17-Mar-07 3:50
memberTech_spidy17-Mar-07 3:50 
QuestionCan i Copy paste sql table Pin
nikhil123417-Mar-07 0:21
membernikhil123417-Mar-07 0:21 
AnswerRe: Can i Copy paste sql table Pin
mghiassi17-Mar-07 7:00
membermghiassi17-Mar-07 7:00 
GeneralRe: Can i Copy paste sql table Pin
Ziyad Mohammad18-Mar-07 20:52
memberZiyad Mohammad18-Mar-07 20:52 
GeneralRe: Can i Copy paste sql table Pin
mghiassi19-Mar-07 8:30
membermghiassi19-Mar-07 8:30 
Questionstored procedure vs sql query Pin
ghumman6316-Mar-07 16:07
memberghumman6316-Mar-07 16:07 
AnswerRe: stored procedure vs sql query Pin
kubben16-Mar-07 16:57
memberkubben16-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
Web04 | 2.8.150819.1 | Last Updated 1 Sep 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid