SQL Server 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 Category

Scenario: Your new table doesn’t exist, but you have a complicated (or not) TSQL statement that you’d like to run and have it all inserted into a new table.

If you ever get this error, whether it is in a SharePoint app or ASP.Net app, or directly in SQL Server, never delete the files directly. This will most likely cripple your application. Instead, truncate the database transaction logs directly from SQL Server Management Studio.

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

DateName Function in T-SQL

As you probably know, the month function runs against a date and returns numerically, giving you the number of the month of the year. For instance, if your date is in August, it will return an 8. If you want the name of the month, you need to use DateName, which uses 2 parameters, including […]

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