Call another database table from another database sp

Question

Hi @everyone , please help me resolve my requirement, the requirement is to execute the truncate query from A database sp to B database table in both On Premises and cloud. Please share your valuable solution. And that table was in this format dbo.table1.

Answer 1

Hi @Arutprakasam

If I understand correctly, you can try this.

CREATE PROCEDURE truncate_table
@dbname VARCHAR(max),
@schemaname VARCHAR(max),
@tablename VARCHAR(max)
AS
BEGIN
  DECLARE @SQL VARCHAR(MAX) = ''
  SET @SQL = 'TRUNCATE TABLE [' + @dbname + '].[' + @schemaname + '].[' + @tablename + ']'
  EXEC (@SQL)
END

EXEC truncate_table 'databaseB','dbo','table1';

Best regards,

Percy Tang