tag:blogger.com,1999:blog-7468857462999845094.post7977316526696103898..comments2024-03-29T11:33:33.604+05:30Comments on Microsoft SQL Server Knowledge Bank: Can Views take the Input ParametersMR. JOYDEEP DAS (MVP-SQL Server Year 2012, MVB - D-Zone, MCDBA, MCSE, ADSE, CSI)http://www.blogger.com/profile/15813518881162145877noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7468857462999845094.post-42857088486480220862021-06-29T14:16:14.767+05:302021-06-29T14:16:14.767+05:30Good For Interview Question, Good PostGood For Interview Question, Good PostSSAS Learnhttps://www.blogger.com/profile/17123988067761472072noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-31564375016582127922016-04-22T03:02:26.873+05:302016-04-22T03:02:26.873+05:30"..I can´t set functions or tables on the DB ..."..I can´t set functions or tables on the DB - because it´s a live system...." Can you explain more? Is it that you do not have write access to the db to create obects? You can always use ADO.Net in a console app.Anonymoushttps://www.blogger.com/profile/04240602844080462504noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-39620826450648968112015-12-16T15:32:19.314+05:302015-12-16T15:32:19.314+05:30Hey, hopefully someone is going to read this.
I h...Hey, hopefully someone is going to read this.<br /><br />I have the some problem right now. The problem is, I can´t set functions or tables on the DB - because it´s a live system.<br />But I need to use the parameters ... Any ideas?<br /><br />ThanksAnonymoushttps://www.blogger.com/profile/12601806345126040508noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-42810207843561729132015-12-04T21:21:12.604+05:302015-12-04T21:21:12.604+05:30Thanks!!!! A very helpful way we can use a day...Thanks!!!! A very helpful way we can use a day...vakanhttps://www.blogger.com/profile/12797013087964376195noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-30771632444704622102015-09-10T18:38:37.262+05:302015-09-10T18:38:37.262+05:30VERY HELPFUL POST.VERY HELPFUL POST.Srisaimanjunathhttps://www.blogger.com/profile/18306417690255907980noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-68908330685222307882014-01-04T18:08:09.026+05:302014-01-04T18:08:09.026+05:30Hello Joydeep sir, can we join the SP result set w...Hello Joydeep sir, can we join the SP result set with Table विवेक सिंहhttps://www.blogger.com/profile/13018984591156960403noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-9243795602725339602013-10-02T09:52:41.046+05:302013-10-02T09:52:41.046+05:30Great explanation.Thanks for your post.Great explanation.Thanks for your post.Srihttps://www.blogger.com/profile/12751453595170821750noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-21135900893511354112012-05-28T11:03:10.307+05:302012-05-28T11:03:10.307+05:30Thanks "Artoo".
Here i am taking about ...Thanks "Artoo". <br />Here i am taking about passing parameters into the view NOT queering the view in WHERE clauses.MR. JOYDEEP DAS (MVP-SQL Server Year 2012, MVB - D-Zone, MCDBA, MCSE, ADSE, CSI)https://www.blogger.com/profile/15813518881162145877noreply@blogger.comtag:blogger.com,1999:blog-7468857462999845094.post-70681466294001424912012-05-26T13:07:46.205+05:302012-05-26T13:07:46.205+05:30A view is a virtual table so you can use your para...A view is a virtual table so you can use your parameters in the where clause.<br /><br />SELECT *<br />FROM vwEmployee<br />WHERE Salary > @Sal;Anonymoushttps://www.blogger.com/profile/15769604002687268779noreply@blogger.com