I want to create a simple insert query for inserting records into the database with local variables. Example : Simple insert query looks like:
Insert Into TableName(id, firstName, lastName)
Values ('123','ABC','XYZ')
Now I want to use some local variable for assigning the values inside the Insert statement, something like this:
variable_Name UserFirstName = 'ABC'
variable_Name UserLastName = 'XYZ'
variable_Name UserId = '123'
Insert Into TableName(id, firstName, lastName)
Values (@UserId,@UserFirstName,@UserLastName)
How this can be done?