Answer Posted / g2

create table Table1(trowid int not null, tname varchar(100))

insert into table1(trowid, tname) values(1, 'G2')
go 100

declare @row int;
set @row= (select count(*) from table1)
set @row=@row-1
set rowcount @row
delete from table1 -- You can put here conditions with all
the columns also
set rowcount 0
go

How we can compare two database data?

998

---

Explain system views?

1133

---

What does null mean?

1053

---

What is partition in sql server?

1093

---

What is DCL?

1104

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1196

---

What are number line correlation administrators will use while working with a subquery?

1217

---

What is the maximum size of column in sql server?

944

---

Equi join and non equi join is possible with sql server?

1096

---

What is the maximum rows in sql server table?

964

---

optimization techinques

2721

---

How adventureworkslt tables are related?

984

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1081

---

What is inner join? Explain with an example?

1286

---

What do you understand by mirroring and mention the advantages of the mirroring?

1116

---