I have created command text for an SQL Command, and it included a LIKE %@Value% or tried LIKE ‘%@Value%’ . These statements produced the literal Value of ‘Value’, and did not replace the parameter value as is expected. I received some guidance from another web site.
tblCustomerInfo.Info LIKE '%' + @SEARCH + '%'
(or edit the parameter value to include the % in the first place).
Otherwise, you are either (first sample) searching for the literal “@SEARCH” (not the arg-value), or you are embedding some extra quotes into the query (second sample).
In some ways, it might be easier to have the TSQL just use LIKE @SEARCH, and handle it at the caller:
Broadcast Mi version 2.x has been primarily stabilization with a few enhancements. The next enhancement I am excited to bring you is the expansion in Trends. Currently, Trends just shows a list of trended words based on their hash tag use. The next version I hope to put out shortly will allow you to drill down into each of the trends, and see the messages which have mentioned the trends. There after, two features I hope to include are a follow the broadcaster feature on each message, and a re-broadcast message feature in your own stream.
All exciting features I hope to bring you shortly. I am happy to take any input you may have on the product set.
After using Office for 7 months, all of a sudden I cannot email, reply to emails, or save documents, and I am at a client site. Bad timing. After searching the Internet, it seems my installed version of Office needs Product Activation, after 7 months. Ouch! Hope our IT people are able to get back to me soon.
Looks like we just upgraded from version 10 to 2013, and we are OK now, so no complaints here.
I just found two huge defects that you could not miss. Seriously, I will pay out 5 USD gift cards for finding unique defects. Please allow time to test the product thoroughly, and report your grand defects! I just found one, if you go onto the message page, you get an error. That is the third screen. I did not see this issue because I had data, but if you are a new user… Boom! Please report these!
In today’s rev. changes, I’ve added some refinement of the UI, auto populate of the log in screen, a restart button for My Messages and the Following screens. Here is a video with an overview of the system and changes from the last release.