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

  • Pa OT po mga sir/mam

    Baka naman po meron sa inyo dyan na meron na training materials / documentation ng SQL Server 2008, need ko lang po.

    Sana po meron magandang loob na magbigay, bigyan ko na lang ng + feedback at saka papasko pag uwi ko dyan sa pinas :)

    TIA po
  • question po mga sir. is it possible for a user to have access to a view but not on the underlying table?

    example:

    i have a table named employees then i have a view named v_employees.

    the definition of v_employees is this:

    SELECT * FROM employees where employee_id > 1000

    now i want to give a particular login select access to v_employees but not on employees. is it possible to do it?
  • patulong naman po..

    eto po yung sample na tables and fields kada table, pero dun sa table2, kahit di ko na ilabas sa notepad yung TransactionNo

    Table1
    Date, TransactionNo, Description, Total Amount

    Table2
    TransactionNo, Items, Amount


    eto naman po yung dapat ma output ko sa .txt file

    Date, TransactionNo(1), Description, Total Amount
    Items(1), Amount(1)
    Items(2), Amount(2)
    Items(3), Amount(3)

    Date, TransactionNo(2), Description, Total Amount
    Items(1), Amount(1)
    Items(2), Amount(2)


    pwede po bang patulong mga sir, noob lang kasi ko pagdating sa script sa SQL. tsaka po pano ko sya mailalabas as tabulated form na kung ano field length ung ni-declare ko dapat ung rin ung susunding format sa .txt file. and let say pag ang declare kong length sa TransactionNo is 15, tapos meron syang actual TransactionNo na 8, ung extra na 7 eh gagawin lang nyang space? sana po may makatulong. maraming salamat po. pasensya na po talaga, noob lang talaga ko rito.

Who's Online

1001 active users within the last minute, 565 members, 436 guests.
Our newest member is Justintib
Click here to see online members.

Browse Items

More »

Search TipidPC


New Want to Buys

Active Items for Sale

Active Want to Buys