Answer / Munnakumar

There are two main types of authentications in SQL Server: Windows Authentication and SQL Server Authentication. Windows Authentication relies on the security principals of the operating system to authenticate users, while SQL Server Authentication uses usernames and passwords stored within the SQL Server instance. When a user attempts to connect to a SQL Server instance using Windows Authentication, the server requests the user's credentials from the operating system, which are then used to determine if the user has access to the database. If the user is authenticated successfully, the connection is established.

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

What stored by the master?

1 Answers  

---

Explain the storage models of OLAP?

1 Answers  

---

Explain the database you used in your final year project?

1 Answers   Wipro,

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

What is user-defined multi-statement table-valued function?

1 Answers  

---

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

---

What is the purpose of the model database?

1 Answers  

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1 Answers  

---

How to execute stored procedure in select statement sql server?

1 Answers  

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

1 Answers  

---

How to check parameter value in stored procedure sql server?

1 Answers  

---