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 are cascading parameters in ssrs reports?

218

---

How to use "begin ... End" statement structures in ms sql server?

977

---

What is the purpose of data source?

973

---

List types of tables in SQL Azure?

126

---

How to retrieve error messages using mssql_get_last_message()?

1003

---

What is difference between view and materialized view?

899

---

How much does sql server 2016 cost?

999

---

What are the benefits and tasks of object explorer? : sql server management studio

1129

---

What are the extra roles available in msdb? : sql server security

1097

---

Do you know sql server 2008 introduces automatic auditing?

922

---

What is the need for indexing?

900

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

979

---

What is store procedure? How do they work? When do you use?

900

---

What is table level trigger?

965

---

What is the difference between functions and scalar functions?

1139

---