Join Martin Guidry for an in-depth discussion in this video Choosing between T-SQL vs. CLR, part of SQL Server: Triggers, Stored Procedures, and Functions.
- View Offline
- Exercise Files
Now that we've seen how to create a stored procedures using T-SQL and how to…create stored procedures using C#, you're going to be faced with a decision.…Every stored procedure you create, you have to choose either T-SQL or C#. I'd like…to give you some tips on which one to use.…There's very little that can be done and one that can't be done in the other. If…you try hard enough, you can accomplish anything with either one.…But each one does have its stress and its weaknesses.…T-SQL's strength is certainly querying data.…
We can just go in there and directly write a SELECT, UPDATE, INSERT or DELETE statement.…You don't have to set up a connection, don't have to close a connection. We just…write our T-SQL statements and they run.…T-SQL however, is poor with complex logic.…We have very few decision structures. Basically, you've an if, and not a whole…lot of else, and we have a very few looping structures.…You have a while, and not a whole lot else.…T-SQL does not natively support, arrays, collections, for-each or classes, and…
- Comparing triggers, functions, and stored procedures
- Installing and configuring SQL Server
- Creating a stored procedure
- Returning data using data sets
- Creating user-defined functions
- Using "after," "instead," and nested triggers
- Modifying existing stored procedures
- Implementing logging on DELETE
- Choosing between T-SQL and CLR
- Executing a stored procedure
- Passing parameters
Skill Level Advanced
1. Getting Started
2. Installing SQL Server
Configuring your environment4m 53s
3. Stored Procedures
4. User-Defined Functions
6. Putting It All Together
7. Using CLR Assemblies
8. Exploring an ASP.NET Web Application
Next steps1m 43s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.