Answer Posted / sandeep rana

create table tmp_t
(
aa varchar2(50),
bb varchar2(50)
)


--insert into tmp_t values('1','5')


select * from tmp_t

update tmp_t set aa=bb , bb=aa

What is the function of sql server agent windows service?

1082

---

What is public role in sql server?

1141

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2511

---

what's the difference between delete table and truncate table commands? : Sql server database administration

972

---

How do I manually uninstall an instance of sql server 2016?

1026

---

What is a derived table?

922

---

Explain syntax for viewing trigger?

913

---

Do you know what are various aggregate functions that are available?

1112

---

SQL Server Architecture ?

2443

---

What is measure group, measure? : sql server analysis services, ssas

1000

---

How do I find query history in sql server?

935

---

What is sqlcmd?

1036

---

Can we add our custom code in ssis?

979

---

What protocol does sql server use?

935

---

Is a primary key unique?

986

---