Recent posts under tag sql server

0 votes

1 answer

What is database Mirroring in SQL SERVER?

posted Mar 18, 2016 by Jayshree

0 votes

1 answer

How we can Check Table Size in our database?

posted Mar 18, 2016 by Jayshree

0 votes

1 answer

How we can develop database paging using PLSQL in Sql Server 2005?

posted Mar 17, 2016 by Latha

0 votes

1 answer

How to use Truncate table in Procedure using Sql Server 2005?

posted Mar 17, 2016 by Latha

0 votes

1 answer

How to use "sys.objects" in Sql Server 2008 using PL-SQL?

posted Mar 17, 2016 by Latha

0 votes

1 answer

How to Work with SET ROWCOUNT in SQL Server 2008 using PL/SQL?

posted Mar 15, 2016 by Sathaybama

+1 vote

1 answer

How to Work with keyword NOLOCK in SQL server 2008?

posted Mar 15, 2016 by Sathaybama

0 votes

1 answer

How to Work with SUBSTRING () function in SQL Server 2008 using PL/SQL?

posted Mar 12, 2016 by Sathaybama

0 votes

1 answer

How to Work with LOWER () and UPPER () function in SQL Server 2008 using PL/SQL?

posted Mar 12, 2016 by Sathaybama

+2 votes

1 answer

Explain the Steps to Attach & Detach Database?

posted Feb 2, 2016 by Jayshree

+2 votes

1 answer

How to get Distinct records from datatable or dataset?

posted Feb 1, 2016 by Latha

+2 votes

Execute Dynamic SQL commands in SQL Server

posted Jan 5, 2016 by Shivaranjini

+2 votes

Displaying the Row Number in a SELECT Query with SQL Server 2005

posted Jan 5, 2016 by Shivaranjini

+1 vote

1 answer

Switching rows and columns in SQL

posted Dec 23, 2015 by Sathaybama

+2 votes

@@ROWCOUNT - ROWCOUNT Function in SQL?

posted Nov 6, 2015 by Shivaranjini

+3 votes

1 answer

In SSRS report can we edit the .rdl code associated with a linked report?

posted Nov 3, 2015 by Shivaranjini

+3 votes

1 answer

What are the three SSRS command-line utilities and their primary functions?

posted Nov 3, 2015 by Shivaranjini

+4 votes

1 answer

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

posted Nov 3, 2015 by Shivaranjini

+5 votes

1 answer

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

posted Oct 29, 2015 by Shivaranjini

+2 votes

1 answer

What is OPENXML in SQL Server?

posted Oct 27, 2015 by Shivaranjini

+4 votes

1 answer

What are the differences between lost updates and uncommitted dependencies?

posted Oct 23, 2015 by Vrije Mani Upadhyay

+3 votes

1 answer

What is the significance of NULL value and why should we avoid permitting null values?

posted Oct 23, 2015 by Vrije Mani Upadhyay

+4 votes

1 answer

Explain various data region available in SSRS with their use?

posted Oct 19, 2015 by Shivaranjini

+4 votes

1 answer

What are the restrictions while creating batches in SQL Server?

posted Oct 19, 2015 by Shivaranjini

+5 votes

1 answer

What is the meaning of Redo Log file mirroring in SQL?

posted Oct 19, 2015 by Shivaranjini

+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

+3 votes

Ranking Functions in SQL Server

posted Aug 8, 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

+1 vote

How to optimize a slow running query in SQL Server ?

posted Jul 2, 2015 by Vrije Mani Upadhyay

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