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 difference between writing data to mirrored drives versus raid5 drives

873

---

How many types of triggers are there?

1004

---

Do you know what are the steps to process a single select statement?

920

---

What stored by the msdb? : sql server database administration

954

---

What is sql server replication? : sql server replication

925

---

plss anybody specify tha constrian management system in dbms

2082

---

How would we use distinct statement? What is its use?

1024

---

What are the different types of lock modes in sql server 2000?

884

---

Define cursor locking

948

---

Why truncate is ddl?

1030

---

Tell me what are the essential components of sql server service broker?

887

---

Explain how you can configure a running aggregate in SSRS?

155

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1070

---

What is the difference between TRUNCATE and DROP?

1067

---

What is query parameter in ssrs?

143

---