ALTER PROCEDURE USP_QueryT_AddressBookByField

    @FieldName nvarchar(20),    --字段名.

    @FieldVal nvarchar(50)    --字段对应的值.

AS

     SET NOCOUNT ON

     declare @query nvarchar(max)

    set @query = 'select  [FId] as [编号],[FName] as [姓名],[FSex] as [性别],[FPhone] as [电话号码],[Fqq] as [QQ],

    [FWordPhone] as [国际电话号码],[FEMail] as [EMail],[FHandSet] as [手机号] from

    [T_AddressBook] where '+@FieldName+'='''+@FieldVal+''' order by [FId]'

     exec(@query)

--EXEC SP_EXECUTESQL @sql 会报错:

--Procedure or function 'USP_QueryT_AddressBookByField' --expects parameter '@FieldVal', which was not supplied.