SQL拼接语句，一个参数的写法。试了很多次试不出来。
日期型：（如2013-03-30）
@basic_date nvarchar(10)
date='''+convert(nvarchar(10),@date,121)+'''

字符型：
@name nvarchar(20)
name='''+@name+'''

数字型（int）的该怎么写呢？
[解决办法]

DECLARE @sql NVARCHAR(128)
DECLARE @int INT 
SET @int=100
SET @sql='select top 1 * from sys.sysprocesses where spid<'+CONVERT (VARCHAR(10),@int)
EXEC (@sql)

/*
spid   kpid   blocked waittype waittime             lastwaittype                     waitresource                                                                                                                                                                                                                                                     dbid   uid    cpu         physical_io          memusage    login_time              last_batch              ecid   open_tran status                         sid                                                                                                                                                                            hostname                                                                                                                         program_name                                                                                                                     hostprocess cmd              nt_domain                                                                                                                        nt_username                                                                                                                      net_address  net_library  loginame                                                                                                                         context_info                                                                                                                                                                                                                                                       sql_handle                                 stmt_start  stmt_end    request_id 
 
------ ------ ------- -------- -------------------- -------------------------------- ---------------------------------------------------------------------------------------------------------------- ------ ------ ----------- -------------------- ----------- ----------------------- ----------------------- ------ --------- ------------------------------ ------------------------------------------------------------------ -------------------------------------------------------- -------------------------------------------------------- ----------- ---------------- -------------------------------------------------------- -------------------------------------------------------- ------------ ------------ -------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------ ------------------------------------------ ----------- ----------- -----------
1      2324   0       0x015A   6347123              XE_DISPATCHER_WAIT  
*/