Database

DECLARE @TestTable TABLE(
    Column1 DECIMAL(18,2))

INSERT 
  INTO @TestTable
       (Column1) 
VALUES (123.4)

SELECT *
  FROM @TestTable

I are Troll

BobInNJ wrote:

when I define a decimal data type as 4,2 that means exactly two digits to the right of the decimal point, not two or less. Do I have this right?

I are Troll

Select Convert(DECIMAL(4,2), 123.4)

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