I am new to SQL and have been making progress with simple queries. Some of the queries I have been running are
I understand that a parameter must be declared for the parameter to work and have successfully written a simple query that does this:
@CompName Varchar (30)
SET @CompName ='MJM%'
SELECT [Company Name], [Contact Source]
WHERE [Company Name] Like 'MJM%';
The problem I am having now is how do I export this a:
- Stored Procedure
- Allowing people to access this via a web interface.
I need simple step by step instructions if possible or a link to where I can find these type of instructions.
Thank you in advance for your assistance.