>

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.
  • Hi Guys! meron lang akong tanong sa inyo. Natry ko na google ito pero hindi ko talaga makita kung ano ang sagot. I always hear my co-workers asking me if I know how to run an Orphan Script in SQL. First of all, what is this "Orphan Script" and how will I run it to work on my Database in MS SQL Server? I'm part of a team that provides phone assistance to the customers who purchase our software that stores it's database in MS SQL Server (2005, 2008, 2012 ans 2014).

    TIA!

    -- edited by cybermac on Oct 31 2014, 12:40 AM
  • Ex-DBA Here!

    @cybermac

    You might be referring to an "Orphaned Record". Nagyayari ito sa isang database na walang Referential Integrity checks. Let's say nag delete ka ng record sa Customer Table, pero merong syang "related" data na nasa ibang table na hindi kasama sa deletion process. That record is now "Orphaned".

    @amdg

    bigyan mo ng permission yung particular login mo dun sa view object mo. details here: http://technet.microsoft.com/en-us/library/ms188371(v=sql.105).aspx

    -- edited by cocoy0717 on Oct 31 2014, 05:28 AM
  • salamat po sir cocoy0717!

    Pero meron daw kasi script na kelangan run para mailagay yung isang table sa isang Database. Yun ba ang ibig sabihin ng orphan script? Yung gagamitin mo yung isang table from one Database and place it one another Database?
    At ano naman ang gagamitin ko para gumawa ng orphan script? Paano ito magrun para magconnect sa Database?

    -- edited by cybermac on Oct 31 2014, 06:53 AM

Who's Online

600 active users within the last minute, 315 members, 285 guests.
Our newest member is san_man
Click here to see online members.

Browse Items

More »

Search TipidPC


New Want to Buys

Active Items for Sale

Active Want to Buys