Typed T-Sql

Typed T-Sql is a programming language and extension for Visual Studio 2019. The programming language is based on Transact-SQL and is intended for programming stored procedures, functions, trigger and view.

For programming a some procedures, functions, etc. Microsoft SQL Server Management Studio is okay. But for an application with hundreds of procedures, functions, etc., this becomes unmanageable. There is where Typed T-Sql shines. It allows programs SQL Server in a way you are used with modern IDE. Typed T-Sql is a transpiler that generates T-SQL. There is no runtime component. The output is a standard T-SQL script. Installing the code in a production environment is just running sql script.

Typed T-Sql adds the following:

• static name check
• static type check.
• constants
• automatic variable declaration by using var
• DROP ... IF EXISTS is not necessary
• simply assigning rights to the procedures, functions.

Statement extensions:

• for select loop
• exec_sql
• named insert
• store

Function extensions:

• filebinary
• is_equal
• is_not_equal
• openjson
• json_value

IDE function:

• catalog browser
• quick info
• find all references
• refactoring

webservice extension

This extensions which must be explicit loaded.
It works together with Jannesen.Web and jc3. Allow the creation to web api method to be called by http. It can also create proxy that can be used in jc3 and give end to end name/type checking.

It implements the following declarations:

• WEBSERVICE
• WEBMETHOD
• WEBCOMPLEXTYPE