Jun 05, 2020, 09:31 PM

News:

Choose a design and let our professionals help you build a successful website   - ITAcumens


@@DBTS

Started by sukishan, Aug 19, 2009, 01:35 AM

previous topic - next topic
Go Down

sukishan

@@DBTS
Returns the value of the current timestamp data type for the current database. This timestamp is guaranteed to be unique in the database.

Syntax
@@DBTS

Return Types
varbinary

Remarks
@@DBTS returns the current database's last-used timestamp value. A new timestamp value is generated when a row with a timestamp column is inserted or updated.

Examples
This example returns the current timestamp from the pubs database.

USE pubs
SELECT @@DBTS
A good beginning makes a good ending

pradeep prem

dbts has data type for the current database

they have syntax and return type with best example

this gives us with best explanation with this website easily get detail

Go Up
 

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name:
Email:
Verification:
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview
IT Acumens Web Designing Chennai | GinGly :: Build your Personal Website | CineBuzz :: Cinema News | My Kids Diary :: Kids Memories Writing :: Book Website @ 349 Rs monthly
Copyright 2005 - 2020 :: IT Acumens :: All Rights Reserved. :: Sitemap
ITAcumens Discussion Forum with 2 lakhs post running for 15 years - Powered by IT Acumens Dedicated Server