Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock a Table Column For Updating?

Status
Not open for further replies.

nomi2000

ISP
Feb 15, 2001
676
CA
dear fellow progarmmers
Is it possible to Lock a table column for updating means once i insert the row in the table i don't want anyone to update a certain column in that row.
b) secondly is it posssible to behave a column as toggel say i have a bolean column and i want only 1 value to be true at a time
Regards
Nouman
 
dear
i got it ...i think this is the most answeable thread for me atleast :) thanx for the help...terry or bperryt there is one q regardign ENCRYPTION do i have to make SQL script to alter the objects so it came back to its original positions
Thanks in advance
Regards
Nouman
 
First, I just want to underline or repeat what Terry mentioned earlier: Make sure you have script backup copies, probably as text files, of your stored procedures BEFORE you encrypt them.{/b]

re: your question.
The answer is yes, if I understand you correctly.

If you create your procedure with:
CREATE PROCEDURE MyProc
WITH ENCRYPTION
as
blah, blah, blah

..then the SP is encrypted.


Then later, if you do
ALTER PROCEDURE MyProc
as
blah, blah, blah

....then the encryption is gone (removed as the SP is updated.)


If you were altering your SP, but wanted it to stay encrypted, then you of course would do:
ALTER PROCEDURE MyProc
WITH ENCRYPTION
as
blah, blah, blah

------------------
 
thanks bperry & terry
i have got the things which i want,thanx for ur help
I am here now closing this thread :)
Regards
Nouman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top