|
此文章由 再来一碗 原创或转贴,不代表本站立场和观点,版权归 oursteps.com.au 和作者 再来一碗 所有!转贴必须注明作者、出处和本声明,并保持内容完整
-- 1) Assume ITEM is the first table's name
-- 2) Assume ITEM_WORD is the second table's name
-- 3) Assume the second table's key is auto generated by system
--4) the following script shall work and generate a set of sql insert scripts
-- 5) you just need to run the whole set of sql insert scripts
SET NOCOUNT ON
DECLARE @idx int
DECLARE @ITEM_ID int
DECLARE @ITEM_DESCRIPTION varchar(255)
DECLARE @my_cursor CURSOR
SET @my_cursor = CURSOR FOR
SELECT ITEM_ID, ITEM_DESCRIPTION
FROM ITEM
OPEN @my_cursor
FETCH NEXT FROM @my_cursor INTO @ITEM_ID, @ITEM_DESCRIPTION
WHILE @@FETCH_STATUS = 0
BEGIN
SET @idx = CHARINDEX('_', @ITEM_DESCRIPTION, 0)
WHILE @idx > 0
BEGIN
PRINT 'INSERT INTO ITEM_WORD (ITEM_ID ,WORD) VALUES(' + CONVERT(varchar, @ITEM_ID) + ',' + + '''' + SUBSTRING(@ITEM_DESCRIPTION, 1, @idx - 1) + '''' + ')'
SET @ITEM_DESCRIPTION = SUBSTRING(@ITEM_DESCRIPTION, @idx + 1, LEN(@ITEM_DESCRIPTION) - @idx)
SET @idx = CHARINDEX('_', @ITEM_DESCRIPTION, 0)
END
PRINT 'INSERT INTO ITEM_WORD (ITEM_ID ,WORD) VALUES(' + CONVERT(varchar, @ITEM_ID) + ',' + + '''' + @ITEM_DESCRIPTION + '''' + ')'
FETCH NEXT FROM @my_cursor INTO @ITEM_ID, @ITEM_DESCRIPTION
END
CLOSE @my_cursor
DEALLOCATE @my_cursor |
评分
-
查看全部评分
|