Most voted questions under tag sql server

+2 votes

1 answer

What is openxml in sql server?

posted Dec 6, 2013 by Anuj Mishra

+2 votes

1 answer

DSN for MS SQL Server Express 2005 in PHP

posted Nov 23, 2013 by Sumit Pokharna

+2 votes

1 answer

Can someone please explain working of RIGHT and LEFT functions working in SQL Server?

posted Oct 18, 2013 by Atul Mishra

+2 votes

1 answer

How to restore the SQL server database without log backup?

posted Oct 12, 2013 by Karri Satyanarayana Naidu

+2 votes

0 answers

what is DCA port number in sql server

posted Oct 12, 2013 by Karri Satyanarayana Naidu

+2 votes

1 answer

SQL SERVER: What will happen if TUF file deleted

posted Oct 12, 2013 by Karri Satyanarayana Naidu

+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

+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

+1 vote

1 answer

How to Work with keyword NOLOCK in SQL server 2008?

posted Mar 15, 2016 by Sathaybama

+1 vote

1 answer

Switching rows and columns in SQL

posted Dec 23, 2015 by Sathaybama

+1 vote

1 answer

Update a single table based on data from multiple tables SQL Server 2005,2008

posted Jun 30, 2015 by Shivaranjini

+1 vote

1 answer

How to update multiple tables in sql server 2008 ?

posted Jun 30, 2015 by Shivaranjini

+1 vote

1 answer

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

posted Jun 30, 2015 by Shivaranjini

+1 vote

1 answer

How to create Nested SQL Cursors in sql server?

posted Jun 23, 2015 by Shivaranjini

+1 vote

1 answer

How to create Cursor inside cursor in sql server?

posted Jun 23, 2015 by Shivaranjini

+1 vote

1 answer

SQL: Need help with Multiple Joins of Tables?

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

Help with Join operation in SQL

posted Jun 16, 2015 by Shivaranjini

+1 vote

1 answer

How to use ORDER BY in VIEWS

posted Jun 12, 2015 by Shivaranjini

+1 vote

1 answer

How to insert into a table with just one IDENTITY column?

posted Jun 12, 2015 by Shivaranjini

+1 vote

1 answer

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

posted Jun 12, 2015 by Shivaranjini

+1 vote

1 answer

What does mean of locking granularity in SQL Server?

posted Mar 6, 2015 by Amit Kumar Pandey

+1 vote

1 answer

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

posted Feb 5, 2015 by Sachin

+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

+1 vote

1 answer

What is cursors?

posted Dec 2, 2014 by Balu

+1 vote

1 answer

What is the use of DBCC commands?

posted Dec 2, 2014 by Balu

+1 vote

1 answer

What are the different index configurations a table can have?

posted Dec 2, 2014 by Balu

+1 vote

1 answer

What is Index?

posted Dec 2, 2014 by Balu

+1 vote

1 answer

What is View?

posted Dec 2, 2014 by Balu

+1 vote

1 answer

What is Policy Management?

posted Nov 28, 2014 by Balu

+1 vote

2 answers

What are Magic tables in SQL Server?

posted Nov 22, 2014 by Vrije Mani Upadhyay

+1 vote

1 answer

How do we create trigger on system tables? What can be the reasons to create trigger on system tables?

posted Nov 22, 2014 by Vrije Mani Upadhyay

+1 vote

1 answer

What is difference between stored procedure and user defined function?

posted Nov 22, 2014 by Roshan

+1 vote

1 answer

What are different types of replication in SQL Server?

posted Nov 22, 2014 by Vinitha

+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

1 answer

What is the difference between system objects and user objects?

posted Nov 21, 2014 by Vinitha

+1 vote

2 answers

How many types of triggers are there?

posted Nov 18, 2014 by Vinitha

+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

What is the difference between a DDL trigger and a DML trigger?

posted Nov 13, 2014 by Roshan

+1 vote

1 answer

What changed between the previous version of SQL Server and the current version?

posted Oct 29, 2014 by Vidhya Sagar

+1 vote

2 answers

How to create recursive query in SQL Server?

posted Sep 26, 2014 by Rahul Singh

+1 vote

1 answer

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

posted Sep 4, 2014 by Khusboo

+1 vote

1 answer

What is SQL Server Agent?

posted Aug 24, 2014 by Deepak Negi

+1 vote

2 answers

Difference between clustered and a non-clustered index?

posted Aug 24, 2014 by Deepak Negi

+1 vote

2 answers

How to store listbox selected items into sqlserver?

posted Jun 13, 2014 by Nikita Sehgal

+1 vote

1 answer

Whether PHP supports Microsoft SQL server or not?

posted May 8, 2014 by Sachin Dahda