Answer Posted / vijayalakshmi u

Create Table emp
(
dbID int NOT NULL IDENTITY (1,1) PRIMARY KEY,
customerNumber NVARCHAR(100) auto_increment,
Name Varchar(100)
)

Create function CustomerNumber (@id int)
returns varchar(10)
as
begin
DECLARE @ret varchar(10) ;
select @ret='gt' + right('0000' + convert(varchar(10), @id), 4)
RETURN @ret
end


create trigger emp_insert on emp
after insert as
update emp
set
emp.customerNumber = dbo.CustomerNumber(emp.dbID)
from
emp inner join
inserted on emp.dbID= inserted.dbID

What is trigger and different types of Triggers?

1199

---

Can you please explain the difference between function and stored procedure?

1046

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979

---

What is onf in normalization form?

1111

---

How to use column default values in insert statements in ms sql server?

1099

---

How to perform key word search in tables?

1002

---

How to start and end transact-sql statements?

1085

---

What is row_number()?

1050

---

Can a database be shrunk with users active?

1195

---

What is dirty read?

1135

---

Is foreign key unique?

1047

---

How to encrypt data between dialogs?

1168

---

Is the order of columns in the set clause important in ms sql server?

1011

---

What is a cache in ssrs?

138

---

Can sql servers link to other servers?

1136

---