Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
GeneralRe: How Much Space Is Wasted In Unused Fields In SQL Server? Pin
Roger Wright20-Oct-11 5:28
professionalRoger Wright20-Oct-11 5:28 
GeneralRe: How Much Space Is Wasted In Unused Fields In SQL Server? Pin
Eddy Vluggen20-Oct-11 8:01
professionalEddy Vluggen20-Oct-11 8:01 
AnswerRe: How Much Space Is Wasted In Unused Fields In SQL Server? Pin
jschell20-Oct-11 9:05
jschell20-Oct-11 9:05 
GeneralRe: How Much Space Is Wasted In Unused Fields In SQL Server? Pin
Roger Wright20-Oct-11 10:25
professionalRoger Wright20-Oct-11 10:25 
GeneralRe: How Much Space Is Wasted In Unused Fields In SQL Server? Pin
jschell21-Oct-11 10:54
jschell21-Oct-11 10:54 
QuestionSQL Query Select Pin
reogeo200817-Oct-11 21:26
reogeo200817-Oct-11 21:26 
AnswerRe: SQL Query Select Pin
Blue_Boy17-Oct-11 22:34
Blue_Boy17-Oct-11 22:34 
GeneralRe: SQL Query Select Pin
AditSheth17-Oct-11 23:09
AditSheth17-Oct-11 23:09 
Blue_Boy wrote:
select
case when [type]=1 then 'MCA' when [type]=2 then 'Another Title' end + ' (' +
coursename +')' as TypeAndCourse
from courses


just little changes

SQL
SELECT [Coursename] + '(' + case when [type] = 1 THEN 'Regular' when [type]=2 then 'Another Title' end + ')' as TypeAndCourse
from courses


but i am agree with "Mycroft Holmes" suggestion of creating new table..
Where can we go to find God if we cannot see Him in our own hearts and in every living being
-Swami Vivekananda

AnswerRe: SQL Query Select PinPopular
Mycroft Holmes17-Oct-11 22:53
professionalMycroft Holmes17-Oct-11 22:53 
AnswerRe: SQL Query Select Pin
Niladri_Biswas26-Oct-11 16:27
Niladri_Biswas26-Oct-11 16:27 
QuestionDB2 Commands Pin
Manivannan Dheena17-Oct-11 19:17
Manivannan Dheena17-Oct-11 19:17 
AnswerRe: DB2 Commands Pin
Manivannan Dheena17-Oct-11 23:52
Manivannan Dheena17-Oct-11 23:52 
Questionisnull in linq where condition Pin
yesu prakash13-Oct-11 20:02
yesu prakash13-Oct-11 20:02 
AnswerRe: isnull in linq where condition Pin
Johan Hakkesteegt13-Oct-11 21:37
Johan Hakkesteegt13-Oct-11 21:37 
AnswerRe: isnull in linq where condition Pin
Niladri_Biswas26-Oct-11 16:14
Niladri_Biswas26-Oct-11 16:14 
QuestionData warehouse Pin
coder199113-Oct-11 1:25
coder199113-Oct-11 1:25 
QuestionLinked Server Query Returning No Records Pin
Frank Lepkowski12-Oct-11 3:26
Frank Lepkowski12-Oct-11 3:26 
AnswerRe: Linked Server Query Returning No Records Pin
Eddy Vluggen12-Oct-11 7:35
professionalEddy Vluggen12-Oct-11 7:35 
Generalerror to mysql Pin
a2bj11-Oct-11 0:16
a2bj11-Oct-11 0:16 
GeneralRe: error to mysql PinPopular
phil.o11-Oct-11 0:56
professionalphil.o11-Oct-11 0:56 
GeneralRe: error to mysql Pin
Bernhard Hiller11-Oct-11 20:58
Bernhard Hiller11-Oct-11 20:58 
GeneralRe: error to mysql Pin
Peter_in_278011-Oct-11 21:09
professionalPeter_in_278011-Oct-11 21:09 
GeneralRe: error to mysql Pin
Rakesh Meel16-Oct-11 21:48
professionalRakesh Meel16-Oct-11 21:48 
Questionselect unique record question Pin
Jassim Rahma10-Oct-11 23:02
Jassim Rahma10-Oct-11 23:02 
AnswerRe: select unique record question Pin
PIEBALDconsult11-Oct-11 2:50
mvePIEBALDconsult11-Oct-11 2:50 

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.