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

  • mga sir and master paano i back up ang database ng sql with images? thanks.
  • depends sa database server...ang alam ko lang is sqlserver ng microsoft. kaya nya at madali lang magbackup dun ehehehe
  • Hello po,

    Ano po ibig sabihin sa MS T SQL nitong double @ signs

    @@sampleVariable

    May effect po ba 'to or any significance po ba 'to?
  • @kevin

    from <click here for link>

    The names of some Transact-SQL system functions begin with two at signs (@@). Although in earlier versions of Microsoft SQL Server, the @@functions are referred to as global variables, they are not variables and do not have the same behaviors as variables. The @@functions are system functions, and their syntax usage follows the rules for functions.
  • @hallie

    Thanks po sa fast response! Appreciate it.
  • Hi, I need some help regarding po sa SQL jobs.. meron kasi akong ginwang backup and restore job. in months umaandar sya pero last week di na sya makapag backup sa network path. Operating system error 1265.

    note: nagawa ko na po adding/changing permission ng shared folder, user account na nag-rurun sa sql agent. but no luck. I'm sure hindi to sa permission.

    Please help me.. nabasa ko na po lahat ng searches sa google so I'm expecting different solution.. TIA
  • goodmorning,

    ask ko lang po saan pwede makakita ng tutorial on how to create scripts para mapagsama sa isang query ang sum of a certain columns ng ibat ibang column
  • seasrch mo 'group by' sa w3school
  • @rameioj13:

    Normally an SQL Jobs create a LOG Files, on it you can view the detail explanation why your JOBS encountered an ERROR. If you can locate and check the log files it will provide you some information on how you will troubleshoot your problems.
  • need help :)

    Table 1

    Columns (Device,Function)
    DevA,Func1
    DevA,Func2
    DevB,Func1

    Table 2
    Columns (Device, Information)
    DevA,Details
    DevB,Details

    --
    My current output

    DevA,Func1,Details
    DevA,Func2,Details
    DevB,Func1,Details

    Desired output

    DevA,Func1/Func2,Details
    DevB,Func1,Details

    --

    So basically nag dodouble (or kung ilang un funcX) yung output now. need ko i combine un Func1 para single row lang yung return? TIA

    -- edited by probaldur on Feb 12 2014, 05:21 PM
  • ^ Tingin ko ganyan talaga yan sir kasi unique row yugn dalawa sa baba

    DevA,Func1
    DevA,Func2


    Gawa ka nalang procedure to concatenate yung Func1 saka Func2.

    Just my 2 pence
  • @probaldur

    kung mysql yung DB mo pwedeng gamitin mo yung group_concat

    SELECT table2.device, GROUP_CONCAT(DISTINCT table1.function ORDER BY table1.function SEPARATOR ',') AS functions, table2.details
    FROM table1 INNER JOIN table2
    ON table1.device = table2.device
    GROUP BY table2.device, table2.details
  • @probaldur, if MS SQL server gamit mo, try using FOR XML Path for concatenation. Here's the link:
    https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
    Hope it helps.
  • ideally, formatting should not be done in the SQL, it has to be somewhere in the UI, BLL or service layer
  • Managed to do it via cte. Thanks po sa mga nag help. Ill post it tom.

    -- edited by probaldur on Feb 13 2014, 10:01 PM
  • anyone po na may alam sa case na ganito

    DB2 data type byte to SQL varchar = Ok sa Previous versions ng SSIS like 2k-2k5

    pero sa SSDT 2012, sablay na
    casting,ifnull/coalesce didn't resolve the issue.

    or any workaround suggestions? TIA
  • anyone with t-sql that generates breakdown of recurring dates in a given range?

    start date, end date, recur type (daily,weekly,monthly,annual) un mga given parameters.

    TIA
  • @probaldur, have you tried DatePart? I think it can solve your problem.
  • mga bro tanong anong pinagkaiba ng FULL backup sa TRANSACTIONAL BACKUP ano bang silbi ng TRANSACTIONAL BACKUP?
  • FULL backup = full database backup
    TRANSACTIONAL backup = transaction log backup - backs up the transactions since the last transaction or full database backup and also truncates the transaction log (otherwise the transaction log gets bigger and bigger until you no longer have disk space, and you get a log suspend error). Transaction log backups are also needed to be able to do point-in-time database restores
  • FULL backup = full database backup
    TRANSACTIONAL backup = transaction log backup - backs up the transactions since the last transaction or full database backup and also truncates the transaction log (otherwise the transaction log gets bigger and bigger until you no longer have disk space, and you get a log suspend error). Transaction log backups are also needed to be able to do point-in-time database restores
    \

    ok medyo gets ko pero paano ko maviview ung TRANSACTIONAL LOGS?
  • mga SQL masters, very newbie question lang po, paano po ba iinstall ang SQL server 2005/2008 under win 7, then paano po sya iconfigure para maiconnect mga SQL server client via internet? wala pa po akong basics sa SQL pero po kung me makakakatulong po dito sa thread, highly appreciated po. please pm me naman po kung meron pong willing mag tutor at actual hands on. willing to pay po for your service.

    salamat po.

Who's Online

945 active users within the last minute, 535 members, 410 guests.
Our newest member is wzpwyfxlnk
Click here to see online members.

Browse Items

More »

Search TipidPC


New Items for Sale

Active Items for Sale

Active Want to Buys