Click here to Skip to main content
16,019,768 members
Home / Discussions / Database
   

Database

 
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 
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 
You're welcome Smile | :)

A little trick that came into my mind which could be useful to you.
BEGIN
	DECLARE @remoteQuery varchar(8000);
	SET @remoteQuery = 'SELECT * FROM OPENQUERY(SERVER2, ''SELECT * FROM dbo.Shipments'')'

	PRINT @remoteQuery
	EXEC (@remoteQuery)
END

Mika
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 
GeneralRe: Convert Decimal To Date? Pin
Pete O'Hanlon23-Jul-08 1:08
mvePete O'Hanlon23-Jul-08 1:08 
GeneralRe: Convert Decimal To Date? Pin
Rocky#23-Jul-08 3:02
Rocky#23-Jul-08 3:02 
AnswerRe: Convert Decimal To Date? Pin
Blue_Boy21-Jul-08 0:36
Blue_Boy21-Jul-08 0:36 

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.