Database objects

External Article

Painless Refactoring of SQL Server Database Objects

  • Article

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.

2015-04-08

11,414 reads

Blogs

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

By

I’ve had a Dropbox account for years. Like a lot of people, I started...

KDA: Echoes of Deception - Case 4

By

Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...

EightKB 2026 – Schedule and Registration

By

Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...

Read the latest Blogs

Forums

BCA KCU BLITAR Telp/WA:0817839777

By R4nt4u

Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111

BCA KCU DIPONEGORO Telp/WA:0817839777

By layanan_Bca88

Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241

BCA KCU JOMBANG Telp/WA:0817839777

By m4rt1n4

Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415

Visit the forum

Question of the Day

Displaying Money

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros

See possible answers