Friday, 17 November 2017

Learn Sql server in hindi/urdu part-10 (Like and WildCards in sql Server)





select  *from employee



  insert into employee values('Abid',15000,1)





  select * from employee where emp_name like 'A%'



  select * from employee where emp_name like '%a'



  select * from employee where emp_name like '%a%n'



  select * from employee where emp_name like '__n%'



  select * from employee where emp_name like  's_%'



  select * from employee where emp_name like  's%a'


No comments:

Post a Comment

Pass Dynamically Added Html Table Records List To Controller In Asp.net MVC

Controller Code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using ...