Go语言视频零基础入门到精通

不要错过

    declare @cateId int
    declare @cate nvarchar(255)
    declare @sum int
    set @sum=0
    set @cate=null
    select @sum=count(*) from sheet1$
    declare @i int
    set @i=1
    while @sum>0
    1begin
    select top 1 * from (select top @i @cate=caetgoryName from sheet1$)temp
    select @cateId=categoryId from DocumentCategory d where d.categoryName=@cate
    update sheet1$ set caetgoryName =replace(caetgoryName ,caetgoryName ,@cateId) where caetgoryName =@cate
    set @i=@i+1
    set @sum=@sum-1;
    end
    报的错：
    消息 170，级别 15，zhuang态 1，第 11 xing
    第 11 行: '@i' 附近you语法错误。Huan迎来到Java学习者论坛,转载请注明地址:http://www.javaxxz.com.

yy1020

你是想写成循环？

不要错过

SQL code declare @cateId int
    declare @cate nvarchar(255)
    declare @sum int
    set @sum=0
    set @cate=null
    select @sum=count(*) from sheet1$
    declare @i int
    set @i=1
    while @sum>0
    begin
    select top 1 @cate=caetgoryName from (select top (@i) caetgoryName from sheet1$)temp
    select @cateId=categoryId from DocumentCategory d where d.categoryName=@cate
    update sheet1$ set caetgoryName =replace(caetgoryName ,caetgoryName ,@cateId) where caetgoryName =@cate
    set @i=@i+1
    set @sum=@sum-1;
    end

wcq1314

看不懂.
    要写得这么麻烦么,
    循环里的这一句
    select top 1 * from (select top @i @cate=caetgoryName from sheet1$)temp
    有什么作用?
    第n條数据,這样就行了:
    SQL code select * from(
    select *,row_number()over(order by (select 1))rn from tb
    ) where rn=@n

jspfan

這样改改
    SQL code declare @cateId int
    declare @cate nvarchar(255)
    declare @sum int
    set @sum=0
    set @cate=null
    select @sum=count(*) from sheet1$
    declare @i int
    set @i=1
    while @sum>0
    begin
    select top 1 @cate=caetgoryName from (select top (@i) caetgoryName from sheet1$ order by caetgoryName asc)temp order by caetgoryName asc
    select @cateId=categoryId from DocumentCategory d where d.categoryName=@cate
    update sheet1$ set caetgoryName =replace(caetgoryName ,caetgoryName ,@cateId) where caetgoryName =@cate
    set @i=@i+1
    set @sum=@sum-1;
    end

jspfan

都是厉害的人。。。顶一下

zhouj1990

2005以上的？学习了

yy1020

SQL code
    declare @n int
    set @n=YourRowNumber
    WITH OrderedOrders AS
    (SELECT *,
    ROW_NUMBER() OVER (order by (select 1))as RowNumber
    FROM YourTableName)
    SELECT *
    FROM OrderedOrders
    WHERE RowNumber=@n;

fangfang1

不仔细看还以为是一个死循环

yy1020

top后面如果是变量需要加括号，不過楼主这写法不是一般人能看得懂。
    LZ是要把sheet1$表中的categoryName改成對應的CategoryId吧？难道這不是一条语句能搞定的事吗？无语
    update sheet1$
    set caetgoryName=d.categoryId
    from sheet1$ s
    inner join DocumentCategory d on s.categoryName=d.categoryName