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 is SubQuery in SQL Server 2008

564

---

Explain powershell included in sql server 2008?

617

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

562

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

545

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

572

---

---

What are the rendering extensions of ssrs?

107

---

Tell me about normalization in DBMS.

591

---

What is query and its types?

524

---

What is a DBMS, query, SQL?

583

---

What is difference between Datepart() and Datename() in SqlServer?

730

---

How to find the service pack installed? : sql server database administration

556

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

603

---

Differentiate between ms sql server reporting services vs crystal reports?

497

---

Can sql servers linked to other servers?

552

---

What is a coalesce function?

671

---