TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
priti srivastava
NA
81
4.6k
replacing null records with default records
Feb 16 2017 8:20 AM
Dear Friends
I Have three tables. I want to take all records from these tables. but in last records would be null or blank . In this condintion i want to replace those records with default value.I haven't idea how to fire sql query. Please help me.
---------------- --------------------------- ---------------------------------------
Id | Name SudId | class | ID ImageId | Imagename | SudId
1 | ab | 2 | A_2 | 1 1 | ~/image/a | 2
2 | sha | 5 | B4 | 2
my schema is like this and i want to display a default image if image is not in recard.
please help thanks
Reply
Answers (
6
)
how to set the validation error
Select Non Zero Multiple Columns From Select Statement