Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Asking about T-SQL and CLR

Author  Topic 

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-04-07 : 10:16:01
When should Transact-SQL or CLR be used?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-04-07 : 10:21:38
Choosing Between Transact-SQL and Managed Code
When writing stored procedures, triggers, and user-defined functions, one decision you must make is whether to use traditional Transact-SQL, or a .NET Framework language such as Visual Basic .NET or Visual C#. Use Transact-SQL for data access with little or no procedural logic. Use managed code for CPU-intensive functions and procedures that feature complex logic, or when you want to make use of the BCL of the .NET Framework.

Source: http://msdn.microsoft.com/en-us/library/ms254498(VS.80).aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-04-07 : 13:27:47
tq very much
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-04-07 : 15:31:44
welcome


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -