if @GetUserId != '' and @GetUserId is not null
set @strWhere = @strWhere + ' and come_userid = ' +@GetUserIdif @GetGameId != '' and @GetGameId is not null
set @strWhere = @strWhere + ' and come_gameid = ' +@GetGameIdif @GetSiteId != '' and @GetSiteId is not null
set @strWhere = @strWhere + ' and come_siteid = ' +@GetSiteId
set @strWhere = @strWhere + ' and come_userid = ' +@GetUserIdif @GetGameId != '' and @GetGameId is not null
set @strWhere = @strWhere + ' and come_gameid = ' +@GetGameIdif @GetSiteId != '' and @GetSiteId is not null
set @strWhere = @strWhere + ' and come_siteid = ' +@GetSiteId
我刚接触过程这,多谢了
set @strWhere = @strWhere + ' and come_userid = ' +rtrim(@GetUserId)if @GetGameId != ''
set @strWhere = @strWhere + ' and come_gameid = ' +rtrim(@GetGameId)if @GetSiteId != ''
set @strWhere = @strWhere + ' and come_siteid = ' +rtrim(@GetSiteId)
还有一个问题就是,这个过程中,我怎么才能取到记录集呢?
ASP里又该怎么取?