tag:blogger.com,1999:blog-7805972021499203804.post3695556264954278378..comments2023-10-30T06:24:14.411-07:00Comments on ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview: SQL Server - Get List of All Stored Procedures from Database in SQL ServerSuresh Dasarihttp://www.blogger.com/profile/01337689983379917267noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7805972021499203804.post-37870167368315807832014-12-19T03:24:48.528-08:002014-12-19T03:24:48.528-08:00it's working.........it's working.........Anonymoushttps://www.blogger.com/profile/04588678672999087665noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-23276423508800990182014-02-05T22:58:07.957-08:002014-02-05T22:58:07.957-08:00 USE SampleDB
SELECT * FROM SYS.PROCEDURES
gives ... USE SampleDB<br />SELECT * FROM SYS.PROCEDURES<br /><br />gives incorrect result. i have 10 database in SQL Sever. It is not giving correct result.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-49765134706378477292013-06-27T03:45:00.318-07:002013-06-27T03:45:00.318-07:00Hi Sir....
what is meant by the following if cond...Hi Sir....<br />what is meant by the following if condition in mysql workbench storedprocedure?what output it will return?<br />(here, para_disability_id is the parameter am passing and candidates.disability_id is the value i taken from table)<br /><br />if(para_disability_id=-1,0=0,cand.disability_id=para_disability_id)<br />Anonymoushttps://www.blogger.com/profile/17124133145591002871noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-66281748312912470372013-06-18T04:18:50.956-07:002013-06-18T04:18:50.956-07:00hi ahmad , below query will show you properties of...hi ahmad , below query will show you properties of table,maybe its correct or not just chech it out..<br /><br />"exec sp_columns Table Name"Selvahttps://www.blogger.com/profile/09963631146465838223noreply@blogger.comtag:blogger.com,1999:blog-7805972021499203804.post-34942251754257383232013-06-13T22:39:21.792-07:002013-06-13T22:39:21.792-07:00properties of tableproperties of tableIrtekaz Ahmed Khanhttps://www.blogger.com/profile/11243194408811395763noreply@blogger.com