CODEWITHSUNDEEP
javascriptsql-servert-sql
ehsan
ehsan

Reputation: 787

Javascript in Sql Server?

T-SQL is nice. But I need a more flexible scripting language in Sql Server like javascript.

Can anyone help?

Upvotes: 0

Views: 366

Answers (2)

Robert Jeppesen
Robert Jeppesen

Reputation: 7877

You could make a thin wrapper for IronJS to expose that functionality to Sql Server. Should be easy to do, but you would be coding in Sql strings, and it would probably become a mess.

EDIT: I was thinking of doing this for fun, that's how I found your question. Here's what I've been doing for the last hour: JSql

Upvotes: 0

Oded
Oded

Reputation: 498914

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).

Upvotes: 7

Related Questions