Using Variables in SQL Queries for Scripts and SQLServer Stored Procedures | Essential SQL

Get the full course. Here's the link! https://www.udemy.com/course/stored-procedures-unpacked-learn-to-code-t-sql-stored-procs/?couponCode=SPUYOUTUBE202209 If you want to make your queries more flexible, then watch this video to learn how you can add variables to your SQL Server scripts and stored procedures. Check out our channel at @EssentialSQL to learn even more about SQL Server. Do you love our videos? If so, you're sure to like our blog! Check it out at https://www.essentialsql.com/blog/ Here are the scripts for those interested: --Simple Select select * from Person.Person Where LastName like 'Ral%' --Select with variable in Query declare @LastNamePattern as varchar(40); set @LastNamePattern = 'Ral%' select * from Person.Person Where LastName like @LastNamePattern --Make it a stored procedure and run it! alter procedure PersonSearchLastName(@LastNamePattern as varchar(20)) AS begin select * from Person.Person Where LastName like @LastNamePattern end exec dbo.PersonSearchLastName 'Kal%'