Answer Posted / dipak patil

Create Table emp
(
dbID int NOT NULL IDENTITY (1,1) PRIMARY KEY,
customerNumber NVARCHAR(100) ,
Name Varchar(100)
)
GO
----------------------------------------
Create Proc Usp_InsertRecord
@EmpName Varchar(10)
As
BEGIN
Declare @MAXValue Varchar(Max),@intValue Integer
SET @MAXValue='0'
SELECT TOP 1 @MAXValue=ISNULL(customerNumber,0) From emp Order by dbID DESC
Set @intValue=Convert(Integer,Replace(@MAXValue,'Gt',''))+1
SET @MAXValue='GT' + right('0000' + convert(varchar(10), @intValue), 4)

Insert Into Emp(customerNumber,Name) Values(@MAXValue,@EmpName)
END
----------------------------------------
-- Exec Usp_InsertRecord 'RAM'

What is the sql case statement used for? Explain with an example?

992

---

Are semicolons required at the end of sql statements in sql server 2005?

995

---

What is @@rowcount in sql?

1005

---

Do you know the different ddl commands in sql?

1054

---

What is logon trigger?

1098

---

How many types of cursor type are there?

1090

---

What is the meaning of sql server?

986

---

What do you think of this implementation? Can this be implemented better?

945

---

Does sql server 2000 clustering support load balancing?

979

---

What is normalization and what are the advantages of it?

985

---

What are locks in sql?

984

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

---

What is the purpose of optimization?

998

---

Define compound operators?

916

---

A trigger can reference objects outside the current database? State true or false.

1010

---