getting the current database name

Hi.
I'm making some stored procedures in transact sql, but at the momment i'm
needing a command which can help me getting the current database name.
In adavance, thanks a lot.
Eddy.
DB_NAME()
Andrew J. Kelly SQL MVP
"Eddy Yepes" <Eddy Yepes@.discussions.microsoft.com> wrote in message
news:AE7173F4-226C-4579-B785-25E2B8F820FA@.microsoft.com...
> Hi.
> I'm making some stored procedures in transact sql, but at the momment i'm
> needing a command which can help me getting the current database name.
> In adavance, thanks a lot.
> Eddy.

getting the current database name

Hi.
I'm making some stored procedures in transact sql, but at the momment i'm
needing a command which can help me getting the current database name.
In adavance, thanks a lot.
Eddy.DB_NAME()
Andrew J. Kelly SQL MVP
"Eddy Yepes" <Eddy Yepes@.discussions.microsoft.com> wrote in message
news:AE7173F4-226C-4579-B785-25E2B8F820FA@.microsoft.com...
> Hi.
> I'm making some stored procedures in transact sql, but at the momment i'm
> needing a command which can help me getting the current database name.
> In adavance, thanks a lot.
> Eddy.sql

getting the current database name

Hi.
I'm making some stored procedures in transact sql, but at the momment i'm
needing a command which can help me getting the current database name.
In adavance, thanks a lot.
Eddy.DB_NAME()
Andrew J. Kelly SQL MVP
"Eddy Yepes" <Eddy Yepes@.discussions.microsoft.com> wrote in message
news:AE7173F4-226C-4579-B785-25E2B8F820FA@.microsoft.com...
> Hi.
> I'm making some stored procedures in transact sql, but at the momment i'm
> needing a command which can help me getting the current database name.
> In adavance, thanks a lot.
> Eddy.

Getting system time from SQL

Hi All
Does anyone know how to call the current system time
(using transact) and then write that data into a table?
Thanks
JUPDATE table SET curtime = CURRENT_TIMESTAMP
OR
UPDATE table SET curtime = GETDATE()
Kurt
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:10fc01c3b3a7$32a74840$a001280a@.phx.gbl...
> Hi All
> Does anyone know how to call the current system time
> (using transact) and then write that data into a table?
> Thanks
> J