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 does null mean?

978

---

What are the system database in sql server 2008?

1024

---

Explain the relational database management system (rdbms)?

1081

---

SQL Server Architecture ?

2439

---

How to move database physical files in ms sql server?

1019

---

what is difference between view and Dip.

2403

---

What is the difference between dropping a database and taking a database offline?

1164

---

How to view existing indexes on an given table using sp_help?

1121

---

How do we synchronize On-Premise SQL server with SQL Azure?

120

---

What is a select query statement in ms sql server?

1059

---

Explain can SSRS reports Cache results?

158

---

What is cdc in sql server?

989

---

What is a cache in ssrs?

134

---

How to rebuild indexes with alter index ... Rebuild?

1112

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

1072

---