Hi,

In SQL Server,

can I write VBA?
where can I write?

Please let me know, thanks.

You cannot write VBA in SQL Server. Only T-SQL and that is done in a Stored Procedure, View or Function.

You can write Extended Stored Procedures which are .dll files, but unless you are really friendly with your Network folks and DBA, you will never get them loaded on your SQL Server.