Solved

Make it NULL by default

Posted on 2009-05-08
5
182 Views
Last Modified: 2012-05-06
For some business reason i have to either avoid values updating a column in a table. I cannot controt the data import, all i am trying to do is make that column to null whatever value it has.. the column should always have null, so either i can avoid the incoming fileds or change it after feed.. so is there any way to do that?
0
Comment
Question by:parpaa
  • 3
5 Comments
 
LVL 13

Accepted Solution

by:
Philip Pinnell earned 250 total points
ID: 24337357
You could have a trigger on update that changes the value back to null whenever an attempted update takes place.
0
 

Author Comment

by:parpaa
ID: 24337388
is there anything else besides this?? this sounds good...
0
 
LVL 13

Expert Comment

by:Philip Pinnell
ID: 24339303
I can't think of another sure way
0
 
LVL 13

Expert Comment

by:Philip Pinnell
ID: 24339343
Thanks
0
 

Expert Comment

by:aangrish
ID: 24339356
As you don't have control over the import, a before insert or update trigger is the way to go. Depending on your database, ensure it fires only on an update to that particular field.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now