tokei's Profile User Rating: -----

Reputation: 1 Apprentice
Group:
Members
Active Posts:
34 (0.04 per day)
Joined:
15-December 11
Profile Views:
556
Last Active:
User is offline Yesterday, 09:49 PM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   tokei has not set their status

Posts I've Made

  1. In Topic: Cannot Query more than one data

    Posted 17 Apr 2014

    View Postsmendoza88, on 17 April 2014 - 10:50 PM, said:

    Besides the error message what is it you're trying to accomplish anyhow? I'm still confused what you're trying to do?


    Dear smendoza88,

    Thanks for your help. I want to store data in variable.

    baavgai have answer my question.

    From
    tokei

    Thanks baavgai ,

    You help me a lot.


    from
    tokei
  2. In Topic: [Link] How We Learned to Code

    Posted 15 Apr 2014

    learn from youtube, stackoverflow, blog etc

    from
    tokei
  3. In Topic: What Are You Working On Today?

    Posted 15 Apr 2014

    Practice programming while waiting another job offer to me

    From
    Tokei
  4. In Topic: Cannot Query more than one data

    Posted 15 Apr 2014

    Hello baavgai

    Thanks for your help

    If follow your advice

    declare @t as nvarchar(100)
    SELECT @t = ProductDesc from table1
    print @t
    
    


    The result is
    Wimax-Home

    Feel weird, actually it should return all data (my expected result)

     select ProductDesc from table1
    
    


    Result :
        ID      
    -----------
    Packet-Eye 
    Wiggy        
    Wimax-Lite 
    Wimax-Home   
    
    


    So it means the value of variable @t only return for last row data.

    If follow your statement

    declare @t as nvarchar(100)
    set @t = (SELECT top 1 ProductDesc from table1)
    print @t
    
    


    It return :
    Packet-Eye

    So I understand the variable can return one data.
    So is it the T-SQL don't have List (like List<T> CSharp) or array ?

    Thanks for your help

    From
    tokei
  5. In Topic: Cannot Query more than one data

    Posted 15 Apr 2014

    Quote

    [A stored procedure can output more than a single value, but this is not relevant to your question.]


    I'm a novice (beginner) with Transact-SQL.

    However thanks for your help.

    From
    tokei

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

tokei hasn't added any friends yet.

Comments

tokei has no profile comments yet. Why not say hello?