Click here to Skip to main content
15,914,109 members
Home / Discussions / Database
   

Database

 
AnswerRe: Sql Server to Oracle Pin
Wendelius8-Dec-08 4:46
mentorWendelius8-Dec-08 4:46 
GeneralRe: Sql Server to Oracle Pin
Civic068-Dec-08 4:52
Civic068-Dec-08 4:52 
GeneralRe: Sql Server to Oracle Pin
Wendelius8-Dec-08 4:56
mentorWendelius8-Dec-08 4:56 
GeneralRe: Sql Server to Oracle Pin
Civic068-Dec-08 5:02
Civic068-Dec-08 5:02 
GeneralRe: Sql Server to Oracle Pin
Wendelius8-Dec-08 5:21
mentorWendelius8-Dec-08 5:21 
QuestionEuro symbol & CDO via T-SQL Pin
RichardGrimmer8-Dec-08 3:57
RichardGrimmer8-Dec-08 3:57 
AnswerRe: Euro symbol & CDO via T-SQL Pin
Ben Fair8-Dec-08 4:08
Ben Fair8-Dec-08 4:08 
GeneralRe: Euro symbol & CDO via T-SQL Pin
RichardGrimmer8-Dec-08 4:32
RichardGrimmer8-Dec-08 4:32 
AnswerRe: Euro symbol & CDO via T-SQL Pin
Wendelius8-Dec-08 5:42
mentorWendelius8-Dec-08 5:42 
GeneralRe: Euro symbol & CDO via T-SQL Pin
RichardGrimmer8-Dec-08 5:44
RichardGrimmer8-Dec-08 5:44 
GeneralRe: Euro symbol & CDO via T-SQL [modified] Pin
Wendelius8-Dec-08 5:55
mentorWendelius8-Dec-08 5:55 
GeneralRe: Euro symbol & CDO via T-SQL Pin
RichardGrimmer8-Dec-08 23:28
RichardGrimmer8-Dec-08 23:28 
GeneralRe: Euro symbol & CDO via T-SQL Pin
Wendelius9-Dec-08 5:24
mentorWendelius9-Dec-08 5:24 
QuestionSelect column name where... Pin
Muammar©6-Dec-08 20:53
Muammar©6-Dec-08 20:53 
AnswerRe: Select column name where... Pin
Wendelius6-Dec-08 22:38
mentorWendelius6-Dec-08 22:38 
I think you could write a little procedure (or program). If you need the columns only from one table, just select the first row and loop through columns. If you need info from several tables, you could use system tables and based on the info from there, loop tables, fetch first row and then loop through columns. You'll need to use dynamic statements based on system table information.

The need to optimize rises from a bad design.My articles[^]

AnswerRe: Select column name where... Pin
Mohammad Dayyan8-Dec-08 13:52
Mohammad Dayyan8-Dec-08 13:52 
GeneralRe: Select column name where... Pin
Muammar©12-Dec-08 19:24
Muammar©12-Dec-08 19:24 
GeneralRe: Select column name where... Pin
Mohammad Dayyan12-Dec-08 20:39
Mohammad Dayyan12-Dec-08 20:39 
GeneralRe: Select column name where... Pin
Muammar©12-Dec-08 21:39
Muammar©12-Dec-08 21:39 
GeneralRe: Select column name where... Pin
Mohammad Dayyan13-Dec-08 4:41
Mohammad Dayyan13-Dec-08 4:41 
GeneralRe: Select column name where... Pin
Muammar©13-Dec-08 18:27
Muammar©13-Dec-08 18:27 
GeneralRe: Select column name where... Pin
Muammar©13-Dec-08 19:26
Muammar©13-Dec-08 19:26 
GeneralRe: Select column name where... Pin
Mohammad Dayyan13-Dec-08 20:10
Mohammad Dayyan13-Dec-08 20:10 
GeneralRe: Select column name where... Pin
Muammar©13-Dec-08 20:17
Muammar©13-Dec-08 20:17 
Questionhow to transfer all data to another database Pin
harcaype6-Dec-08 4:12
harcaype6-Dec-08 4:12 

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.