Viewing 13 posts - 1 through 13 (of 13 total)
If I move the database into another server, also the identity wont be reused???
March 13, 2007 at 1:03 am
I did the level number.
But the indexing is still a problem cause it depends on index of parent in case it's a first child and depends on index of previous...
November 29, 2005 at 12:27 am
i modified my procedure to do it without recursion as follows.But now how do i set the level,index numbers?
parent 1 : level= 1, index=1
child of parent 1(C1) :...
November 28, 2005 at 9:07 am
NO join is not a solution. join might give wrong records. The same order id 10 might be updated several times... |
October 13, 2004 at 1:04 am
I would've liked to use For Delete trigger but i can't since there are text columns in the table. And i... |
October 5, 2004 at 1:16 am
It's ok. ISNULL function has all the solution for me. I had forgotton all about it. ISNULL works great in my... |
September 9, 2004 at 1:42 am
what do i do if my text goes over 8000? which will probably do. ???????//// |
September 8, 2004 at 6:17 am
Well basicly this is my query but it isn't working. It is arriving to sender 2, 4 and 1 while it... |
September 2, 2004 at 1:06 am
Well basicly this is my query but it isn't working. It is arriving to sender 2, 4 and...
September 2, 2004 at 1:04 am
What i mean by 10 times consecutively is that a certain controller shouldn't be sent to the same region 10 times... |
July 13, 2004 at 12:33 am
First, controller ID is the primary key so the join must be on controller ID. Suppose that is done, what about the... |
July 12, 2004 at 12:36 am
well it is definite that no attributes other than filePath and fileID will be added. That's why i was wondering if... |
May 7, 2004 at 12:57 am
Viewing 13 posts - 1 through 13 (of 13 total)