SQL Server Tips Archives - Page 2 of 2 - All Things DotNetAll Things DotNet
  • Subscribe to this RSS feed
  • Receive updates as soon as they are posted.

SQL Server Tips Category

September 14 , 2010 | | In: SQL Server, SQL Server Tips

SQL Statements followed by Semi-colon

You might see some examples on the net in which a semi-colon is used as a separator between multiple sql statements. This is still a requirement in some databases, but not generally, in SQL Server or MS Access. It can be used and recognized, but it is not necessary in most cases. In one case, […]

August 25 , 2010 | | In: SQL Server, SQL Server Tips

Get a Week’s Start and End Dates

To be able to use any date, and based on that date, get the start (Sunday) and end (Saturday) dates, use the following T-SQL:

All Things DotNet Discussed – Winforms/ASP.Net/SharePoint/WPF

If you find this site helpful,
please donate to help keep it online and free

Code 'n' Sprox   DreamTemplate - Web Templates

Follow us on Twitter

Follow AllThingsDotNet on Twitter

Test - The Name: 6936