alter proc [dbo].[research_CreateNewSupplier]
@Type nvarchar(10)
as
begin
DECLARE @byType tinyint set @byType = (select type from dw_code_supplierType where typeName = '''' + @Type + '''' )
if(@byType = null)
print('siiiiiiii')
else
print(@byType)为什么没有反应呀,烦死了,饭都不想吃了!
@Type nvarchar(10)
as
begin
DECLARE @byType tinyint set @byType = (select type from dw_code_supplierType where typeName = '''' + @Type + '''' )
if(@byType = null)
print('siiiiiiii')
else
print(@byType)为什么没有反应呀,烦死了,饭都不想吃了!
@Type nvarchar(10)
as
begin
DECLARE @byType tinyint select @byType=type from dw_code_supplierType where typeName =@Type
if(@byType = null)
print('siiiiiiii')
else
print(rtrim(@byType))
go
@Type nvarchar(10)
as
begin
DECLARE @byType tinyint select @byType=type from dw_code_supplierType where typeName =@Type
if(@byType is null)
print('siiiiiiii')
else
print(rtrim(@byType))
go