Answer Posted / ganesh dhage

SET is Reserved word in the SQL Server.Basically SET keyword is used for updating the particular record in the database table with some conditions...If i need to change the name of Student from Student table then i can write query like this->
update Student set Stud_Name=Ganesh
where StudID=201 and Email='abcd@pune.com';

What is full outer join in sql server joins?

559

---

How to disable a login name in ms sql server?

581

---

Explain trigger and its types?

604

---

How to create an index on an existing table in ms sql server?

491

---

Explain the difference between primary keys and foreign keys?

503

---

---

What is Command line parameters in PLSQL.?

576

---

List the ways in which dynamic sql can be executed?

630

---

How to edit table in sql server 2017?

502

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

548

---

How to download and install microsoft .net framework version 2.0?

540

---

Can we take the full database backup in log shipping?

529

---

What are sql server procedures?

537

---

What is msdb database? : SQL Server Architecture

524

---

Explain about temporary stored procedure?

514

---

Explain the steps to create and execute a user-defined function in the sql server?

518

---