SQL Like statement with variable

madeinstein , 
DECLARE @myVariable as char(2)

SELECT @myVariable=column1

FROM Table2 

WHERE id = 1

SELECT * FROM Table1

WHERE column1 like '%'+@myVariable+'%'
  
































Comments











Post a Comment



















Popular posts from this blog









Parse XML to dynamic object in C#









madeinstein



,















<? xml version="1.0" encoding="utf-8" ?>  < contacts >    < contact  id = '1' >      < firstName > Michael </ firstName >      < lastName > Jordan </ lastName >      < age > 40 </ age >      < dob > 1965 </ dob >      < salary > 100.35 </ salary >    </ contact >    < contact  id = '2' >      < firstName > Scottie </ firstName >      < lastName > Pippen </ lastName >      < age > 38 </ age >      < dob > 1967 </ dob >      < salary > 55.28 </ salary >    </ contact >  </ contacts >   public  class  XmlToDynamic {   public  static  void  Parse(dynamic parent, XElement node)   {     if  (node.HasElements)     {       if  (node.Elements(node.Elements().First().Name.LocalName).Count() > 1)       {         //list          var item = new  ExpandoObject();         var list = new  List<dynamic








Read more











C# Updating GUI from different thread









madeinstein



,















   void MyEventHandler( object  sender, EventArgs e) {  if  (this.InvokeRequired)  {    this.Invoke( new  EventHandler(MyEventHandler), new  object [] { sender, e }  );  } else {    //update GUI here  } }      void MyEventHandler( object  sender, MyEventArgs e) {     if  (this.InvokeRequired)     {         this.BeginInvoke( new  EventHandler<MyEventArgs>(MyEventHandler), new  object [] { sender, e });                    }     else     {         //update GUI here     } }    








Read more