Most viewed questions under tag sql server

+1 vote

1 answer

What is SQL Server Agent?

posted Aug 24, 2014 by Deepak Negi

+2 votes

0 answers

How do I assign a cursor or table data type?

posted Apr 18, 2014 by Muskan

0 votes

1 answer

How can we rewrite sub-queries into simple select statements or with joins?

posted Nov 25, 2014 by Vinitha

+1 vote

2 answers

What are the basic functions for master, msdb, model, tempdb databases?

posted Nov 22, 2014 by Vinitha

0 votes

1 answer

What is fact table?

posted Jan 28, 2015 by anonymous

+3 votes

1 answer

What are Catalog view in SQL server ?

posted Oct 16, 2015 by Shivaranjini

+2 votes

0 answers

How can I backup SQL Database from my VB.Net Windows Application?

posted Sep 12, 2014 by Tapesh Kulkarni

+2 votes

0 answers

How to cancel restring of a database in between

posted Apr 28, 2014 by Neeraj Pandey

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 Work with SET ROWCOUNT in SQL Server 2008 using PL/SQL?

posted Mar 15, 2016 by Sathaybama

+6 votes

1 answer

Select 2nd Highest salary from employee table

posted Nov 28, 2014 by Manikandan J

+2 votes

1 answer

What are indexed views?

posted Aug 22, 2014 by Merry

+4 votes

0 answers

Generic Method to Create and Execute Parameterized SQL Query in .NET 4.0

posted May 8, 2014 by Muskan

+3 votes

1 answer

Replication Administration sql

posted Mar 26, 2014 by Muskan

0 votes

2 answers

What is LINQ?

posted Nov 25, 2014 by Roshan

+4 votes

0 answers

What are wild cards used in database for Pattern Matching ?

posted May 2, 2014 by Khusboo

+2 votes

1 answer

What are DBCC commands?

posted Jan 19, 2014 by Vishvachi Tiwari

0 votes

1 answer

How to Work with RAND FLOOR LOG LOG10 EXP functions in SQL server 2008?

posted Mar 21, 2016 by Latha

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

0 votes

1 answer

How to work with CHARINDEX() funciton in sql server 2008?

posted Mar 23, 2016 by Jayshree

0 votes

1 answer

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

posted Mar 17, 2016 by Latha

+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

Whether PHP supports Microsoft SQL server or not?

posted May 8, 2014 by Sachin Dahda

0 votes

1 answer

One PHP Login Form for Different databases?

posted Jul 7, 2014 by Deepak Negi

0 votes

1 answer

What is Data Compression in the context of SQL Server?

posted Nov 25, 2014 by Roshan

+4 votes

1 answer

What are the restrictions while creating batches in SQL Server?

posted Oct 19, 2015 by Shivaranjini

+2 votes

1 answer

What is the use of Update_Statistics in SQLServer

posted Mar 17, 2014 by Neeraj Pandey

+4 votes

1 answer

How can we alter a huge table in SQL

posted Feb 27, 2014 by Neeraj Pandey

+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

+1 vote

1 answer

What is the use of DBCC commands?

posted Dec 2, 2014 by Balu

+7 votes

1 answer

What is the use of sp_exectesql in sql server

posted Dec 19, 2013 by Neeraj Pandey

0 votes

1 answer

How to Work with common MATH functions in SQL server 2008?

posted Mar 23, 2016 by Jayshree

+3 votes

1 answer

select data from multiple rows in a single columnsql

posted Dec 5, 2014 by Merry

+3 votes

1 answer

Difference between Left Join and Left outer join?

posted Nov 20, 2014 by Muskan

0 votes

0 answers

Populating fact table with key's from other tables

posted Oct 22, 2018 by Ad Van Dorpen

+2 votes

1 answer

What is NOLOCK?

posted Nov 28, 2014 by Vinitha

0 votes

1 answer

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

posted Mar 12, 2016 by Sathaybama

+2 votes

1 answer

What is fill factor in SQL Server ?

posted Mar 26, 2014 by Vishvachi Tiwari

+2 votes

1 answer

What security features are available for stored procedure?

posted Aug 22, 2014 by Khusboo

0 votes

1 answer

How to Import Data from Note Pad Files to Sql Server 2008 using PL-Sql?

posted Mar 19, 2016 by Sathyasree

+4 votes

1 answer

What is the use of sp_xml_preparedocument?

posted May 12, 2014 by Merry

+1 vote

1 answer

How can I determine that temporary table exists in SQL Server?

posted Apr 30, 2014 by Aastha Joshi

0 votes

1 answer

How to Work with new data type TIME introduced in SQL Server 2008. (SQL Server new features)?

posted Mar 19, 2016 by Sathyasree

+4 votes

1 answer

What are the differences between lost updates and uncommitted dependencies?

posted Oct 23, 2015 by Vrije Mani Upadhyay

+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

+3 votes

1 answer

What is a database lock in the context of SQL?

posted Jan 24, 2014 by Neeraj Pandey

+2 votes

1 answer

Why a table can have only single clustered index ?

posted Jan 19, 2014 by Atul Mishra

+2 votes

1 answer

What is Scope identity and When is it used?

posted Aug 8, 2014 by Muskan

+2 votes

1 answer

What are the new features introduced in SQL Server 2000 ?

posted Oct 29, 2014 by Vidhya Sagar