<div>
<div class="content wysiwyg-content">
I'm using mssql 2005...<br />
<br />
When script works fine but the problem is i getting o/p of one as it displays Jul 18 2008 12:00, it should be 7/18/2008 only.....Also amount field display as &nbsp;10.0000, only 10.00 needed...<br />
<br />
Please dont give any links to search...<br />
<br />
Thanks in advance...
</div>
</div>


I'm using mssql 2005...

When script works fine but the problem is i getting o/p of one as it displays Jul 18 2008 12:00, it should be 7/18/2008 only.....Also amount field display as  10.0000, only 10.00 needed...

Please dont give any links to search...

Thanks in advance...

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

fix