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










Tibco Rendezvous (tibrv) C# .Net example









madeinstein



,















This is an example of broadcast messaging using TIBCO Rendezvous .   You can find more information about queue, dispatcher, transport and other rendezvous concepts in the TIBCO Rendezvous® Concepts  pdf documentation.   Command Line:   Receiving messages   tibrvlisten –service <port> -network "<ip-address>" –daemon <port> "<subject>"    tibrvlisten –service <port> -network ";<multicast-ip-address>" –daemon <port> "<subject>"         tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST"     tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.>"   Publishing messages   tibrvsend –service <port> -network "<ip-address>" –daemon <port> "<subject>" "<your-message>"   tibrvsend -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST" "He








Read more










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