Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
Subscribe to get the latest posts sent to your email.
I am currently working as a Senior Database Professional and have around 18 years of experience in database. Degree:- Master Degree in Computer(MCA) Certification course in Data Science & Machine Learning from Indian Institute of Technology (IIT), Delhi Work experience:- Designing of the database. Database Optimization. Writing Complex Stored Procedures,Functions,Triggers etc. Designing and developing SSIS & DTS packages. Designing SQL Reports using SSRS. Database Server Maintenance. Certification:- MCTS: DA-100: Analysing Data with Microsoft Power BI MCTS: DP-300: Administering Relational Databases on Microsoft Azure Microsoft certified Sql DBA in Sql server 2008 (MCTS). Microsoft certified BI professional in Sql server 2008 (MCTS). Oracle certified profession DBA in ORACLE 10g (OCP) certified profession DBA in ORACLE 9i (OCP) My other publication Technical Blog:- Technologies with Vivek Johari Guest Author and Blogger at sqlservercentral.com
Subscribe now to keep reading and get access to the full archive.
one more main diffrence between UDF and SPROC that UDF returns table variables, while a SPROC can't return a table variable although it can create a table. Another significant difference between them is that UDFs can't change the server environment or your operating system environment, while a SPROC can.
Thanks Amit for your valuable comments and sharing your invaluable knowledge.
Regards
Vivek
thanks vivek for sharing the articles………
Thanks
all of above 6 differences are very minute and not Very Useful for Your Concept.all of above example comes from experience not for excellence.
I am share our knowledge with u–in a single line of statement
Stored procedure is Business block in Database Domain just like Method In C#,Java,C,C++ where we have put all SQL statement. on the hand in Function we have only put that statement which can't change the database structure
means We can't use any statement that modified database structure .some are statement are as like this which cant't use in Function but u can use these statement in SP(Stored Procedure)-
Insert,update,Delete,Create,Alter,Drop,Truncate etc.
if i am Wrong,Let Me Know