0

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

Can anyone help?

Improve this question

2 Answers 2

Reset to default
7

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

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

hi thanks for answers. i know about clr. but i want something that do not need compilation.
@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.
0

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

Improve this answer

1 Comment

@ehsan: Added link to my repo

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.