What if you print the code and execute it?

I've actually never been there... maybe when I stopped in the USA.

"But what if there isnt any date column in the table. All i need to check is the number of rows inserted in last 1 hour."

Declare @T1 Table (id int Identity(1,1) not null primary key clustered, dude tinyint null)

Declare @T2 Table (id int Identity(3,1) not null primary key clustered, dude tinyint null)

Insert into @T1 (Dude)...

If you want a specific sort order you MUST use order by. If you also need to use top use this syntax :

Select top 100 percent Cols from...

Looks like I'm not the only guy who saw and remembers that film .

It takes a log explorer to do that (assuming recovery mode is set to full). There are a few reviews on this site for such products.

Declare @ExecSQL as varchar(1000)

Declare @Dbname as varchar(50)

set @DbName = 'Joe_LeninL'

set @ExecSQL = '

BACKUP DATABASE ' + @DbName + ' TO DISK = ''K:\User_Databases\CFT_dbs\Data\' + @DbName + '\' + @DbName +...

This is something that you need to code correctly to avoid errors. Just run the delete before the update and you'll be fine.... and make sure you update the...

Select Cols from dbo.YourTable where DateCol between DateAdd(hh, -1, GetDate()) and GetDate()

Check this out :

Generate insert statements

Also what do you need to present on that form??

Why would there have an error in the trigger?? This is a simple insert into from inserted/deleted with change type hardcoded in the triger and the time_stamp set with...

You'd have to run all this code under dynamic sql with exec (@DynamicCode)

I can only suggest you google : Sybase raiserror

Good luck.

This is the most usefull english help I can find :

http://msdn.microsoft.com/library/?url=/library/en-us/acdata/ac_8_con_05_3f76.asp