December 4, 2008 at 3:49 pm
I am really thankful to you Paul for your reply and alleviating my concern. It prompts me to explore more this 'B-tree structure' thing, quoted so much in the BOL and elsewhere. I can understand that B-tree is a computer science theory and SQL Server has its own implementation of this concept.
Essentially, as GilaMonster said this is irrelevant to the access of the data through the DML queries. But this discussion is very helpful for me to be clear about the Physical Database Architecture. I did not pay much attention to it after completing My MCITP dev and admin (SQL Server 2005) last year because I am still into development side (database and applications) and am aspiring to to move into db admin side.
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
December 16, 2008 at 5:50 am
Thank you all,
This Trigger works successfully:
alter TRIGGER [TRG993]
ON [dbo].[Source]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO DBntext2.dbo.Destination (Id, Title, Body)
SELECT a.Id, a.Title, CAST(a.Body as nvarchar (MAX))
FROM DBnetxt1.dbo.Source a, inserted b
where a.Id = b.Id
and now i have two questions:
if DBntext1 and DBntext2 are in two diffrent Servers what should i do? How write T_QL Block?
and the second question is that there are some fields in DBntext1 and i want to modify and then put in to DBntext2,
in Server A.DBntext1.dbo.Source i have:
ID( int) Title ( nvarchar(50) ) Body (ntext) Level 1(int ) Level 2 (int)
1 a aa.... 1000 2000
but i want to modify data of 2 fields(Level1 and Level2) and then put them in the Server B.DBntext2.dbo.Destination
Server B.DBntext2.dbo.Destination i want to have :
ID( int) Title ( nvarchar(50) ) Body (nvarchar(max)) Level 1(int ) Level2
1 a aa.... 1 2
*** ***
How should i write the The T_SQL Block?
December 16, 2008 at 7:37 am
Asked and partially answered here - http://www.sqlservercentral.com/Forums/FindPost620292.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply