where the SQL SERVER query table or field has been used

1 SelectB.name2  fromdbo.syscomments A, dbo.sysobjects b3 wherea.ID=b.ID andB.xtype='P'  andA.text  like '% @tempGoods%'4 Order  byName

Xtype representative Type

C = CHECK Constraint
D = defaults or DEFAULT constraints
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
IF = Inline Table function
P = Stored Procedure
PK = PRIMARY KEY constraint (type is K)
RF = copy Filter stored procedure
S = System table
TF = Table function
TR = Trigger
U = User Table
UQ = UNIQUE constraint (type is K)
V = view
X = Extended Stored Procedure

where the SQL SERVER query table or field has been used