格搜：下拉框写法示例

/*SELECT FROM [dbo].[OCRD] T0*/ declare @NAME1  as NVARCHAR(20)/* WHERE */ set @NAME1  = /* T0.U_DLV1 =*/ '[%0]'

/*SELECT FROM [dbo].[OCRD] T0*/ declare @NAME2  as NVARCHAR(20)/* WHERE */ set @NAME2  = /* T0.U_DLV1 =*/ '[%1]'

/*SELECT FROM [dbo].[OCRD] T0*/ declare @NAME3  as NVARCHAR(20)/* WHERE */ set @NAME3  = /* T0.U_DLV1 =*/ '[%2]'

SELECT ISNULL(@NAME1,'') + ',' + ISNULL(@NAME2,'') + ',' + ISNULL(@NAME3,'')

 

五六零

海报 链接