Click here to Skip to main content
15,867,308 members
Home / Discussions / Database
   

Database

 
QuestionHow to get the text of create table sql when I know the table name Pin
richardye27-Dec-07 20:51
richardye27-Dec-07 20:51 
AnswerRe: How to get the text of create table sql when I know the table name Pin
GuyThiebaut28-Dec-07 0:12
professionalGuyThiebaut28-Dec-07 0:12 
GeneralRe: How to get the text of create table sql when I know the table name Pin
richardye28-Dec-07 13:32
richardye28-Dec-07 13:32 
GeneralWithout using order by Pin
vimal_yet27-Dec-07 18:09
vimal_yet27-Dec-07 18:09 
GeneralRe: Without using order by Pin
Krish - KP27-Dec-07 19:24
Krish - KP27-Dec-07 19:24 
GeneralRe: Without using order by Pin
vimal_yet27-Dec-07 21:56
vimal_yet27-Dec-07 21:56 
GeneralRe: Without using order by Pin
GuyThiebaut27-Dec-07 23:30
professionalGuyThiebaut27-Dec-07 23:30 
AnswerRe: Without using order by [modified] Pin
GuyThiebaut28-Dec-07 0:02
professionalGuyThiebaut28-Dec-07 0:02 
Try something like this:

<br />
CREATE TABLE #MyTempTable (salary decimal(28,12))<br />
INSERT INTO #MyTempTable  <br />
SELECT salary FROM employeedetails<br />
GROUP BY salary <br />
<br />
CREATE INDEX salary <br />
ON #MyTempTable (salary DESC)<br />
<br />
SELECT * FROM #MyTempTable<br />


Regards

Guy

You always pass failure on the way to success.


modified on Friday, December 28, 2007 6:15:09 AM

GeneralRe: Without using order by Pin
vimal_yet28-Dec-07 0:54
vimal_yet28-Dec-07 0:54 
GeneralRe: Without using order by Pin
Pete O'Hanlon28-Dec-07 0:34
subeditorPete O'Hanlon28-Dec-07 0:34 
GeneralInsert text to sql server 2000, single quotation appears occationally Pin
followait27-Dec-07 1:56
followait27-Dec-07 1:56 
GeneralRe: Insert text to sql server 2000, single quotation appears occationally Pin
N a v a n e e t h27-Dec-07 1:58
N a v a n e e t h27-Dec-07 1:58 
GeneralRe: Insert text to sql server 2000, single quotation appears occationally [modified] Pin
followait27-Dec-07 2:10
followait27-Dec-07 2:10 
GeneralRe: Insert text to sql server 2000, single quotation appears occationally Pin
N a v a n e e t h27-Dec-07 20:32
N a v a n e e t h27-Dec-07 20:32 
GeneralNested Select query Pin
Poonam Gandash26-Dec-07 20:50
Poonam Gandash26-Dec-07 20:50 
GeneralRe: Nested Select query Pin
Krish - KP26-Dec-07 23:30
Krish - KP26-Dec-07 23:30 
GeneralRe: Nested Select query Pin
Poonam Gandash27-Dec-07 0:44
Poonam Gandash27-Dec-07 0:44 
GeneralRe: Nested Select query Pin
andyharman26-Dec-07 23:33
professionalandyharman26-Dec-07 23:33 
GeneralRe: Nested Select query Pin
vimal_yet27-Dec-07 0:13
vimal_yet27-Dec-07 0:13 
QuestionDatabase Design Issue Pin
Mostafa Siraj26-Dec-07 19:57
Mostafa Siraj26-Dec-07 19:57 
GeneralRe: Database Design Issue Pin
vimal_yet27-Dec-07 0:18
vimal_yet27-Dec-07 0:18 
GeneralRe: Database Design Issue Pin
Colin Angus Mackay27-Dec-07 0:30
Colin Angus Mackay27-Dec-07 0:30 
GeneralRe: Database Design Issue Pin
Adeel Chaudhry27-Dec-07 20:50
Adeel Chaudhry27-Dec-07 20:50 
GeneralRe: Database Design Issue Pin
Paul Conrad28-Dec-07 10:25
professionalPaul Conrad28-Dec-07 10:25 
GeneralSelect statement Pin
tellytub26-Dec-07 16:13
tellytub26-Dec-07 16:13 

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.