User Login

Forum Topic

The SQL Thread

  • di ba dapat separate table yung payment details?

    pag nagbayad, update mo yung balance sa main table tapos at the same time meron ka another table para matrack mo yung payment. dun sa table na yun nandun yung previous balance tapos magkano binayad nya saka yung remaining.
  • @arthurj07

    salamat sir. :)
  • tanong mga idol paano magedit ng SSIS package na nadeploy na?meron kasi akong alam na add existing package eh parang di naman umuubra pahelp naman TIA
  • hi guys,

    need some help... :) paano mag duplicate/copy ng record kung may auto-increment na field sa same table?

    right now, meron akong isang table (w/c has 80 columns) na may isang data sa row nya. kelangan kong iduplicate 2000 times (for performance measurement sa windows CE device) yung data na yun.

    I tried this query just to try to duplicate even kahit isang beses lang and
    INSERT INTO TestResult SELECT * from TestResult where Overall_Result_E = 1;

    ang binabato sa aking error is di pwede ma-modify yung auto-increment field.

    I tried normal insertion and it works:
    INSERT INTO TestResult (Test_Type_E) VALUES (2); (pero yung Test_Type_E column lang ang may laman - as expected)


    2nd, pag napopulate ko na yung 2000 results, I need to change one of the label column to a specific incremental order. e.g.

    MyLabel-1
    MyLabel-2
    MyLabel-3
    ....
    MyLabel-2000

    I am using SQL Server CE by the way :) thanks in advanced :)
  • if i remember correctly, there is a command so that values can be assigned to identity/autonumber field. for your second question, you may just use the autonumber field to generate the sequence and it needs only a simple string concatenation. or you can use the window functions, such as ranking, partition, row number, something like that, just google.
  • 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
  • hi, tanong ko lang kung sino po nakapag exam dito nito

    70-462 Administering Microsoft SQL Server 2012 Databases
    70-464 Developing Microsoft SQL Server Databases

    tanong ko lang baka pede nyo ako bigyan ng tips at mga training materials nyo.
  • up ko lang po
  • ^ Balak mo mag MCSE-BI?
  • @jspydrej

    kakatake ko lang ng exam last tuesday for 70-462 haha actually re-take na kasi bagsak ako nung una 1 tanong na lang na pinagpalit ko pa ng sagot tama na namali pa kaya bagsak but this time pasado haha. May alam akong malupit na reviewer ang payo ko lang review pre lang ng review hanggang makabisado mo. Tsaka magtake ka around July - Jan kasi may second shot na kasama para pang fallback plan mo lang will take the 70-461 Querying Microsoft SQL Server 2012 Databases this July or August. PM mo ako
  • @jayromega


    paps pa pm din ng reviewer makapag aral habang wala pa pang exam


    kung ok lang sana

Search TipidPC


Browse Items

New Want to Buys

Active Want to Buys