Can we pass a parameter to a view in Microsoft SQL Server?
I tried to create a view in the following way, but it doesn't work:
create or replace view v_emp(eno number) as select * from emp where emp_id=&eno;
You can implement the stored function, like this:
CREATE FUNCTION v_emp (@pintEno INT)RETURNS TABLEASRETURNSELECT * FROM emp WHERE [email protected];
CREATE FUNCTION v_emp (@pintEno INT)
SELECT * FROM emp WHERE [email protected];
This will allow you to use it as the normal view, by using the below code:
SELECT * FROM v_emp(10)
To master SQL statements, queries and become proficient in SQL queries, enroll in an industry-recognized SQL Online Course.
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.