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.
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 […]
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, […]
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