Viewing 12 posts - 1 through 13 (of 13 total)
Its just a requirement, i hope by doing this i will not break any law :unsure:
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
February 10, 2011 at 6:53 am
@abhijit-2 More
I am not an advance user, just a programmer so would you please describe 🙂
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
February 10, 2011 at 6:51 am
thanks all for your replies,i know all the above rules and constraint about the relational database, my intention was to know the reason behind this rules. BTW thanks once again.:-)
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
June 16, 2009 at 11:11 pm
Thanks Steve! 🙂
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
June 16, 2009 at 11:06 pm
ummm... i guess admins are too much busy, that they cant even reply.:-P
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
June 16, 2009 at 6:47 am
whats this all about? :blink:
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
June 8, 2009 at 4:32 am
Thanks very much Jeff!:-)
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
May 29, 2009 at 11:46 pm
Thanks for the wonderful code Jeff. Please keep posting this kind of code which will help others to write complex queries in simplest way.:-)
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
May 29, 2009 at 1:38 am
yes jeff , you are right...following code will work on n Number of records. have a look!
SELECT TOP 10000000 --<<! Change this number for testing different size tables
RowNum = IDENTITY(BIGINT,1,1),...
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
May 27, 2009 at 10:53 pm
Jeff,
I was trying to find out the maximum number of records it can work with and its working fine with 6791500 records in my SQL Sever's Server having 8 GB...
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
May 27, 2009 at 6:38 am
Hi, Gud morning
i have used the same code for testing with 10 million records, as code itself is inserting records, so i have nothing to do with the data.
the method...
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
May 24, 2009 at 10:58 pm
Great piece of code Jeff but i have tested it with 10000000 records and i am getting Arithmetic overflow error converting data type' :unsure:
I am working a Developer in an...
---------------------------------------------------
The Greatest pleasure in life is doing what people say you can't do! 🙂
MS-ACCESS DBA!! :hehe:
May 22, 2009 at 6:12 am
Viewing 12 posts - 1 through 13 (of 13 total)