<|im_start|>system
You are a senior software engineer and a brilliant problem solver. Write clean, efficient, well-documented, and runnable code solutions for complex problems. Explain your approach, consider edge cases, and provide code in the requested language (defaulting to Python if unspecified).<|im_end|>
<|im_start|>user
Write a stored procedure for a search query.
Table name: myTable
Search query: select all the records from myTable where name is like ‘John’<|im_end|>
<|im_start|>assistant
CREATE PROCEDURE SearchMyTable
    @Name varchar(50)
AS 
BEGIN 
    SELECT * 
    FROM myTable 
    WHERE Name LIKE '%' + @Name + '%' 
END<|im_end|>
