Most viewed questions under tag sql server

+1 vote

1 answer

What are the different types of BACKUPs available in SQL Server 2005?

posted Nov 18, 2014 by Roshan

+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

+3 votes

1 answer

What is EJB in Java? What are the different types of EJB?

posted Feb 1, 2015 by Amit Kumar Pandey

+1 vote

1 answer

What is the difference between system objects and user objects?

posted Nov 21, 2014 by Vinitha

+2 votes

1 answer

CTE vs Temp Tables

posted Jul 5, 2014 by Khusboo

+3 votes

1 answer

What’s the difference between a local temp table and a global temp table?

posted Jan 19, 2014 by Vishvachi Tiwari

+4 votes

1 answer

Please let me know the query to update this

posted Jun 18, 2015 by Shivaranjini

+2 votes

1 answer

What are the steps you will take, if you are tasked with securing an SQL Server?

posted Oct 29, 2014 by Vidhya Sagar

+2 votes

1 answer

What is OPENXML in SQL Server?

posted Oct 27, 2015 by Shivaranjini

+4 votes

1 answer

How do you reference an embedded function in a report expression?

posted Nov 3, 2015 by Shivaranjini

+1 vote

1 answer

How can I do an UPDATE statement with JOIN in SQL?

posted Jun 30, 2015 by Shivaranjini

+4 votes

1 answer

Select TOP 2 salary from employee table

posted Nov 28, 2014 by Manikandan J

+6 votes

2 answers

Temp tables in SQL server?

posted Nov 18, 2013 by Atul Mishra

0 votes

1 answer

How to Check existence of any table using PL-SQL in SQL server 2008?

posted Mar 19, 2016 by Sathyasree

+3 votes

1 answer

What is new in lock escalation in SQL Server 2008?

posted Oct 16, 2015 by Shivaranjini

+1 vote

1 answer

Is there a way to create a SQL Server function to “join” multiple rows from a subquery into a single delimited field?

posted Dec 29, 2014 by Amit Kumar Pandey

+2 votes

1 answer

What is lock escalation?

posted Oct 29, 2014 by Vidhya Sagar

+1 vote

1 answer

Compatible SQL to test for not null and not empty strings

posted Apr 28, 2014 by Rohini Agarwal

+1 vote

1 answer

What does the Log Reader agent in SQL Server 2005 replication do?

posted Dec 6, 2013 by Anuj Mishra

+1 vote

1 answer

How to update multiple tables in sql server 2008 ?

posted Jun 30, 2015 by Shivaranjini

+2 votes

1 answer

Recursice Stored Procedure!

posted Aug 22, 2014 by Muskan

0 votes

2 answers

What are COMMIT and ROLLBACK in SQL?

posted Jun 24, 2014 by Deepak Negi

0 votes

1 answer

How to Get all objects in a database using PL-SQL in SQL server 2008?

posted Mar 19, 2016 by Sathyasree

+2 votes

2 answers

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

posted Feb 26, 2014 by Avinash Shukla

+4 votes

1 answer

What are the ways to find what code is running for any spid?

posted Feb 21, 2014 by Prachi Agarwal

+1 vote

1 answer

What is difference between stored procedure and user defined function?

posted Nov 22, 2014 by Roshan

+5 votes

1 answer

What are various ways to enhance the SSRS report? Explain.

posted Oct 29, 2015 by Shivaranjini

+3 votes

1 answer

SQL: Where does the table variables and temporary tables exist in the memory?

posted Jan 4, 2014 by Atul Mishra

+4 votes

0 answers

How can I save image in SQL SERVER by VB.NET?

posted May 6, 2014 by Khusboo

+1 vote

1 answer

How to use Pivot in SQL Server?

posted Dec 26, 2013 by Atul Mishra

+2 votes

0 answers

What are the way to optimize any query in SQL Server so that it processed faster for big result set also

posted Mar 5, 2014 by Neeraj Pandey

+1 vote

1 answer

What is the Service Broker Identifier ?

posted Dec 6, 2013 by Anuj Mishra

0 votes

2 answers

What are constraints? Explain different types of constraints?

posted Nov 18, 2014 by Roshan

+1 vote

1 answer

How to create Nested SQL Cursors in sql server?

posted Jun 23, 2015 by Shivaranjini

+3 votes

1 answer

How to create cursor in sql server 2008?

posted Jun 2, 2015 by Shivaranjini

+1 vote

1 answer

Help with Join operation in SQL

posted Jun 16, 2015 by Shivaranjini

+4 votes

1 answer

How to list all foreign keys referencing in a given table?

posted May 28, 2014 by Merry

+4 votes

1 answer

SQLSERVER: Column with distinct value but mulitple NULL value?

posted Feb 18, 2014 by Atul Mishra

+3 votes

1 answer

What’s the difference between a clustered and a non-clustered index?

posted Jan 19, 2014 by Vishvachi Tiwari

+1 vote

1 answer

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

posted Mar 29, 2016 by Sathyasree

+3 votes

1 answer

how to insert multiple records in a single query?

posted May 15, 2015 by Muskan

+1 vote

1 answer

Unable to insert SQL Server 'money' column to new table

posted Feb 5, 2015 by Sachin

+1 vote

1 answer

How to create Cursor inside cursor in sql server?

posted Jun 23, 2015 by Shivaranjini

+5 votes

1 answer

Drill Down Reports in SSRS.

posted Feb 17, 2014 by Asmita Agrawal

0 votes

1 answer

What is database Mirroring in SQL SERVER?

posted Mar 18, 2016 by Jayshree

+4 votes

1 answer

Explain various data region available in SSRS with their use?

posted Oct 19, 2015 by Shivaranjini

+4 votes

1 answer

remove decimal points from a column value.

posted Nov 14, 2014 by Khusboo

+1 vote

1 answer

What is SQL Server Agent?

posted Aug 24, 2014 by Deepak Negi

0 votes

1 answer

How to Get table create and last modify date time using PL-SQL in SQL server 2008?

posted Mar 19, 2016 by Sathyasree

0 votes

1 answer

What is fact table?

posted Jan 28, 2015 by anonymous