A stored procedure problem?

kanedan

I am going to write a stored procedure to output N records of an arbitrary table
But it always doesn't work. In the stored procedure that needs to pass parameters, I have not succeeded yet.
create proc SkyCms
@TableName VARCHAR (200),
@RowNumber int
As
declare @TSql varchar (100)
Set @ Tsql = "Select Top" + @ RowNumber + "From" + @ TableName
Exec (@Tsql)
go

sinexe

--Try
create proc SkyCms
@TableName VARCHAR(200),
@RowNumber int
As
declare @TSql varchar(8000)
Set @Tsql='Select Top'+convert(varchar(8000),@RowNumber)+'* From'+ @TableName
Exec(@Tsql)
go

fanfan1980

--try

create proc SkyCms
@TableName VARCHAR(200),
@RowNumber int
As
declare @TSql varchar(8000)
Set @Tsql='Select Top'+rtrim(@RowNumber)+' * From'+@TableName
Exec(@Tsql)
go

sinexe

RTRIM
Return a string after truncating all trailing spaces.

Learn, hehe.

fanfan1980

The purpose of the above SQL is to convert the data type

快乐时间

create proc SkyCms
@TableName VARCHAR(200),
@RowNumber int
As
declare @TSql varchar(8000)
Set @Tsql='Select Top'+rtrim(@RowNumber)+' * From'+@TableName
Exec(@Tsql)
go

wgfxman

correct. .
1. The original @RowNumber is an int type variable. When connected to the target string, it must be converted to a type such as char() and then operated;
2. The table column was originally missing. . *