T-SQL is nice. But I need a more flexible scripting language in Sql Server like javascript.
Can anyone help?
+5
A:
You can try looking at CLR in SQL Server.
You can use any .NET language and import assemblies to SQL server, using the public functions in those assemblies.
You may even have success with this using javascript that compiles to CLR (see this SO question on that subject).
Oded
2010-07-30 14:50:45
hithanks for answers.i know about clr. but i want something that do not need compilation.
ehsan
2010-07-31 06:44:16
@ehsan - The native language of SQL Server is SQL. Anything else will require compilation. It does not support javascript out of the box, and probably never will.
Oded
2010-07-31 06:47:07
+1
A:
I'm not sure what development set up you have but you could look at using CLR stored procs. These give you the ability to use c# to code your stored procedures.
Just google CLR stored procedures and that should bring back plenty of info.
Castrohenge
2010-07-30 14:52:06