Converting T-SQL to .Net Lang | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Converting T-SQL to .Net Lang

Hi. I’m wondering whether or not is there a way to port or migrate existing T-SQL Stored Pro cedures to any dotNet language? Thnaks in advance.
what do you mean by that? you want to .net to update/insert/delete records from tables juzt like how your stored procedures do?
Did you want to ask How do I retreive data from sql server and show them in .NET?
If so, this is more general question. You need to learn .NET and sql Madhivanan Failing to plan is Planning to fail
The question is about using the CLR within SQL 2005. For example, you have a SQL 2000 database that you want to upgrade to SQL 2005, and you want to replace some of the stored procedures with code in one of the .NET programming languages. My impression is that the CLR should be used for interfacing with external resources. Data manipulation within SQL Server is probably still best handled in T-SQL.
Read the following for more info.. http://www.microsoft.com/technet/prodtechnol/sql/2005/clr4dbas.mspx
http://www.microsoft.com/technet/community/chats/trans/sql/SQL_101204.mspx
Mohammed U.
]]>