Viewing 15 posts - 1 through 15 (of 3,221 total)
LutzM (8/10/2014)
Today (Sunday, August 10th), 22 out of 36 posts were plain spam. All...
August 10, 2014 at 2:26 pm
WELCOME HOME
We have something special in our little technology niche, and I hope all of you appreciate it.
I am sure all the site users appreciate the help/knowledge it/that has been...
July 21, 2014 at 6:15 am
Tallboy (7/19/2014)
I have a database that records an employees personal details.
But I have to develop some way for recording changes to...
July 19, 2014 at 12:57 pm
Igor Micev (4/27/2014)
Thanks for this new-feature question.Regards,
Igor
+1
April 27, 2014 at 5:36 am
Use the function DATEDIFF ( datepart , startdate , enddate ) it is in BOL (Books On Line) if you need to see examples of its use
April 11, 2014 at 5:51 pm
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
March 25, 2014 at 4:31 pm
Rather simple question, but a Nice question -
March 24, 2014 at 8:24 pm
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.
March 3, 2014 at 7:42 am
You may find what you are looking for in the following:
February 22, 2014 at 2:48 pm
TomThomson (2/19/2014)
Nice question.I sat there for five minutes staring at it looking for the catch, before deciding that there wasn't one.
+1
February 19, 2014 at 6:03 am
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
February 3, 2014 at 6:55 am
Viewing 15 posts - 1 through 15 (of 3,221 total)