What is the Magic Tables in Sqlserver2000?
Answer Posted / ashish sharma
create table uname
(
id int,
uname varchar(10)
)
create trigger insert_Uname
on uname
for insert
as
declare @nm varchar(10)
select @nm = uname from inserted
print @nm
so when we insert any record in the above table
the username will be get printed.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
How to maintain the relation between two tables in ADO.NET?
differance between ADO vs ADO.Net?
What is dao and ado?
how Sequence to connect and retrieve data from database using dataset?
What is ado.net components?
Describe ado.net object model in detail.
What is the namespaces being used to access oracle database?
What is the difference between Command and CommandBuilder object?
How would you connect to database using .NET?
How to store data in memory?
What is data reader in ado.net?
Why do we need ado.net?
What is difference between connected and disconnected architecture in ado.net?
What is the maximum pool size in ado.net connection string?