List All Table Names in a Database

This is a buildin sql stored procedure that lists all tables in a database

use Content

EXEC sp_tables
@table_name = '%',
@table_owner = 'dbo',
@table_qualifier = 'Content';

Msms AS400 Procedure Call

This is an procedure call script from an As400 Database that linked in to Microsoft Sql Server as a linked server.

Declare @PIACCT CHAR(10)
Declare @QIBAN CHAR(26)
DECLARE @HATA CHAR(30)
DECLARE @SHORTN CHAR(18)

Exec (‘{CALL TAKACZEH.IBANSP1(?,?,?,?)}’,@PIACCT,@QIBAN out,@HATA out,@SHORTN out) AT EUROTEST

Select @PIACCT,@QIBAN,@HATA,@SHORTN