Most answered questions under tag sql server

0 votes

3 answers

what is the difference between char , varchar and nvarchar in sql?

posted Jul 17, 2014 by Sanjay

+2 votes

2 answers

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

posted May 20, 2017 by Kushal S

0 votes

2 answers

What is main feature of NULLIF Function in SQL?

posted Jul 1, 2015 by Amit Kumar Pandey

+4 votes

2 answers

How sql server know when a query has to compile or not?

posted Jun 23, 2015 by Mohammed Hussain

+2 votes

2 answers

Deleting duplicate rows from a table.

posted Jun 16, 2015 by Manikandan J

+2 votes

2 answers

What are differences between function and stored procedure?

posted Feb 9, 2015 by Shivaranjini

0 votes

2 answers

What is LINQ?

posted Nov 25, 2014 by Roshan

+1 vote

2 answers

What are Magic tables in SQL Server?

posted Nov 22, 2014 by Vrije Mani Upadhyay

+1 vote

2 answers

What are the basic functions for master, msdb, model, tempdb databases?

posted Nov 22, 2014 by Vinitha

+1 vote

2 answers

Explain different types of Locks in SQL Server?

posted Nov 22, 2014 by Balu

+1 vote

2 answers

What are the properties of the Relational tables?

posted Nov 22, 2014 by Balu

+1 vote

2 answers

How many types of triggers are there?

posted Nov 18, 2014 by Vinitha

0 votes

2 answers

What are constraints? Explain different types of constraints?

posted Nov 18, 2014 by Roshan

+2 votes

2 answers

What are the difference between primary keys and foreign keys?

posted Nov 14, 2014 by Balu

+2 votes

2 answers

What is the difference between a local and a global variable?

posted Nov 13, 2014 by Roshan

+1 vote

2 answers

How to create recursive query in SQL Server?

posted Sep 26, 2014 by Rahul Singh

+1 vote

2 answers

Difference between clustered and a non-clustered index?

posted Aug 24, 2014 by Deepak Negi

+2 votes

2 answers

How to wite an update query with table joins?

posted Aug 8, 2014 by Khusboo

0 votes

2 answers

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

posted Jul 17, 2014 by Sanjay

0 votes

2 answers

What are COMMIT and ROLLBACK in SQL?

posted Jun 24, 2014 by Deepak Negi

+1 vote

2 answers

How to store listbox selected items into sqlserver?

posted Jun 13, 2014 by Nikita Sehgal

+2 votes

2 answers

SQL SERVER: What is the difference between Fact Table and dimensions?

posted May 12, 2014 by Muskan

+1 vote

2 answers

What is the use of OLAP?

posted Mar 25, 2014 by Vishvachi Tiwari

+1 vote

2 answers

What are the different types of joins and what is the difference between them?

posted Mar 25, 2014 by Vishvachi Tiwari

+1 vote

2 answers

What is a candidate key?

posted Mar 25, 2014 by Vishvachi Tiwari

+2 votes

2 answers

Which tools are available to manage SQL Azure databases and servers?

posted Feb 26, 2014 by Avinash Shukla

+2 votes

2 answers

How can we migrate from SQL server to SQL Azure?

posted Feb 26, 2014 by Avinash Shukla

+10 votes

2 answers

How to export data from Sql Server to MS Excel?

posted Feb 6, 2014 by Asmita Agrawal

+2 votes

2 answers

What Is Transact-SQL Language?

posted Feb 2, 2014 by Mona Sharma

+2 votes

2 answers

What is the Difference between a Function and a Stored Procedure?

posted Jan 21, 2014 by Vishvachi Tiwari

+2 votes

2 answers

Pivot and Unpivot in SQL Server??

posted Jan 19, 2014 by Vishvachi Tiwari

+3 votes

2 answers

Left and Right functions in SQL?

posted Jan 13, 2014 by Atul Mishra

+6 votes

2 answers

What is OpenQuery in SQl server

posted Dec 19, 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

+5 votes

2 answers

SQL Server: What does the NOLOCK query hint do?

posted Nov 18, 2013 by Atul Mishra

+6 votes

2 answers

Temp tables in SQL server?

posted Nov 18, 2013 by Atul Mishra

+2 votes

2 answers

What is COAlESCE in SQL Server and how it is different from ISNULL function??

posted Oct 7, 2013 by Atul Mishra

+2 votes

2 answers

What is the difference between "IS NULL" and "ISNULL" in SQL Server??

posted Oct 7, 2013 by Jonathan Little

+1 vote

1 answer

SQL: What is main difference between views and cursor?

posted Aug 10, 2017 by anonymous

+2 votes

1 answer

Difference between LEN() and DATALENGTH() in sql server ?

posted Jun 12, 2017 by Rohini Agarwal

+2 votes

1 answer

What is the difference between a View and a Cursor?

posted Jan 13, 2017 by Jdk

–1 vote

1 answer

Write a query to rank employees based on their incentives for a month?

posted Apr 13, 2016 by Jayshree

–1 vote

1 answer

Get Employee ID's of those employees who didn't receive incentives without using sub query ?

posted Apr 13, 2016 by Jayshree

0 votes

1 answer

How to handle “apostrophe in a string” problem in MS SQL Server Insert Command?

posted Mar 29, 2016 by Sathyasree

+1 vote

1 answer

How to dynamically change the executing SQL in a stored procedure in Microsoft SQL Server?

posted Mar 29, 2016 by Sathyasree

+1 vote

1 answer

How to Check Columns name and their types using Store Procedure?

posted Mar 29, 2016 by Sathyasree

0 votes

1 answer

How to Create a Connection to the Data Source Using Sql Server?

posted Mar 24, 2016 by Sathyasree

0 votes

1 answer

How to perform date operations in SQL Sever?

posted Mar 24, 2016 by Sathyasree

0 votes

1 answer

How to Work with ROUND () function in SQL server 2008?

posted Mar 23, 2016 by Jayshree

0 votes

1 answer

How to work with CHARINDEX() funciton in sql server 2008?

posted Mar 23, 2016 by Jayshree