SQL Server Performance

Converting T-SQL to .Net Lang

Discussion in 'SQL Server 2005 CLR' started by gavalmart, Nov 15, 2006.

  1. gavalmart New Member

    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.
  2. smy New Member

    what do you mean by that? you want to .net to update/insert/delete records from tables juzt like how your stored procedures do?
  3. Madhivanan Moderator

    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
  4. Adriaan New Member

    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.
  5. MohammedU New Member

Share This Page