LutzM (8/10/2014)

---

Is it as annoying for you as it is for me to see all those spam posts?

Today (Sunday, August 10th), 22 out of 36 posts were plain spam. All...

WELCOME HOME

I am sure all the site users appreciate the help/knowledge it/that has been...

Tallboy (7/19/2014)

---

HI, I'm using sql server 2008 express and VB.net 2010

I have a database that records an employees personal details.

But I have to develop some way for recording changes to...

Reported as SPAM

Reported as SPAM

+1

Use the function DATEDIFF ( datepart , startdate , enddate ) it is in BOL (Books On Line) if you need to see examples of its use

With the little data you have posted ... use Books on Line and check the use of the BETWEEN statement

From Books on Line:

test_expression BETWEEN begin_expression AND end_expression

Rather simple question, but a Nice question -

Reported as SPAM

You can add user defined error messages to your system by using error message numbers greater than 50,000. To learn how to do this please read.

http://www.techrepublic.com/blog/the-enterprise-cloud/define-custom-error-messages-in-sql-server-2005/390/

You may find what you are looking for in the following:

http://support.microsoft.com/kb/321686

+1

Interesting question

This works for me

BEGIN TRY

CREATE TABLE [dbo].[TestTable]

(

ID INT NOT NULL PRIMARY KEY

)

RAISERROR('Everything is OK!', 5, 1)

END TRY

BEGIN CATCH

RAISERROR ('There was a problem!',0,0)

END CATCH