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..
Vijaya KadiyalaPosted Apr 9, 2009, 12:20 PM
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
Vijaya KadiyalaPosted Apr 17, 2009, 1:13 PM
Glad, you got the answer :).
SreekanthPosted Apr 15, 2009, 7:17 AM
Thanks for ur reply,
I just want to know blind or not(sql).
I think in .net coloring isnt a pblm.
SreekanthPosted Apr 9, 2009, 1:12 AM
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..
Vijaya KadiyalaPosted Apr 8, 2009, 4:41 PM
Vijaya KadiyalaPosted Apr 8, 2009, 4:40 PM