<div>
If you want the value inserted automatically when adding a record to the table then you need to set the default property:<br />
<br />
ALTER TABLE myTable ADD &nbsp;DEFAULT (getdate()) FOR myColumn
</div>


If you want the value inserted automatically when adding a record to the table then you need to set the default property:

ALTER TABLE myTable ADD  DEFAULT (getdate()) FOR myColumn

<div>
i know this .. i want specific format in default datetime &nbsp; like this .. &nbsp;DEFAULT &nbsp;getdate(), 'yyyy/MM/dd hh:mm:ss tt', 'en-US' ); ()
</div>


i know this .. i want specific format in default datetime   like this ..  DEFAULT  getdate(), 'yyyy/MM/dd hh:mm:ss tt', 'en-US' ); ()

<div>
I've requested that this question be deleted for the following reason:<br />
<br />
i have found the solution from sql server ebook
</div>


I've requested that this question be deleted for the following reason:

i have found the solution from sql server ebook

<div>
If you have found a solution, post it so others can benefit and then accept your own answer. Don't delete the question.
</div>


If you have found a solution, post it so others can benefit and then accept your own answer. Don't delete the question.

<div>
The date on sql server will be stored as Data type : datetime <br />
than if you want to convert it to another format you should choose a function to convert to your format and the link below <a href="http://www.sql-server-helper.com/tips/date-formats.aspx" rel="ugc">http://www.sql-server-helper.com/tips/date-formats.aspx</a><br />
help you in choosing format type.
</div>


The date on sql server will be stored as Data type : datetime
than if you want to convert it to another format you should choose a function to convert to your format and the link below http://www.sql-server-helper.com/tips/date-formats.aspx [http://www.sql-server-helper.com/tips/date-formats.aspx]
help you in choosing format type.

<div>
<div class="content wysiwyg-content">
sql DATETIME DEFAULT &nbsp;getdate(), 'yyyy/MM/dd hh:mm:ss tt', 'en-US' ); ();<br />
<br />
<br />
<br />
i want to make a default date when i insert new record in database <br />
only i need to insert required field like username and password and automatically the datetime will be insert as default in each insertion &nbsp;<br />
<br />
how i can do it ? in sql
</div>
</div>


sql DATETIME DEFAULT  getdate(), 'yyyy/MM/dd hh:mm:ss tt', 'en-US' ); ();



i want to make a default date when i insert new record in database 
only i need to insert required field like username and password and automatically the datetime will be insert as default in each insertion  

how i can do it ? in sql

MS SQL

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.