i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
3 SQL Server 4370
Question { 3058 }
What is a GAP analysis?
Answer
Is This Answer Correct ? | 0 Yes | 0 No |
If i entered 2 columns and 4 rows inputs in DDT Like Mango
fruit, Banana Fruit, Brinjal Veget, Carrot Veget.. . My Q
is How to get the 2nd column value for corresponding 1
column input in 3rd row ie, ( i need to get "veget" in
messge box @ run time
Answer
Is This Answer Correct ? | 5 Yes | 5 No |
Question { Cap Gemini, 7398 }
In ordinal identifier there r 3 options available. Which one
will be enabled first when ordinal identifier is invoked.
Answer
Is This Answer Correct ? | 5 Yes | 2 No |