Viewing 15 posts - 21,061 through 21,075 (of 26,490 total)
The following code is a very simple example using existing databases on a "retired" server.
create view dbo.OpenQueryTest
as
SELECT
jobname,
jobdesc
FROM
OPENQUERY(DWSQL1, 'SELECT...
May 11, 2009 at 12:39 pm
Steve Jones - Editor (5/11/2009)
May 11, 2009 at 12:33 pm
It is still worth a try. I found the code but it is a bit confusing as it has nested subqueries. Can you write the query as if...
May 11, 2009 at 11:54 am
John Esraelo (5/11/2009)
May 11, 2009 at 11:40 am
John Esraelo (5/11/2009)
As you can see I have been reading many postings in various forums in order to find the answer I have been looking for.
This is also related to...
May 11, 2009 at 11:27 am
anu1krishna (5/11/2009)
this is not the ans of my question please dont ask question if u dont wann to give ans.//
In answer to your question, none that I know of. ...
May 11, 2009 at 11:15 am
herbey zepeda (9/30/2008)
May 11, 2009 at 11:05 am
Alvin Ramard (5/11/2009)
Steve Jones - Editor (5/11/2009)
May 11, 2009 at 10:26 am
Anybody watch the History Channel (US) this weekend? I caught a story about Paramount auctioning off a lot of Star Trek props. The model for the Enterprise D...
May 11, 2009 at 10:05 am
Paul White (5/11/2009)
Ok - no worries. It seems I did misunderstand you!
Do please run the script I posted when Real World commitments allow - I remember being quite surprised...
May 11, 2009 at 6:48 am
Paul White (5/10/2009)
Lynn Pettis (5/10/2009)
I think that is something I'd want to verify before stating.
I am wounded - you seem to suggest that I did not verify it...!
Lynn Pettis (5/10/2009)
May 10, 2009 at 11:49 pm
Paul White (5/10/2009)
Lynn Pettis (5/10/2009)
All I wanted to make sure was that it isn't the BEGIN TRANSACTION (explicit or implicit) that creates any locks.
Sure. BEGIN TRANSACTION doesn't even get...
May 10, 2009 at 11:36 am
Paul,
All I wanted to make sure was that it isn't the BEGIN TRANSACTION (explicit or implicit) that creates any locks. This part of a transaction does not know what...
May 10, 2009 at 1:46 am
Jamie,
Thank you for taking the time to read my blog. I can tell you, from my own point of view, that the more you tell me up front the...
May 9, 2009 at 8:06 am
saurabh.dwivedy (5/8/2009)
DECLARE @addr VARCHAR(1000), @delim CHAR(1), @x INT
SET @delim = '*'
SET @addr = '5605 PRINCETON AVE STE B* COLUMBUS* GEORGIA*31904*(01/11/06 -...
May 8, 2009 at 11:05 pm
Viewing 15 posts - 21,061 through 21,075 (of 26,490 total)