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

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1037

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

1006

---

What is the use of toad or sqldbx.?

1156

---

What are exact numeric data types in ms sql server?

1082

---

Where do you find the default Index fill factor and how to change it?

1063

---

What is bulkcopy in sql?

948

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1947

---

Explain an automatic checkpoint

977

---

What is the difference between mysql and mysqli?

1206

---

What is data source in connection string?

913

---

Mention the uses of stored procedures.

973

---

What are “phantom rows”?

1666

---

What does dml stand for?

952

---

What is SQL Azure?

107

---

How do I create a stored procedure in dbml?

1011

---