Hello,

Can we do this through Transact SQL?

Try this....

SELECT CAST(DATEPART(hh, GETDATE()) AS VARCHAR(2)) + ':' + CAST(DATEPART(mi, GETDATE()) AS VARCHAR(2))+ ':' + CAST(DATEPART(ss, GETDATE()) AS VARCHAR(2))+ ':' + CAST(DATEPART(ms, GETDATE()) AS VARCHAR(3))

Result

------------

6:56:29:803

(1 row(s) affected)

Regards

CK Shaiju.

Why can't you use a user defined data type for this..??

Just try it...Execute this script in Query Analyser.

or u can create all these things mannually.

/****************************************************************************/

/* Creating user defined datetype */

EXEC sp_addtype...

Very nice article, I always like these naming conventions... to be a standard in always...

By the way one question, Why you used the trigger name(tr) and index names(IDX) at the...