Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Clipper Visual-Objects > BASIC QUESTION ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 17 Topic 11294 of 11795
Post > Topic >>

BASIC QUESTION - SQL SERVER

by jorgeaccinelli@[EMAIL PROTECTED] Apr 7, 2008 at 05:33 PM

Hello
    I have a table of accounting entries,
    For different companies.

    The number of accounting records could not be self incremental
    (Each company has its own numbering)

    Even the numbered accounts is reorganized at the end
    The accounting period

    How can I get the largest number of accounting records
    Home after add records?

    In Mysql there is a command "MAX (number) FOR UPDATE"
    Blocking the table until commit

    What is the most efficient in SQL server?

Jorge Accinelli
 




 17 Posts in Topic:
BASIC QUESTION - SQL SERVER
jorgeaccinelli@[EMAIL PRO  2008-04-07 17:33:09 
Re: BASIC QUESTION - SQL SERVER
"Geoff Schaller"  2008-04-08 03:38:04 
Re: BASIC QUESTION - SQL SERVER
johan.nel@[EMAIL PROTECTE  2008-04-10 04:39:04 
Re: BASIC QUESTION - SQL SERVER
"Markus Feser"   2008-04-11 09:36:43 
Re: BASIC QUESTION - SQL SERVER
jorgeaccinelli@[EMAIL PRO  2008-04-10 12:00:21 
Re: BASIC QUESTION - SQL SERVER
jorgeaccinelli@[EMAIL PRO  2008-04-11 15:19:42 
Re: BASIC QUESTION - SQL SERVER
"Markus Feser"   2008-04-14 09:40:38 
Re: BASIC QUESTION - SQL SERVER
johan.nel@[EMAIL PROTECTE  2008-04-12 00:06:18 
Re: BASIC QUESTION - SQL SERVER
"Markus Feser"   2008-04-14 09:26:44 
Re: BASIC QUESTION - SQL SERVER
johan.nel@[EMAIL PROTECTE  2008-04-14 07:20:49 
Re: BASIC QUESTION - SQL SERVER
"Markus Feser"   2008-04-14 16:30:46 
Re: BASIC QUESTION - SQL SERVER
jorgeaccinelli@[EMAIL PRO  2008-04-14 17:04:20 
Re: BASIC QUESTION - SQL SERVER
"Markus Feser"   2008-04-15 17:25:13 
Re: BASIC QUESTION - SQL SERVER
johan.nel@[EMAIL PROTECTE  2008-04-16 03:50:19 
Re: BASIC QUESTION - SQL SERVER
"richard.townsendros  2008-04-18 04:20:25 
Re: BASIC QUESTION - SQL SERVER
"Geoff Schaller"  2008-04-19 07:52:21 
Re: BASIC QUESTION - SQL SERVER
"Markus Feser"   2008-04-22 09:54:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 18:03:36 CST 2008.