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
Bineesh Viswanath
NA
1k
777.9k
SQL Query to Restrict Entry of Same Data in a Table
Oct 15 2013 7:40 AM
Sir, I need your help in the following:-
I want SQL Query to restrict same data entry. Please take a look to the following Row:-
id Name Address Age Place Department Salary
1 Sam 3rd street, madgaon, Chennai 24 Chennai Sales 20000
2 Sam 3rd street, madgaon, Chennai 24 Chennai Sales 20000
This type of Entry does not allowed.
I need a different query than the Query I written below:-
if not exists(select Name, Address, Age, Place, Department, Salary from tbl_Employee where Name=@Name and Address=@Address and Age=@Age and Place=@Place and Department=@Department and Salary=@Salary)
begin
insert into tbl_Employee(Name, Address, Age, Place, Department, Salary)
values(@Name, @Address, @Age, @Place, @Department, @Salary)
end
Reply
Answers (
1
)
sql db construction ? any ideas
Why we use option (merge join)