Thanks Stephen I am not using SQL Server for this app, but will keep this code for reference.
El 22/04/2010 10:30, Stephen Russell escribió: > On Wed, Apr 21, 2010 at 3:29 PM, Rafael Copquin<[email protected]> > wrote: > ---------------------- > > Would you consider a SQL Server that has a table for this need. Only > one column, the key you need. Below is code to create a table a SP to > populate it and it will return the KEY # back to you. > > CREATE TABLE MyTable > ( > MyPK int NOT NULL IDENTITY(1,1) > CONSTRAINT PK_MyTable PRIMARY KEY, > MyData int NOT NULL > ) > GO > > CREATE PROC MyProc > @MyData int > AS > SET NOCOUNT ON > INSERT INTO MyTable (MyData) VALUES(1) > SELECT SCOPE_IDENTITY() > GO > > EXEC MyProc @MyData = 1 > GO > > I don't think that you could grow the 4 gig FREE version in a year > with transaction rates in the thousand per hour. You will have to > truncate the log file but that is a maintenance process that is easy > to implement. > > Just tossing out an idea for you. > > If your transaction rate if 10,000 per hour or more you will need to > delete some of this data in your maintenance plan and that is real > simple as well. > > Select top 5 * > into #t1 > from MyData > order by MyPk desc. > > Declare @min int > > set @min = (select min(MyPk) from #t1) > > Delete from myData where myPk<= @min > > > > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
