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'

Tell me what do you understand by a view? What does the with check option clause for a view do?

997

---

What is the parse query button used for?

1015

---

How many columns can exist together per table?

1140

---

What are the dmvs?

999

---

Where the sql logs gets stored? : sql server database administration

945

---

How to drop existing views from a database in ms sql server?

1079

---

What is the language structure to add a record to a table?

1009

---

Can sql servers link to other servers like oracle?

827

---

What are the tables in sql?

1073

---

Mention the different authentication modes in sql server.

1018

---

Why do you need a sql server?

1081

---

Tell me in brief how sql server enhances scalability of the database system?

974

---

Explain left outer join and right outer join?

1013

---

What are the diifferences between the ms sql server vs mysql?

1157

---

How can windows applications connect to sql servers via odbc?

1110

---