Most viewed questions under tag sql server

+3 votes

1 answer

In SSRS report can we edit the .rdl code associated with a linked report?

posted Nov 3, 2015 by Shivaranjini

+10 votes

2 answers

How to export data from Sql Server to MS Excel?

posted Feb 6, 2014 by Asmita Agrawal

+3 votes

0 answers

How to convert c # inline queries into stored procedure written in transact sql?

posted May 8, 2014 by Khusboo

+4 votes

1 answer

Debug a Stored Procedure..!!

posted Apr 1, 2014 by Khusboo

+2 votes

2 answers

What is the difference between the RANK() and DENSE_RANK() functions?

posted May 20, 2017 by Kushal S

+1 vote

1 answer

How we can rebuild Master DataBase in SQL Server

posted Mar 31, 2014 by Neeraj Pandey

0 votes

1 answer

Dynamic expressions implementation

posted Aug 5, 2014 by Sachin

+5 votes

1 answer

How to create a CSV file of any table by sql query in sql server?

posted Aug 3, 2015 by Mohammed Hussain

+1 vote

1 answer

How to concatenate multiple rows into a single text string without using loop?

posted Jun 12, 2015 by Shivaranjini

+2 votes

1 answer

Explain the storage models of OLAP?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

Update from one table to another table using SQL Server 2008

posted Jun 19, 2015 by Shivaranjini

+1 vote

1 answer

How to get @@ERROR and @@ROWCOUNT at the Same Time?

posted Sep 4, 2014 by Khusboo

+2 votes

1 answer

What is Collation in context of SQL?

posted Jan 21, 2014 by Vishvachi Tiwari

0 votes

2 answers

What are all differences among delete, drop and truncate in sql?

posted Jul 17, 2014 by Sanjay

+2 votes

2 answers

How can we migrate from SQL server to SQL Azure?

posted Feb 26, 2014 by Avinash Shukla

+3 votes

1 answer

What is difference between View and Materialized view?

posted Jan 24, 2014 by Neeraj Pandey

+1 vote

2 answers

What are the properties of the Relational tables?

posted Nov 22, 2014 by Balu

+1 vote

2 answers

Explain different types of Locks in SQL Server?

posted Nov 22, 2014 by Balu

+1 vote

1 answer

What is the difference between DELETE TABLE and TRUNCATE TABLE commands?

posted Mar 26, 2014 by Vishvachi Tiwari

+2 votes

2 answers

Pivot and Unpivot in SQL Server??

posted Jan 19, 2014 by Vishvachi Tiwari

+2 votes

1 answer

How to read data in a table with "SELECT" statements ?

posted Feb 2, 2014 by Mona Sharma

+5 votes

2 answers

SQL Server: What does the NOLOCK query hint do?

posted Nov 18, 2013 by Atul Mishra

+2 votes

1 answer

What are the Advantages of using CTE?

posted Nov 28, 2014 by Roshan

+4 votes

1 answer

How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements ?

posted Feb 2, 2014 by Mona Sharma

+2 votes

1 answer

How do we synchronize On Premise SQL server with SQL Azure?

posted Feb 26, 2014 by Avinash Shukla

+2 votes

2 answers

What are differences between function and stored procedure?

posted Feb 9, 2015 by Shivaranjini

+1 vote

1 answer

What is denormalization in context of SQLSERVER?

posted Mar 25, 2014 by Vishvachi Tiwari

+2 votes

1 answer

What is RAID and how does it work?

posted Mar 26, 2014 by Vishvachi Tiwari

+4 votes

1 answer

How can we get alternative rows from a table in sql server

posted Dec 24, 2013 by Neeraj Pandey

+4 votes

2 answers

SQL Server: How can we remove duplicate rows from a table

posted Dec 6, 2013 by Neeraj Pandey

+2 votes

1 answer

How to compile any query without executing it in sql server?

posted Jun 15, 2015 by Mohammed Hussain

+6 votes

1 answer

What is exact_abort in SQL Server?

posted Jan 4, 2014 by Atul Mishra

0 votes

2 answers

What is main feature of NULLIF Function in SQL?

posted Jul 1, 2015 by Amit Kumar Pandey

+5 votes

1 answer

What are the advantages and disadvantages of SqlServer Session mode?

posted Dec 11, 2014 by Manikandan J

+3 votes

1 answer

How to save from Listview to MS SQL Server?

posted Mar 5, 2014 by Khusboo

+3 votes

1 answer

What is the significance of NULL value and why should we avoid permitting null values?

posted Oct 23, 2015 by Vrije Mani Upadhyay

0 votes

1 answer

How to Work with QUOTENAME and ASCII Common String functions in SQL server 2008?

posted Mar 21, 2016 by Latha

0 votes

1 answer

What is Replication in SQL Server?

posted Mar 21, 2016 by Latha

+2 votes

1 answer

how to update table from select statement in sql server?

posted Jun 19, 2015 by Shivaranjini

+5 votes

1 answer

User Defined Data Types in SQL Server?

posted Mar 27, 2014 by Muskan

+4 votes

1 answer

Which are new data types introduced in SQL SERVER 2008?

posted Nov 26, 2014 by Manikandan J

+2 votes

1 answer

What are the String types available for a column in SQL?

posted Apr 2, 2015 by Vrije Mani Upadhyay

+2 votes

1 answer

How many replicas are maintained for each SQL Azure database?

posted Feb 26, 2014 by Avinash Shukla

+2 votes

1 answer

What Are the Differences between CHAR and VARCHAR ?

posted Feb 2, 2014 by Mona Sharma

+3 votes

1 answer

What are the three SSRS command-line utilities and their primary functions?

posted Nov 3, 2015 by Shivaranjini

0 votes

1 answer

What command do we use to rename a db, a table and a column?

posted Nov 26, 2014 by Vinitha

+2 votes

1 answer

How to get Distinct records from datatable or dataset?

posted Feb 1, 2016 by Latha

+2 votes

1 answer

What is the difference between WHERE clause and HAVING clause?

posted Jan 19, 2014 by Vishvachi Tiwari

0 votes

1 answer

What is Filestream?

posted Nov 25, 2014 by Balu

+3 votes

1 answer

What is the best way of removing a cursor from SQL procedure if we have large amount of data to process

posted Feb 28, 2014 by Prachi Agarwal