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

What are the five characteristics of good data?

869

---

Describe in brief databases and sql server databases architecture.

944

---

What is xml datatype?

1035

---

What are the disadvantages of using the stored procedures?

1019

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

135

---

What are distinctive joins find as a part of sql?

912

---

Can you type more than one query in the query editor screen at the same time?

955

---

How much space does sql server 2016 take?

909

---

What is exporting and importing utility?

1018

---

How to optimize stored procedures in sql server?

1125

---

What is role playing dimension with two examples? : sql server analysis services, ssas

954

---

What are the different Topologies in which Replication can be configured?

1120

---

what is difference between NULL and ISNULL in SQL Server 2008?

967

---

How to drop existing indexes in ms sql server?

1015

---

Difference between uniqe index and uniqe constraint?

918

---