I am creating variables other than dates, so would need to know how to correctly create bunch of variable names.
I'm getting permission erorr when executing the following syntax.
What kind of permission do I need? I just want local variable that can be used during a batch run (ie declare @str varchar(255) set @str='partner')
Is there a local variable example? or do I have to create variables objects in the schema itself?