Click here to Skip to main content
15,886,110 members
Home / Discussions / Database
   

Database

 
GeneralRe: Specified cast is not valid? Pin
WetRivrRat29-Jun-05 13:45
WetRivrRat29-Jun-05 13:45 
GeneralImporting a CSV File Into Oracle Pin
wayevans27-Jun-05 10:38
wayevans27-Jun-05 10:38 
GeneralADO connections Pin
HahnTech27-Jun-05 9:07
HahnTech27-Jun-05 9:07 
GeneralPlease give me an advive Pin
Blue_Skye27-Jun-05 8:00
Blue_Skye27-Jun-05 8:00 
GeneralRe: Please give me an advive Pin
StylezHouse27-Jun-05 8:46
StylezHouse27-Jun-05 8:46 
GeneralUnable to Connect to AS400 Pin
wchscott27-Jun-05 5:37
wchscott27-Jun-05 5:37 
QuestionSimplest query to get last 10 records? Pin
Rahul.P.Menon26-Jun-05 21:03
sussRahul.P.Menon26-Jun-05 21:03 
AnswerRe: Simplest query to get last 10 records? Pin
Colin Angus Mackay26-Jun-05 21:37
Colin Angus Mackay26-Jun-05 21:37 
This is the best I can come up with:
SELECT TOP 10 FROM MyTable ORDER BY ClusteredIndexColumns DESC


Remember that the SELECT statement returns a set, and in a set there is no concept of order, so, in order to maintain this artificial order, to get the first 10 rows chance the DESC to ASC

The ClusteredIndexColumns are the columns that make up your clustered index, this is often the primary key.


My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More


GeneralRe: Simplest query to get last 10 records? Pin
Rahul.P.Menon26-Jun-05 21:47
sussRahul.P.Menon26-Jun-05 21:47 
GeneralReporting Service DataSet Pin
Amal ElHosseiny26-Jun-05 20:35
Amal ElHosseiny26-Jun-05 20:35 
GeneralCheck to see if a Table exists Pin
Wilye26-Jun-05 10:14
Wilye26-Jun-05 10:14 
GeneralRe: Check to see if a Table exists Pin
Colin Angus Mackay26-Jun-05 11:54
Colin Angus Mackay26-Jun-05 11:54 
GeneralRe: Check to see if a Table exists Pin
toxcct27-Jun-05 6:17
toxcct27-Jun-05 6:17 
GeneralRe: Check to see if a Table exists Pin
Bruzak27-Jun-05 19:55
Bruzak27-Jun-05 19:55 
GeneralRe: Check to see if a Table exists Pin
Wilye28-Jun-05 2:55
Wilye28-Jun-05 2:55 
GeneralOLEDB COMMANDS Pin
02088326-Jun-05 9:42
02088326-Jun-05 9:42 
GeneralGet ID Problem Pin
WDI26-Jun-05 7:35
WDI26-Jun-05 7:35 
GeneralRe: Get ID Problem Pin
Colin Angus Mackay26-Jun-05 12:02
Colin Angus Mackay26-Jun-05 12:02 
Generalserver registration problem Pin
Anonymous26-Jun-05 2:50
Anonymous26-Jun-05 2:50 
GeneralRe: server registration problem Pin
Anonymous26-Jun-05 9:33
Anonymous26-Jun-05 9:33 
GeneralInsert problem Pin
Blue_Skye25-Jun-05 17:08
Blue_Skye25-Jun-05 17:08 
GeneralRe: Insert problem Pin
Luis Alonso Ramos25-Jun-05 17:20
Luis Alonso Ramos25-Jun-05 17:20 
GeneralRe: Insert problem Pin
Blue_Skye26-Jun-05 1:44
Blue_Skye26-Jun-05 1:44 
GeneralRe: Insert problem Pin
Luis Alonso Ramos26-Jun-05 5:31
Luis Alonso Ramos26-Jun-05 5:31 
GeneralRe: Insert problem Pin
toxcct26-Jun-05 7:33
toxcct26-Jun-05 7:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.