Hi,
I've recently migrated my Access application BE to Azure SQL and am loving learning all about the possibilities. I have what is probably a stupid question though - do stored procedures have to be written in T-SQL? Or can they be written in VB.NET? I'm have some functions in my Access FE that I want to migrate to the SQL server and have them run on a scheduled basis to manipulate some data that is being written to the database by an external application. My thinking was that I could just migrate these functions into the SQL database as "stored functions" or similar but I'm beginning to think that this isn't possible. If it isn't possible, what's the recommended way of doing this?