Login
sententia
Home
Blog
Blog - Tech / Database / SqlServer
Home
/ Blog
Search within the list:
All Dates
From Last 24 Hours
From Last Week
From Last Month
From Last 60 days
Most Recent
Most Popular
Last Commented
Find invalid objects in your databases
Jul 19 at 6:58am |
0 comments
Exception Handling in SqlServer Trigger to allow base table transaction to commit but handle the error
Dec 02 at 8:06am |
0 comments
I'm very familiar with Oracle and I'm trying to find the comparable code in SqlServer world. I think I'm confusing myself with the need or not for SET XACT_ABORT ON or BEGIN TRAN or ...
Basically, I am putting a trigger on a base table 'mytable' that upon an insert or update on mytable, to copy two values to another table 'mynewtable'. I believe I understand how to handle that aspect but want to add error handling such that if the trigger logic fails for whatever reason, I want the insert into the base table 'mytable' to commit regardless and we write a message to another table 'myerrortable'.
Trying to find any solutions on this was onerous.
SqlServer Nulls .vs. Empty Strings
Jun 02 at 3:41pm |
0 comments
Coming from an Oracle world, a NULL and '' are evaluated the same by null functions. Not true with SqlServer based on my searches ...
Using @@Rowcount to determine the number of rows affected by a Sql statement
Jun 02 at 2:57pm |
0 comments
Extending my knowledge on SqlServer. I had a need to log the number of rows I was manipulating and found this article ...
Stored Procedure look up its own name via T-SQL vs hardcoding (@@PROCID)
May 27 at 12:51am |
0 comments
Instead of hardcoding the name of a stored procedure when you are trying to run some DDL that need that value ...
Catch Sql Server Error Message
May 27 at 12:47am |
0 comments
The following code example shows a SELECT statement that generates a divide-by-zero error. Along with the error message, information that relates to the error is returned.
Calendar
<
October 2024
>
>>
Sun
Mon
Tue
Wed
Thu
Fri
Sat
>
29
30
1
2
3
4
5
>
6
7
8
9
10
11
12
>
13
14
15
16
17
18
19
>
20
21
22
23
24
25
26
>
27
28
29
30
31
1
2
>
3
4
5
6
7
8
9
Show All
Archives
October 2024
(1)
May 2024
(3)
March 2024
(2)
July 2023
(1)
May 2023
(1)
April 2023
(1)
February 2023
(1)
January 2023
(1)
December 2022
(1)
November 2022
(2)
October 2022
(2)
March 2022
(3)
December 2021
(2)
October 2020
(1)
September 2020
(1)
July 2020
(1)
April 2020
(1)
December 2019
(2)
October 2019
(1)
July 2019
(1)
June 2019
(2)
May 2019
(1)
April 2019
(2)
March 2019
(1)
February 2019
(2)
January 2019
(1)
August 2018
(1)
July 2018
(1)
March 2018
(1)
October 2017
(1)
September 2017
(1)
March 2017
(1)
January 2017
(2)
December 2016
(1)
November 2016
(1)
October 2016
(1)
March 2016
(1)
February 2016
(3)
November 2015
(1)
October 2015
(2)
March 2015
(2)
January 2015
(2)
December 2014
(1)
July 2014
(2)
June 2014
(2)
December 2013
(1)
August 2013
(2)
May 2013
(1)
April 2013
(1)
March 2013
(1)
February 2013
(3)
January 2013
(3)
December 2012
(6)
October 2012
(1)
September 2012
(1)
August 2012
(4)
June 2012
(10)
April 2012
(6)
December 2011
(5)
November 2011
(11)
October 2011
(2)
September 2011
(5)
August 2011
(1)
July 2011
(5)
June 2011
(10)
May 2011
(10)
Show All
Categories
Automotive (13)
Electronics (0)
GPS (0)
TomTom (1)
Tablet (0)
Toshiba (0)
Thrive (3)
WiFi (1)
MiniUsb (2)
HomeItems (0)
SolidSurface (1)
Miscellaneous (7)
Tech (10)
ActiveDirectory (1)
Applications (11)
Carbonite (2)
Microsoft (1)
Excel (2)
Outlook (4)
Publisher (1)
VisualStudio (0)
PaintShop (1)
ScreenCapture (1)
Database (2)
Access (3)
Oracle (12)
SqlServer (6)
Operating Systems (0)
Windows10 (6)
Android (3)
Vista (5)
W2008 (3)
Win7 (8)
Phone (1)
iPhone (5)
Tibco (15)
Web (5)
CMS (0)
InsiteCreation (1)
CodeCharge (1)
ColdFusion (10)
DotNet (2)
IE (3)
IIS (1)
ISPs (1)
Javascript (6)
Travel (4)
Hiking (1)
All Categories
Subscribe
Email / Username:
Password:
Remember me.
Forgot your password?