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 command would you use to add a column to a table in sql server?

1358

---

Determine when to use stored procedure to complete sql server tasks?

1108

---

What is buffer cash and log cache in sql server?

1189

---

What should be the fill factor for indexes created on tables? : sql server database administration

1180

---

Can you explain powershell included in sql server 2008?

991

---

What is dbcc?

1180

---

What is the difference between seek predicate and predicate?

1108

---

Can group by be used without aggregate functions?

966

---

How to access the inserted record of an event?

1109

---

Do I need a report server to run reports in my application?

170

---

What is sql azure database?

206

---

What stored by the msdb? : sql server database administration

1053

---

Tell me about the approaches which you used to counter the DI problems.

1427

---

What is a derived table?

992

---

Which are the two editions in which SQL Azure database available?

121

---