SQL Server 2008 R2关键代码
DECLARE @lv_address VARCHAR(2000),
@lv_re_ids VARCHAR(2000),
@lv_search_type VARCHAR(20),
@lv_re_id NUMERIC(38),
@lv_temp_pos INT,
@lv_commapos INT,
@lv_query VARCHAR(8000)
BEGIN TRY
SET @lv_address = @pi_address
SET @lv_temp_pos = Charindex(' ', @lv_address, 1)
SET @lv_search_type = Substring(@lv_address, 1, @lv_temp_pos)
SET @lv_re_ids = Substring(@lv_address, @lv_temp_pos + 1, Len(@lv_address))
SET @lv_commapos = Charindex(',', @lv_re_ids)
WHILE @lv_re_ids IS NOT NULL
BEGIN
IF @lv_commapos = 0
BEGIN
SET @lv_re_id = Cast(@l