Javascript in Sql Server?

Question

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

Can anyone help?

score 7 · Accepted Answer · edited May 23 '17 at 12:00

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

edited May 23 '17 at 12:00

Community

1
1

answered Jul 30 '10 at 14:50

Oded

489,969
99
883
1,009

hi thanks for answers. i know about clr. but i want something that do not need compilation. – ehsan Jul 31 '10 at 06:44
3

@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 Jul 31 '10 at 06:47

Robert Jeppesen · Answer 2 · 2012-03-08T12:00:15.000

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

edited Mar 08 '12 at 12:00

answered Mar 08 '12 at 07:57

Robert Jeppesen

7,837
3
35
50

1

@ehsan: Added link to my repo – Robert Jeppesen Mar 08 '12 at 12:00

Javascript in Sql Server?

2 Answers2