how to return the select Query for this.

Posted by Jayakumars under ASP.NET AJAX on 9/18/2012 | Points: 10 | Views : 1621 | Status : [Member] [MVP] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi

my Table Stru like this

Name
Tab1
Tab2
Tab3
stc
Tab100

here i need sometimes some tab no records found. So i need which column have the
data that column only return in my select query how will do this.(using MySql).

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Divyaselvarathinam on: 9/22/2012 [Member] Starter | Points: 25

0	You can use IsNull() function to check the column value as this... SELECT * from TABLENAME where (ISNULL(COLUMN1,0))<>0 and (ISNULL(COLUMN1,0))<>0 Divya Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 9/22/2012 [Member] [MVP] Bronze | Points: 25

0	hi thanks your reply but i need without column name mention achieve this. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Jayakumars, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts