Recent questions under tag sql server

+3 votes

1 answer

What is new in lock escalation in SQL Server 2008?

posted Oct 16, 2015 by Shivaranjini

+3 votes

1 answer

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

posted Oct 16, 2015 by Shivaranjini

+3 votes

1 answer

What are Catalog view in SQL server ?

posted Oct 16, 2015 by Shivaranjini

+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

0 votes

2 answers

What is main feature of NULLIF Function in SQL?

posted Jul 1, 2015 by Amit Kumar Pandey

+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

+4 votes

0 answers

Variations for CASE in SELECTs (pros/cons)

posted Jun 30, 2015 by Manikandan J

+3 votes

1 answer

How would you handle NULL problems?

posted Jun 30, 2015 by Manikandan J

+4 votes

1 answer

What would you do to optimize slow-running queries?

posted Jun 30, 2015 by Manikandan J

+3 votes

1 answer

What is COALESCE?

posted Jun 30, 2015 by Manikandan J

+2 votes

1 answer

please explain the Properties of adhoc query?

posted Jun 23, 2015 by Mohammed Hussain

+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

1 answer

SQL Server Transactions and Error Handling

posted Jun 23, 2015 by Manikandan J

+4 votes

1 answer

When should we use EXISTS, and when should we use IN?

posted Jun 23, 2015 by Manikandan J

+2 votes

1 answer

What is a Stored Procedure?

posted Jun 23, 2015 by Manikandan J

+2 votes

1 answer

What is the difference between SQL, PL-SQL and T-SQL?

posted Jun 23, 2015 by Manikandan J

+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

+2 votes

1 answer

Update from one table to another table using SQL Server 2008

posted Jun 19, 2015 by Shivaranjini

+2 votes

1 answer

how to update table from select statement in sql server?

posted Jun 19, 2015 by Shivaranjini

+3 votes

1 answer

SQL update from one Table to another based on a ID match

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

SQL Server - Update column from data in the same table

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

Any body know the query about this senario

posted Jun 18, 2015 by Shivaranjini

+4 votes

1 answer

Please let me know the query to update this

posted Jun 18, 2015 by Shivaranjini

+2 votes

2 answers

Deleting duplicate rows from a table.

posted Jun 16, 2015 by Manikandan J

+2 votes

1 answer

Finding TOP X records from each group.

posted Jun 16, 2015 by Manikandan J

+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

+2 votes

1 answer

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

posted Jun 15, 2015 by Mohammed Hussain

+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

+4 votes

1 answer

Sql server: Check string comparison is case sensitive or not?

posted Jun 8, 2015 by Mohammed Hussain

+3 votes

1 answer

How to create cursor in sql server 2008?

posted Jun 2, 2015 by Shivaranjini

+3 votes

1 answer

how to insert multiple records in a single query?

posted May 15, 2015 by Muskan

+3 votes

1 answer

What is open query in sql server?

posted Apr 8, 2015 by Muskan

+2 votes

1 answer

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

posted Apr 2, 2015 by Vrije Mani Upadhyay

+6 votes

1 answer

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

posted Apr 1, 2015 by Khusboo

+4 votes

1 answer

How to fetch values from xml into table in sql

posted Mar 27, 2015 by Muskan

+3 votes

1 answer

What is mixed mode authentication in sql server???

posted Mar 11, 2015 by Muskan

+1 vote

1 answer

What does mean of locking granularity in SQL Server?

posted Mar 6, 2015 by Amit Kumar Pandey

+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 SAVE POINT explain ?

posted Feb 11, 2015 by Jayshree

+2 votes

2 answers

What are differences between function and stored procedure?

posted Feb 9, 2015 by Shivaranjini

+1 vote

1 answer

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

posted Feb 5, 2015 by Sachin

+2 votes

1 answer

Is threading is possible in EJB?

posted Feb 1, 2015 by Amit Kumar Pandey

+3 votes

1 answer

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

posted Feb 1, 2015 by Amit Kumar Pandey

0 votes

1 answer

What is fact table?

posted Jan 28, 2015 by anonymous