Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
SQL Server Transact Basic to Expert - Select Query with variables
WhatsApp
Karthikeyan Anbarasan
13y
2.5
k
0
0
25
Blog
This blog show how to use a variable declared seperately and used in select query as a condition
Example:
Declare @empname as varchar(50)
@empname = 'Karthik'
Select Empsal, Empid
From emptable
Where empname = @empname
SQL Server Transact Basic to Expert - Select Query with variables
Up Next
SQL Server Transact Basic to Expert - Query a temporary and a table variable tables
Ebook Download
View all
Basics of SQL Server
Read by 1.5k people
Download Now!
Learn
View all
Membership not found