Database

sindhuan wrote:

Is this the right way to do??

dc.users.InsertOnSubmit("us");

dc.users.InsertOnSubmit(us);

using (MyDataContext dc = new MyDataContext())
{
    var userName = (from u in dc.tblUsers
                    where u.Id = someId
                    select u.UserName).FirstOrDefault();


    user us = new user
    {
        Date = DateTime.Now,
        name = userName
    };

    try
    {
        dc.users.InsertOnSubmit(us);
    }
    catch(Exception e)
    {
        // Handle exception here
    }
}

CREATE TRIGGER tr_trigtest ON trigtest FOR INSERT, UPDATE, DELETE
AS

DECLARE @bit INT ,
       @field INT ,
       @maxfield INT ,
       @char INT ,
       @fieldname VARCHAR(128) ,
       @TableName VARCHAR(128) ,
       @PKCols VARCHAR(1000) ,
       @sql VARCHAR(2000), 
       @UpdateDate VARCHAR(21) ,
       @UserName VARCHAR(128) ,
       @Type CHAR(1) ,
       @PKSelect VARCHAR(1000)
       

--You will need to change @TableName to match the table to be audited
SELECT @TableName = 'trigtest'

-- date and user
SELECT         @UserName = SYSTEM_USER ,
       @UpdateDate = CONVERT(VARCHAR(8), GETDATE(), 112) 
               + ' ' + CONVERT(VARCHAR(12), GETDATE(), 114)

-- Action
IF EXISTS (SELECT * FROM inserted)
       IF EXISTS (SELECT * FROM deleted)
               SELECT @Type = 'U'
       ELSE
               SELECT @Type = 'I'
ELSE
       SELECT @Type = 'D'

-- get list of columns
SELECT * INTO #ins FROM inserted
SELECT * INTO #del FROM deleted

-- Get primary key columns for full outer join
SELECT @PKCols = COALESCE(@PKCols + ' and', ' on') 
               + ' i.' + c.COLUMN_NAME + ' = d.' + c.COLUMN_NAME
       FROM    INFORMATION_SCHEMA.TABLE_CONSTRAINTS pk ,

              INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
       WHERE   pk.TABLE_NAME = @TableName
       AND     CONSTRAINT_TYPE = 'PRIMARY KEY'
       AND     c.TABLE_NAME = pk.TABLE_NAME
       AND     c.CONSTRAINT_NAME = pk.CONSTRAINT_NAME

COALESCE(@PKCols + ' and', ' on')

WHERE ISNULL(@PKCols, '') <> ''

case 
    when instr(mystring, ' and ') > 0 then substr(mystring, 0, instr(mystring, ' and ')-1)
    else mystring 
end as string1
case
    when instr(mystring, ' and ') > 0 then substr(mystring, instr(mystring, ' and ') + length(' and '))
    else null 
end as string2

MSDN[^] states:

Is a data type that exposes automatically generated, unique binary numbers within a database. timestamp is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes. The timestamp data type is just an incrementing number and does not preserve a date or a time. To record a date or time, use a datetime data type.

Bastard Programmer from Hell

LAPEC wrote:

DataTable dt = myConnection.GetSchema("Tables"); //Get list of user tables

LAPEC wrote:

//DataGridMenuTables.ItemsSource = dt.DefaultView;

LAPEC wrote:

dataRow["FoodMenu"].ToString()

davood_b wrote:

What database system Babylon use?

davood_b wrote:

for writing a dictionary like Babylon?

davood_b wrote:

What is the best,simple and quick database

Eddy Vluggen wrote:

a simple local data lookup

davood_b wrote:

What is the best

davood_b wrote:

simple

davood_b wrote:

database for writing a dictionary like Babylon?

davood_b wrote:

What database system Babylon use?

Bastard Programmer from Hell