Sql blndr Que?

Question

I need a row from  sql database with letters in different color(heading or any thing).. directly

i am in .net and i can do that in ,net codes..

can u help me to achieve that in sql?

i just want to know is there any chance for this ?

 

 

give up..? no chnace...hmm

 

Table :colors

col_id [primarykey][bigint]

clor [varchar]

and i sotred seven colors. now i need each row in 7 different colors.

like select * from color

id     clor

1      white(in whilte color)

2      red    (inn red color)

k..

Answer 1

if i understand your requirement correctly the you should be using CROSS join.

SELECT i.id, c.color  

FROM   Colors AS i CROSS JOIN Colors AS c

SQL Server is Blind. It can't understand any colors to the rows or cells. What is total requirement?? do you want to display this in Front-end application??

Thansk -- Vijaya Kadiyala

www.DotNetVJ.Com

 

Answer 2

Glad, you got the answer :).

 

Answer 3

Thanks for ur reply,

I just want to know blind or not(sql).

I think in .net coloring isnt a pblm.

 

Answer 4

Table :colors

col_id [primarykey][bigint]

clor [varchar]

and i sotred seven colors. now i need each row in 7 different colors.

like select * from color

id     clor

1      white(in whilte color)

2      red    (inn red color)

k..

 

Answer 5

When you say different colors what do you mean by this!! are these stored any in any table? if YES then what is the datatype?

Answer 6

When you say different colors what do you mean by this!! are these stored any in any table? if YES then what is the datatype?