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 each E-R model constructs can be mapped to the relational model?

1005

---

How will you monitor replication latency in transactional replication? : sql server replication

1149

---

How can I tell if sql server is 32 or 64 bit?

966

---

What is change data capture (cdc) feature?

1071

---

Where are SQL server users names and passwords are stored in sql server?

1273

---

What is the default fill factor value?

1082

---

What is the syntax for encrypting a column in SQL Server?

1123

---

How to change parameter value inside the report?

164

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

1047

---

What is rank function?

1034

---

What the different types of Replication and why are they used?

1071

---

What is data compression?

1014

---

What is after dml trigger?

1022

---

Explain the xml support sql server extends?

1043

---

What is trigger in salesforce?

984

---