sampath


{ City }
< Country > india
* Profession *
User No # 86041
Total Questions Posted # 1
Total Answers Posted # 3

Total Answers Posted for My Questions # 3
Total Views for My Questions # 3835

Users Marked my Answers as Correct # 10
Users Marked my Answers as Wrong # 7
Questions / { sampath }
Questions Answers Category Views Company eMail

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 3835



Answers / { sampath }

Question { 2759 }

What is a GAP analysis?


Answer

It involves determining,documenting and approving the
variance between business requirements and current capabilities.

Is This Answer Correct ?    0 Yes 0 No

Question { CTS, 7383 }

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

datatable.SetCurrentRow(3)
x=datatable.Value("A",1)
msgbox x
datatable.Value("c",1)=x
msgbox c

--------------------------------------
A c
mango
banana
brinjal
carrot

Is This Answer Correct ?    5 Yes 5 No


Question { Cap Gemini, 6838 }

In ordinal identifier there r 3 options available. Which one
will be enabled first when ordinal identifier is invoked.


Answer

Its Index

Is This Answer Correct ?    5 Yes 2 No