Database

TheJudeDude wrote:

DATEDIFF('d','2009-11-08','2009-11-08')

DATEDIFF(d,'2009-11-08','2009-11-08')

DATEDIFF(dd,'2009-11-08','2009-11-08')

DATEDIFF(day,'2009-11-08','2009-11-08')

OdbcConnection DbConnection = new OdbcConnection("DSN=rsss");
    OdbcCommand DbCommand = DbConnection.CreateCommand();
    DbCommand.CommandText = "SELECT TICKET-STORE, DATEDIFF(day,'" + strDate + "','" + strDate + "') AS EXP FROM TICKET";
    DbConnection.Open();
    try
    {
        DbReader = DbCommand.ExecuteReader();
        while(DbReader.Read())
        {
            intStore = Int32.Parse(DbReader["TICKET-STORE"].ToString());
        }
    }

    catch(OdbcException caught)
    {
        Console.WriteLine(caught.ToString());
        Console.Read();

        DbConnection.Close();
    }

System.Data.Odbc.OdbcException: ERROR [HY000] Build Error: Invalid Function Name.  Function name is 'DATEDIFF'.
   at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
   at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
   at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Odbc.OdbcCommand.ExecuteReader()
   at acctmgr.Class1.Main(String[] args) in c:\documents and settings\brian\my documents\visual studio projects\acctmgr\class1.cs:line 43

Vuyiswa Maseko wrote:

The file "..." is on a network path that is not supported for database files.

I are Troll

Vuyiswa Maseko wrote:

This means that every time i do a restore i need to copy the filer over and if the Servers are not in the same place and the backup is big this can be a lengthy process.

I are Troll

select SUM(t1.A*t2.A)/SUM(t2.A)Result  from  
			   (select RecordDate,A,B,KPI from @tbl)t1 
	inner join(select RecordDate,A,B,KPI from @tbl t)t2
	on t1.RecordDate = t2.RecordDate
	and t1.KPI = t2.KPI

CREATE OR REPLACE TRIGGER orders_after_update
AFTER UPDATE
    ON orders
    FOR EACH ROW

DECLARE
    v_username varchar2(10);

BEGIN

    -- Find username of person performing UPDATE into table
    SELECT user INTO v_username
    FROM dual;

    -- Insert record into audit table
    INSERT INTO orders_audit
     ( order_id,
       quantity_before,
       quantity_after,
       username )
    VALUES
     ( :new.order_id,
       :old.quantity,
       :new.quantity,
       v_username );

END;