Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Condition in SQL

Author  Topic 

saidev
Posting Yak Master

101 Posts

Posted - 2006-07-14 : 15:33:02
Hi Guys
I have a table called EMP, Here is the Fields

ID TempID

1 0
2 0
3 0
4 0
5 0
6 1
7 2
8 3
9 4
10 5

If ID = TempID i,e 1 = 1 then i should not allow the user to update this table. how can we check this condition in Sql Query. can you guys help me with the query.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-14 : 15:52:23
Duplicate:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68949

How about posting a question in the other thread that you started with this same thing.

Tara Kizer
Go to Top of Page
   

- Advertisement -