Can we pass parameters to a view in SQL?

by

As already stated you can’t.

A possible solution would be to implement a stored function, like: 

CREATE FUNCTION v_emp (@pintEno INT)
RETURNS TABLE
AS
RETURN
   SELECT * FROM emp WHERE emp_id=@pintEno;

This allows you to use it as a normal view, with:

SELECT * FROM v_emp(10)

More Related Contents:

  1. Parameterize an SQL IN clause
  2. How to set table name in dynamic SQL query?
  3. Pass table as parameter into sql server UDF
  4. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  5. “Order By” using a parameter for the column name
  6. Parameterise table name in .NET/SQL?
  7. Call stored procedure with table-valued parameter from java
  8. How do I obtain a Query Execution Plan in SQL Server?
  9. sql query to return differences between two tables
  10. Generate SQL Create Scripts for existing tables with Query
  11. SQL Server 2005 How Create a Unique Constraint?
  12. SQL Server: Make all UPPER case to Proper Case/Title Case
  13. How do I delete from multiple tables using INNER JOIN in SQL server
  14. Does Foreign Key improve query performance?
  15. SQL : BETWEEN vs =
  16. What is a ‘multi-part identifier’ and why can’t it be bound?
  17. SQL Server convert string to datetime
  18. sql server select first row from a group
  19. Count based on condition in SQL Server
  20. What does sp_reset_connection do?
  21. Replace first occurrence of substring in a string in SQL
  22. Why does ISNUMERIC(‘.’) return 1?
  23. How to correctly insert newline in nvarchar [duplicate]
  24. How do you copy a record in a SQL table but swap out the unique id of the new row?
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. SQL Server SELECT INTO @variable?
  27. Select a column if other column is null
  28. How to subtract 30 days from the current date using SQL Server
  29. Use one CTE many times
  30. How to do a case sensitive GROUP BY?

Leave a Comment