Most viewed questions under tag sql server

+4 votes

1 answer

How to check if a Constraint exists in Sql server?

posted Nov 3, 2014 by Khusboo

+1 vote

1 answer

Error 1065 'query was empty' in the python script

posted Mar 8, 2014 by Prakash

+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

–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

+2 votes

1 answer

How to generate row number in SQL Without ROWNUM?

posted Jan 19, 2014 by Vishvachi Tiwari

+2 votes

1 answer

INFORMATICA LOADING ERROR

posted Apr 21, 2014 by Madhavi Kumari

+2 votes

1 answer

SQL SERVER: What will happen if TUF file deleted

posted Oct 12, 2013 by Karri Satyanarayana Naidu

+2 votes

1 answer

What is the difference b/w sp_help and sp_helptext ?

posted Jan 23, 2014 by Atul Mishra

–1 vote

1 answer

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

posted Apr 13, 2016 by Jayshree

+2 votes

1 answer

What is the difference between a View and a Cursor?

posted Jan 13, 2017 by Jdk

+4 votes

1 answer

What are the most important database performance metrics, and how do you monitor them?

posted Feb 12, 2015 by Merry

+2 votes

1 answer

What is openxml in sql server?

posted Dec 6, 2013 by Anuj Mishra

+3 votes

0 answers

WHICH ONE WILL BE FASTER IN SQL SERVER: INSERTING ONE MILLION ROWS OF DATA, OR UPDATING ONE MILLION ROWS OF DATA?

posted Mar 31, 2014 by Prachi Agarwal

+4 votes

1 answer

SQL: How to SELECT * INTO [temp table] FROM [stored procedure]

posted May 28, 2014 by Khusboo

+1 vote

1 answer

What does mean of locking granularity in SQL Server?

posted Mar 6, 2015 by Amit Kumar Pandey

+3 votes

1 answer

How to save specific html portion into pdf using asp.net?

posted Dec 4, 2013 by anonymous

+3 votes

1 answer

What is difference between rebuild and reorganize the indexes in SQL Server?

posted Apr 3, 2014 by Neeraj Pandey

+2 votes

2 answers

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

posted May 12, 2014 by Muskan

+2 votes

1 answer

What is normalization? What are different types of normalization?

posted Mar 25, 2014 by Vishvachi Tiwari

+6 votes

1 answer

How to change multiple column datatype in SQL Server single query.

posted Apr 1, 2015 by Khusboo

+3 votes

1 answer

I want to append output data from a query into an existing file, which command prompt tool will help me?

posted Mar 29, 2014 by Neeraj Pandey

+3 votes

1 answer

What is difference between derived table and sub query in sql server

posted Jan 24, 2014 by Neeraj Pandey

0 votes

1 answer

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

posted Mar 29, 2016 by Sathyasree

+6 votes

2 answers

What is OpenQuery in SQl server

posted Dec 19, 2013 by Neeraj Pandey

+3 votes

1 answer

What is the difference between update lock and exclusive lock in SQL Server?

posted Oct 16, 2015 by Shivaranjini

0 votes

0 answers

How to call sql server stored procedure in codeigniter?

posted Jun 21, 2016 by anonymous

0 votes

1 answer

How to perform date operations in SQL Sever?

posted Mar 24, 2016 by Sathyasree

+3 votes

1 answer

what is cardinality and what is selectivity in sql server

posted Jan 24, 2014 by Neeraj Pandey

+3 votes

1 answer

What is the meaning of lock escalation and why/how to stop this?

posted Mar 31, 2014 by Prachi Agarwal

+1 vote

1 answer

How to convert multiple rows into single row in iformatica for large volume of data, need best solution

posted Mar 28, 2014 by Pooja Bhanout

+2 votes

1 answer

Joining null in SQL Server, Oracle and informatica?

posted Mar 21, 2014 by Madhavi Kumari

+4 votes

2 answers

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

posted Jun 23, 2015 by Mohammed Hussain

+3 votes

1 answer

How to catch check constraint violation error in Database.

posted Apr 21, 2014 by Merry

+1 vote

2 answers

How to store listbox selected items into sqlserver?

posted Jun 13, 2014 by Nikita Sehgal

+1 vote

2 answers

What are Magic tables in SQL Server?

posted Nov 22, 2014 by Vrije Mani Upadhyay

+3 votes

1 answer

What does sp_validname do in SQL Server ?

posted Mar 29, 2014 by Neeraj Pandey

+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

+2 votes

1 answer

UPDATE if exists else INSERT in SQL Server 2008

posted May 9, 2014 by Khusboo

+1 vote

1 answer

SQL: What is main difference between views and cursor?

posted Aug 10, 2017 by anonymous

+3 votes

1 answer

What is the difference between CAST and CONVERT in sql server?

posted Apr 28, 2014 by Muskan

+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

What are different types of replication in SQL Server?

posted Nov 22, 2014 by Vinitha

0 votes

1 answer

What is sub-query? Explain properties of sub-query?

posted Nov 26, 2014 by Balu

+2 votes

2 answers

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

posted Nov 13, 2014 by Roshan

+2 votes

2 answers

What Is Transact-SQL Language?

posted Feb 2, 2014 by Mona Sharma

+1 vote

2 answers

What is a candidate key?

posted Mar 25, 2014 by Vishvachi Tiwari

0 votes

3 answers

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

posted Jul 17, 2014 by Sanjay

+2 votes

0 answers

How to return truly random data from a table?

posted May 2, 2014 by Muskan

+4 votes

1 answer

how to check if table exist and if it doesnt exist create table in sql server 2008

posted May 9, 2014 by Muskan

+2 votes

1 answer

What is extent in SQL Server?

posted Dec 28, 2013 by Atul Mishra