Re: Enter Today's Date in SSMS Open Table Grid View
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Sun, 1 Jul 2007 11:32:21 +0000 (UTC)
pwc (pcrickman@xxxxxxxxxxx) writes:
What date constants are available for entering today's date in a
datetime column after using the Open Table command within SSMS? I
have tried GETDATE() and CURRENT_TIMESTAMP, but neither worked.
You look at your watch, and the type what you see. Open Table is a very
simple data-entry tool.
If you don't want to consult your watch, you will have to write an INSERT
or an UPDATE statement instead.
Another question - if I open the samed named table in two databases to
compare the data contents using Open Table, the tab labels only
display the table name and are not fully qualified. Is there an SSMS
option to show the table labels fully qualified.
Yes, it's called SP2. That is, they've changed this in SP2 so that the
database name is included.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Prev by Date: Enter Today's Date in SSMS Open Table Grid View
- Next by Date: RE: 2005 Management Studio in slow motion?
- Previous by thread: Enter Today's Date in SSMS Open Table Grid View
- Next by thread: RE: 2005 Management Studio in slow motion?
- Index(es):
Relevant Pages
|
