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

How to generate create view script on an existing view?

742

---

What is the difference between osql and query analyzer?

723

---

Difference between drill down and drill through report.

726

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

731

---

How secure is sql server database?

691

---

---

What is the difference between char, varchar and nvarchar?

756

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2267

---

What is user-defined scalar function?

722

---

Do you know what is lock escalation?

770

---

What is a view in sql?

758

---

What are the operating modes in which database mirroring runs?

816

---

Do you know what is a linked server in sql server?

714

---

What is the name of reporting services config file and what’s it’s used for?

119

---

What are different replication agents and what's their purpose? : sql server replication

743

---

Can sql server be linked with other servers like oracle?

700

---