Answer / arunkumar2visit

create trigger trigger_name
on tablename
for update
as
if update(col_name)
begin
raiseerror('cannot update column name',16,1)
rollback trac
end

Answer / prasad237

create trigger trigger_name1
on emp
for update
as
begin
if update(ename)
begin
begin tran
raiserror('cannot update column name',16,1)
rollback tran
end
else
print 'table updated'

end

What is the difference between having clause and where clause in sql server?

0 Answers  

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What is user-defined function?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

Do you have any idea about the tcl commands?

0 Answers  

---

Do you know what is openxml in sql server?

0 Answers  

---

Define Unique Key?

0 Answers   HCL,

---

What is use of except clause?

0 Answers  

---

what is unique and xaml nonclustered index

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---

What are ddl triggers and types of ddl trigger?

0 Answers  

---