Beginners question on stored procedures

[ExcessionOCP]

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?

[June7]

It's my understanding that stored procedures are T-SQL coding.

Your Access VBA functions will have to be rewritten in whichever code is appropriate.

[Minty]

For anything involving data manipulation I would probably stick with T-SQL, as any other external processing is unlikely to be more efficient than SQL itself.

If it's something more exotic, then yes you can do all sorts of external things:
https://learn.microsoft.com/en-us/az...?view=azuresql

But there is obviously a learning curve.

[NoellaG]

Here you can find a good tutorial o, stored procedures: https://www.mssqltips.com/sqlservert...m_content=head
If you're interested in basic T-SQL, just send me a PM with your e-mail and I'll forward you my training manual T-SQL.