This is not working for me, can you suggest what is the issue in below code:

DECLARE @myCount int;

DECLARE @sql1 nvarchar(MAX);

DECLARE @DBAT [varchar](10) = 'LS_EG_DEV'

DECLARE @sql nvarchar(max);

set @sql =

N'BEGIN

SELECT count(*)...