Click here to Skip to main content
16,017,297 members
Home / Discussions / Database
   

Database

 
QuestionRe: need to layout the database Pin
Paul Conrad21-Jul-08 14:27
professionalPaul Conrad21-Jul-08 14:27 
AnswerRe: need to layout the database Pin
keyboard warrior21-Jul-08 14:31
keyboard warrior21-Jul-08 14:31 
GeneralRe: need to layout the database Pin
User 171649221-Jul-08 13:18
professionalUser 171649221-Jul-08 13:18 
GeneralRe: need to layout the database Pin
keyboard warrior21-Jul-08 14:33
keyboard warrior21-Jul-08 14:33 
GeneralRe: need to layout the database Pin
Ennis Ray Lynch, Jr.21-Jul-08 15:02
Ennis Ray Lynch, Jr.21-Jul-08 15:02 
QuestionAccessing a "default" database in a linked server Pin
Luis Alonso Ramos21-Jul-08 9:44
Luis Alonso Ramos21-Jul-08 9:44 
AnswerRe: Accessing a "default" database in a linked server Pin
Wendelius21-Jul-08 10:03
mentorWendelius21-Jul-08 10:03 
GeneralRe: Accessing a "default" database in a linked server Pin
Luis Alonso Ramos21-Jul-08 11:41
Luis Alonso Ramos21-Jul-08 11:41 
Mika Wendelius wrote:
Maybe catalog (or default database) has actual meaning only on OLEDB-queries?


After I saw your post, I tried this:
EXEC sp_addlinkedserver @server ='TRW', @srvproduct = '', @provider = 'SQLOLEDB',
    @datasrc = '127.0.0.1', @location = NULL, @provstr = '', @catalog = 'trw_data'
and it didn't work either.

OPENQUERY seems to work fine. One question though: Performance-wise, is it a good choice if the remote table pontentially will have a lot of records? I suppose that if add a filter in the inner query, it would be faster. But what if that filter were dynamic? The only thing I can think of is to build the query with string concatenation before passing it to OPENQUERY.

Thanks, you got me into the right track. Smile | :)

Luis Alonso Ramos
Intelectix
Chihuahua, Mexico

My Blog!

GeneralRe: Accessing a "default" database in a linked server Pin
Wendelius21-Jul-08 18:01
mentorWendelius21-Jul-08 18:01 
GeneralRe: Accessing a "default" database in a linked server Pin
Luis Alonso Ramos22-Jul-08 8:13
Luis Alonso Ramos22-Jul-08 8:13 
GeneralRe: Accessing a "default" database in a linked server Pin
Wendelius22-Jul-08 9:10
mentorWendelius22-Jul-08 9:10 
QuestionCan we restrict the number of maximum records inserted in a particular table? Pin
Rocky#21-Jul-08 0:24
Rocky#21-Jul-08 0:24 
AnswerRe: Can we restrict the number of maximum records inserted in a particular table? Pin
Krish - KP21-Jul-08 1:12
Krish - KP21-Jul-08 1:12 
GeneralRe: Can we restrict the number of maximum records inserted in a particular table? Pin
Rocky#21-Jul-08 1:19
Rocky#21-Jul-08 1:19 
GeneralRe: Can we restrict the number of maximum records inserted in a particular table? Pin
Mycroft Holmes21-Jul-08 14:22
professionalMycroft Holmes21-Jul-08 14:22 
GeneralRe: Can we restrict the number of maximum records inserted in a particular table? Pin
Rocky#21-Jul-08 19:26
Rocky#21-Jul-08 19:26 
GeneralRe: Can we restrict the number of maximum records inserted in a particular table? Pin
Mycroft Holmes21-Jul-08 19:55
professionalMycroft Holmes21-Jul-08 19:55 
GeneralRe: Can we restrict the number of maximum records inserted in a particular table? Pin
Rocky#21-Jul-08 21:07
Rocky#21-Jul-08 21:07 
AnswerRe: Can we restrict the number of maximum records inserted in a particular table? Pin
nelsonpaixao24-Jul-08 12:34
nelsonpaixao24-Jul-08 12:34 
QuestionConvert Decimal To Date? Pin
obarahmeh20-Jul-08 23:06
obarahmeh20-Jul-08 23:06 
AnswerRe: Convert Decimal To Date? Pin
Rocky#21-Jul-08 0:20
Rocky#21-Jul-08 0:20 
GeneralRe: Convert Decimal To Date? [modified] Pin
Pete O'Hanlon22-Jul-08 9:19
mvePete O'Hanlon22-Jul-08 9:19 
GeneralRe: Convert Decimal To Date? Pin
Rocky#22-Jul-08 18:24
Rocky#22-Jul-08 18:24 
GeneralRe: Convert Decimal To Date? [modified] Pin
Pete O'Hanlon22-Jul-08 22:06
mvePete O'Hanlon22-Jul-08 22:06 
GeneralRe: Convert Decimal To Date? Pin
Rocky#22-Jul-08 23:20
Rocky#22-Jul-08 23:20 

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

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