Search into multiple columns from Single textbox !

Question

What is the best  way to search from Table(database) using a single text-box.

 

Using LIKE operator with every column name in SQL query is quite complicated when we had 10-15+ columns !!

Answer 1

Hi Dheeraj,

 

Just Run a query of checking user's permission before delete like this...

I assuming that you have a mapping table of UserPermissions

IF EXISTS(select count(*) from UserRoleMapping where UserID = 1 and RoleID = 1 and PermissionID = 1)
BEGIN
    --delete the data
END
ELSE
BEGIN
    --you have no rights to delete the data
END

 Thats it...