Viewing 9 posts - 46 through 54 (of 54 total)
hum..sorry if i coudnt explain clearly,let me know this :
whats the best way (from performance point of view) to select last X records from a Table
October 6, 2008 at 4:02 am
Chirag (10/6/2008)
What about an incrementing id column?
i have incrementing entity column but you know ?
im going to write a procedure that call from my application each 3,4 and even per...
October 6, 2008 at 3:36 am
karthikeyan (10/6/2008)
if you have datetime column in your table, then select max(datetime column) from will give you the expected result.
no,theres no DateTime
October 6, 2008 at 3:19 am
Make sure you understand the difference between @@IDENTITY and SCOPE_IDENTITY before rolling this code out into a live environment.
John
is there any difference between @@IDENTITY and SCOPE_IDENTITY except working scope ?
December 19, 2007 at 6:05 am
Matija Lah (12/18/2007)
When you answer the question above you'll...
December 18, 2007 at 2:37 am
Chirag (12/18/2007)
From where will u get the data. R u porting from some other SQL db, or a text file or what?
Generall speaking insert the companies first and then insert...
December 18, 2007 at 12:37 am
Ian Yates (12/1/2007)
There are only editions of SQL...
December 1, 2007 at 1:35 am
Sugesh Kumar (12/1/2007)
December 1, 2007 at 12:07 am
Sugesh Kumar (11/30/2007)
Go for sql enterprise edition to have all advantages of sql 2005.
dear friends ! we cant setup enterprise edition on XP os ! hum ?
November 30, 2007 at 11:51 pm
Viewing 9 posts - 46 through 54 (of 54 total)