>

User Login

TipidPC.com is the largest online IT Community in the Philippines. Have something to sell or share? Sign up for an account now. It's absolutely free!

Forum Topic

The SQL Thread

  • rename mo yung table gawa ka ng bagong table, tapos lagay mo lahat ng data na gusto mo dun.

    pwede ka rin gumamit ng View

    Selet id, column1 from table
    UNION
    SELECT id+1, column1 from table
    UNION
    SELECT id+2, column2 from table
    .
    .
    .
  • hi everyone,

    i need an IT/ programmer who knows sql, html5 and excel. i need a web based application/ software for my personal use. i'm offering 10-15k. contact me at arclight24@gmail.com cheers
  • mga sirs question, saan maganda magaral ng SQL administration?tapos kukuha din ako ng certification TIA.
  • question..

    meron ako file A.. fld1 is 50a.. tapos file B.. fld1 is 5a, fld2 is 50a..

    pwede po ba eto.?

    insert into B select 'XXXXX', A.fld1 from A

    ..?

    salamat po...
  • anong file? text file ba yun na csv format?


    gawa ka ng table sa sql server/ms access. tapos import mo yung data ng fileA dun sa table na yun

    gawa ka ulet ng table tapos import mo yung data ng fileB dun

    tapos insert mo yung data ng tableA sa tableB


    tapos export mo sa csv yung tableB
  • pahelp naman bakit may error?

    select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
    where amt between 1500 and amt 31166
  • ^ Refer to the example below:

    SELECT column_name(s)
    FROM table_name
    WHERE column_name BETWEEN value1 AND value2;
  • select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
    where amt between 1500 and amt 31166


    select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
    where amt between 1500 and 31166
  • select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
    where amt between 1500 and amt 31166


    select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
    where amt between 1500 and 31166

    may error boss

    Msg 207, Level 16, State 1, Line 1
    Invalid column name 'amt'.
  • guys sino ba pwede dito pasetup ko lang yung sql server namin for high availability. pm me lang. log shipping yung gagawin.

    -- edited by wilmark on Jun 22 2015, 11:18 AM
  • may error boss

    Msg 207, Level 16, State 1, Line 1
    Invalid column name 'amt'.

    select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
    where output_amount between 1500 and 31166
  • ^tama ung kay sir hakujosh di ka pwedeng mag condition gamit alias pag ung alias eh kakacreate mo lang within sa query na un error talaga sa 'amt' un dapat kung ano ung original name nung field un muna ang gagamitin mo.
  • ^tama ung kay sir hakujosh di ka pwedeng mag condition gamit alias pag ung alias eh kakacreate mo lang within sa query na un error talaga sa 'amt' un dapat kung ano ung original name nung field un muna ang gagamitin mo.
  • may error boss

    Msg 207, Level 16, State 1, Line 1
    Invalid column name 'amt'.

    select bnf_fname as fname,bnf_lname as lname, output_amount as amt from TRANSACTIONS
    where output_amount between 1500 and 31166


    clap clap clap..

    ^tama ung kay sir hakujosh di ka pwedeng mag condition gamit alias pag ung alias eh kakacreate mo lang within sa query na un error talaga sa 'amt' un dapat kung ano ung original name nung field un muna ang gagamitin mo.


    noted sir
  • mga sir question, baka meron sa inyong training kit for exam regarding SQL Administration naghahanda kasi ako for exam self study sana ako eh hehe.
  • sino na nakatake sa exam nito for MCSA SQL administrator 70-461 : Querying Microsoft SQL Server 2012?kamusta mga tanong diyan mahirap ba?
  • patulong paano tamang query d2 pag may kuwit?

    ex Eugene O'Neill
  • ^try this query:

    insert into Person (First, Last)
    values ('Eugene', 'O''Neill')

    or pwede din ata ganito eh

    into Person (First, Last)
    values ('Eugene', 'O(\')Neill')

    -- edited by jayromega on Jul 02 2015, 06:23 PM
  • Days and this was with is your diet change they said eat drink and be merry at the ninety days everybody lost on average seven pounds at Christmas time they always do this study used eggs delay <click here for link> because in the months to December which is coming up quickly know Steve is keen widened to one and half .


    http://www.garciniacambogiaprofacts.com/black-label-no/
  • ^try this query:

    insert into Person (First, Last)
    values ('Eugene', 'O''Neill')

    or pwede din ata ganito eh

    into Person (First, Last)
    values ('Eugene', 'O(\')Neill')

    -- edited by jayromega on Jul 02 2015, 06:23 PM


    pag select lng boss

Who's Online

365 active users within the last minute, 175 members, 190 guests.
Our newest member is karenadora
Click here to see online members.

Browse Items

More »

Search TipidPC


New Want to Buys

Active Items for Sale

Active Want to Buys