How to use a table variable?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How to use a table variable?
Rating:
A table variable is used to store temporary data. Suppose a user has to store the employee data, which contains the following columns:
- empname
- empage
- empaddress
- empsalary
- empphone
- empemail
- empdeptid
DECLARE @Employee TABLE
empname VARCHAR(30)
empage INT
empaddress VARCHAR(50)
empsalary DECIMAL(1,2)
empphone VARCHAR(20)
empemail VARCHAR(30)
empdeptid INT
When the stored procedure is executed by using the
Rating:
Was this information helpful?
Other articles
- What is RAID-5?
- What is the db_owner database-level role?
- What is a differential database backup?
- What is transactional replication?
- What is an endpoint?