how to pass parameters to view in SQL Server. I need create views with variable as below.
view_name asSelect * from
tas_id = V_Taskid
V_taskid is variable which are passing during run time from ADF pipeline
Is it possible to pass variable like above in view[?]
Ronen provides an answer but also notes that this probably isn’t the right question. In many cases, we ask for a specific detail because we think we know what to do but are stuck. In practice, we’re stuck because we’re asking the wrong questions. Most of the time, we don’t even know the right question to ask, making things even more challenging.