Skip to main content

Home/ Programming tutorials and source codes/ Group items tagged stored procedure

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Sushil Saini

Stored Procedure Vs User Defined Functions in SQL Server: Which is better and why | Tec... - 0 views

www.technovisitors.com/...Stored-Procedure-vs-UDFs.html

SQL Server Stored procedure User defined functions SP UDFs

shared by Sushil Saini on 04 Jul 14 - No Cached
  • Sushil Saini on 04 Jul 14
     
    Check out comparison between the two most important SQL SERVER objects - Stored procedure and User defined functions. Which is better and why? Where to use which one?
Sushil Saini

sp_executesql Vs Execute/Exec Vs Exec() for SP in SQL Server | Techno Visitors - tablet... - 0 views

www.technovisitors.com/...SQL-Vs-Execute-SQL-Server.html

SQL Server stored procedure sp_executesql Execute

shared by Sushil Saini on 03 Aug 14 - No Cached
  • Sushil Saini on 03 Aug 14
     
    You can execute/run any stored procedures in T-SQL of SQL Server using any of SP_ExecuteSQL or EXECUTE/ EXEC methods. But the former method is considered to perform better and safer than later one. Read why?
1 - 2 of 2
Showing 20▼ items per page