How do I interact with the code behind my SQL server ? I am using Microsoft's SQL Server Management Studio but that is a GUI, I would like to hard code parts of my database, using SQL.
Thanks
Ordinary SQL Server is used as backend only and SQL Server Management Studio is used for debugging and database maintenance.
Applications are developed in different system/languages (SQL Server most of the time is paired with Microsoft .NET and languages such as C# or VB.NET).
So develop your front-end and middle-tier in a .NET language and use SQL Server as a backend database.