Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF. 		 
TECHNOLOGIES:
Help Board:: By Technology
Difference between log file and mdf file
Answer: 1  |  Posted On: 12/11/2013 20:51:27  |  Posted By: Rahul  |  Viewed: 2090
What’s the difference between "UNION" and "UNION ALL" ?
Answer: 1  |  Posted On: 13/10/2013 00:16:55  |  Posted By: Priyanka  |  Viewed: 2032
What is Extent and Page?
Answer: 1  |  Posted On: 13/10/2013 00:13:32  |  Posted By: Priyanka  |  Viewed: 1968
Difference between stored procedure and user defined function
Answer: 1  |  Posted On: 13/10/2013 00:08:36  |  Posted By: Priyanka  |  Viewed: 1984
What is a Cursor?
Answer: 1  |  Posted On: 13/10/2013 00:07:51  |  Posted By: Priyanka  |  Viewed: 2000
What is a join? List different types of joins
Answer: 1  |  Posted On: 13/10/2013 00:06:31  |  Posted By: Priyanka  |  Viewed: 1920
What is the use of SET NOCOUNT ON?
Answer: 1  |  Posted On: 13/10/2013 00:05:42  |  Posted By: Priyanka  |  Viewed: 2002
Why Group BY and Order By clause are so expensive?
Answer: 1  |  Posted On: 13/10/2013 00:04:35  |  Posted By: Priyanka  |  Viewed: 1974
What is a View in SQL?
Answer: 1  |  Posted On: 13/10/2013 00:01:25  |  Posted By: Priyanka  |  Viewed: 1894
Why we use SET ROWCOUNT in Sql?
Answer: 1  |  Posted On: 13/10/2013 00:00:24  |  Posted By: Priyanka  |  Viewed: 1878
Difference between Set and Select.
Answer: 1  |  Posted On: 12/10/2013 23:58:13  |  Posted By: Priyanka  |  Viewed: 1956
Get top two records without Top keyword.
Answer: 1  |  Posted On: 12/10/2013 23:55:38  |  Posted By: Priyanka  |  Viewed: 2000
Can we create non primary key as cluster index?
Answer: 1  |  Posted On: 12/10/2013 23:53:25  |  Posted By: Priyanka  |  Viewed: 1904
Difference between cluster and non cluster index in sql?
Answer: 1  |  Posted On: 12/10/2013 23:50:24  |  Posted By: Priyanka  |  Viewed: 1930
What is the purpose of using SET ANSI NULLS ON?
Answer: 1  |  Posted On: 12/10/2013 23:23:35  |  Posted By: Rahul  |  Viewed: 1886
When would you use stored procedure or functions ?
Answer: 1  |  Posted On: 12/10/2013 04:06:49  |  Posted By: Rahul  |  Viewed: 1892
How to call one SP from another SP. . .
Answer: 0  |  Posted On: 02/10/2013 11:56:30  |  Posted By: Rahul  |  Viewed: 1864
How to Get n no. of Rows From DataTable..
Answer: 0  |  Posted On: 28/09/2013 12:37:37  |  Posted By: Rahul  |  Viewed: 1914
What are Aggregate and Scalar Functions?
Answer: 1  |  Posted On: 26/09/2013 10:27:40  |  Posted By: Rahul  |  Viewed: 1878
Can you explain the between clause?
Answer: 1  |  Posted On: 26/09/2013 10:22:46  |  Posted By: Rahul  |  Viewed: 1902
What is order by clause?
Answer: 0  |  Posted On: 26/09/2013 10:20:10  |  Posted By: Rahul  |  Viewed: 1938
How do we select distinct values from a table?
Answer: 1  |  Posted On: 26/09/2013 10:18:57  |  Posted By: Rahul  |  Viewed: 1932
What are DML and DDL statements?
Answer: 1  |  Posted On: 26/09/2013 10:17:39  |  Posted By: Rahul  |  Viewed: 1960
Can you explain Fourth Normal Form and Fifth Normal Form ?
Answer: 1  |  Posted On: 26/09/2013 10:16:39  |  Posted By: Rahul  |  Viewed: 1860
What is denormalization ?
Answer: 1  |  Posted On: 26/09/2013 10:15:51  |  Posted By: Rahul  |  Viewed: 1868
What is normalization? What are different type of normalization?
Answer: 1  |  Posted On: 26/09/2013 10:14:38  |  Posted By: Rahul  |  Viewed: 1796
What are E-R diagrams?
Answer: 1  |  Posted On: 26/09/2013 10:13:52  |  Posted By: Rahul  |  Viewed: 1892
Get top two records without Top keyword.
Answer: 1  |  Posted On: 24/09/2013 09:33:34  |  Posted By: Rahul  |  Viewed: 1878
Can we call a Trigger in store procedure?
Answer: 1  |  Posted On: 24/09/2013 09:32:24  |  Posted By: Rahul  |  Viewed: 1992
Can we create non primary key as cluster index?
Answer: 1  |  Posted On: 24/09/2013 09:31:40  |  Posted By: Rahul  |  Viewed: 1848
Difference between cluster and non cluster index in sql?
Answer: 1  |  Posted On: 24/09/2013 09:31:07  |  Posted By: Rahul  |  Viewed: 1826
What is the difference between Primary key and unique key?
Answer: 1  |  Posted On: 13/08/2013 11:24:51  |  Posted By: Rahul  |  Viewed: 1854
What's the difference between a primary key and a unique key?
Answer: 1  |  Posted On: 05/07/2013 05:40:10  |  Posted By: Siddarth  |  Viewed: 1796
What are different types of Collation Sensitivity?
Answer: 1  |  Posted On: 05/07/2013 05:37:37  |  Posted By: Siddarth  |  Viewed: 1934
What are the different index configurations a table can have?
Answer: 1  |  Posted On: 05/07/2013 05:36:26  |  Posted By: Siddarth  |  Viewed: 1882
What are the difference between clustered and a non-clustered index?
Answer: 1  |  Posted On: 05/07/2013 05:35:21  |  Posted By: Siddarth  |  Viewed: 1914
What is Filtered Index?
Answer: 1  |  Posted On: 02/07/2013 12:38:05  |  Posted By: Rahul  |  Viewed: 1846
What will be the maximum number of index per table?
Answer: 1  |  Posted On: 02/07/2013 12:27:28  |  Posted By: Rahul  |  Viewed: 1826
What are Magic Tables in SQL Server?
Answer: 1  |  Posted On: 02/07/2013 12:25:48  |  Posted By: Rahul  |  Viewed: 1912
What is the use of SET NOCOUNT ON/OFF statement?
Answer: 1  |  Posted On: 02/07/2013 12:24:41  |  Posted By: Rahul  |  Viewed: 1878
What are the types of Triggers?
Answer: 1  |  Posted On: 02/07/2013 12:22:53  |  Posted By: Rahul  |  Viewed: 1840
What is a Trigger?
Answer: 1  |  Posted On: 02/07/2013 11:46:51  |  Posted By: Rahul  |  Viewed: 1980
What is the purpose of FLOOR function?
Answer: 1  |  Posted On: 02/07/2013 11:44:48  |  Posted By: Rahul  |  Viewed: 1940
How exceptions can be handled in SQL Server Programming?
Answer: 1  |  Posted On: 02/07/2013 11:43:19  |  Posted By: Rahul  |  Viewed: 1858
What is COALESCE in SQL Server?
Answer: 1  |  Posted On: 02/07/2013 11:41:33  |  Posted By: Rahul  |  Viewed: 1844
What is SQL server agent?
Answer: 0  |  Posted On: 02/07/2013 11:40:32  |  Posted By: Rahul  |  Viewed: 1904
What is sub query and its properties?
Answer: 1  |  Posted On: 02/07/2013 11:38:41  |  Posted By: Rahul  |  Viewed: 1882
What is CHECK constraint?
Answer: 1  |  Posted On: 02/07/2013 11:37:28  |  Posted By: Rahul  |  Viewed: 1834
What are the differences between local and global temporary tables?
Answer: 1  |  Posted On: 02/07/2013 11:36:05  |  Posted By: Rahul  |  Viewed: 1888
What Is SQL Profiler?
Answer: 1  |  Posted On: 02/07/2013 11:34:02  |  Posted By: Rahul  |  Viewed: 1882
What are the two authentication modes in SQL Server?
Answer: 1  |  Posted On: 02/07/2013 11:32:46  |  Posted By: Rahul  |  Viewed: 1890
How to generate row number in SQL Without ROWNUM...?
Answer: 1  |  Posted On: 02/07/2013 11:27:54  |  Posted By: Rahul  |  Viewed: 1842
Diff b\w Stored Procedure and Function..
Answer: 9  |  Posted On: 13/06/2013 12:18:46  |  Posted By: Rahul  |  Viewed: 1864
Difference between char, varchar and nvarchar in sql server...
Answer: 0  |  Posted On: 17/04/2013 06:49:59  |  Posted By: Rahul  |  Viewed: 1866
Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar..
Answer: 1  |  Posted On: 17/04/2013 05:20:04  |  Posted By: Rahul  |  Viewed: 1934
What are the different index configurations a table can have?
Answer: 1  |  Posted On: 12/03/2013 04:08:46  |  Posted By: Rahul  |  Viewed: 1900
What is SQL?
Answer: 0  |  Posted On: 07/03/2013 02:16:19  |  Posted By: shubh  |  Viewed: 1832
Types of DBMS...?
Answer: 1  |  Posted On: 07/03/2013 02:14:58  |  Posted By: shubh  |  Viewed: 1838
What is a database ?
Answer: 1  |  Posted On: 07/03/2013 02:13:31  |  Posted By: shubh  |  Viewed: 1830
What is Data?
Answer: 1  |  Posted On: 07/03/2013 02:12:14  |  Posted By: shubh  |  Viewed: 1818
Explain Triggers in Sql Server..?
Answer: 1  |  Posted On: 01/11/2012 08:32:01  |  Posted By: varun  |  Viewed: 1978
Explain ERROR_NUMBER, ERROR_MESSAGE, ERROR_LINE, ERROR_SEVERITY, ERROR_STATE, ERROR_PROCEDURE.
Answer: 1  |  Posted On: 01/11/2012 07:48:30  |  Posted By: varun  |  Viewed: 1832
How will you handle Errors in SQL SERVER..?
Answer: 3  |  Posted On: 01/11/2012 07:44:02  |  Posted By: varun  |  Viewed: 1864
How to get table size in SQL Server 2005 ..?
Answer: 1  |  Posted On: 01/11/2012 07:42:09  |  Posted By: varun  |  Viewed: 1872
What is the different between Where and Having Clause in SQL Server..?
Answer: 0  |  Posted On: 29/10/2012 08:44:22  |  Posted By: naman  |  Viewed: 1824
what’s the difference between the having clause and the where clause?
Answer: 1  |  Posted On: 15/10/2012 10:48:18  |  Posted By: Rahul  |  Viewed: 1996
SQL: HAVING Clause
Answer: 1  |  Posted On: 15/10/2012 10:42:20  |  Posted By: Rahul  |  Viewed: 1910
what is a magic table in sql server...?
Answer: 1  |  Posted On: 03/10/2012 19:15:10  |  Posted By: Kanak  |  Viewed: 2012
How to get integer and string records from the existing table in sql server?
Answer: 1  |  Posted On: 03/10/2012 19:10:54  |  Posted By: Kanak  |  Viewed: 1948
Advantages of using Stored Procedures in Application Development..
Answer: 1  |  Posted On: 03/10/2012 18:52:41  |  Posted By: sachin  |  Viewed: 1962
List All Stored Procedure in Database..
Answer: 2  |  Posted On: 03/10/2012 10:53:03  |  Posted By: deepak  |  Viewed: 1968
What is Index in sql server?
Answer: 1  |  Posted On: 27/09/2012 11:38:12  |  Posted By: Kanak  |  Viewed: 1816
DELETE & TRUNCATE in Sql server
Answer: 1  |  Posted On: 27/09/2012 11:36:47  |  Posted By: Kanak  |  Viewed: 2120
Different types of Stored Procedure in sql server.
Answer: 1  |  Posted On: 27/09/2012 11:36:05  |  Posted By: Kanak  |  Viewed: 1878
Finding the nth highest salary of an employee..
Answer: 2  |  Posted On: 26/09/2012 20:40:39  |  Posted By: Shraddha  |  Viewed: 1858
Combine Multiple Columns And Records In SQL Server
Answer: 1  |  Posted On: 05/09/2012 23:25:11  |  Posted By: naman  |  Viewed: 1804
How will you Reset Identity Column Value In Sql Server Table..
Answer: 1  |  Posted On: 05/09/2012 23:23:18  |  Posted By: naman  |  Viewed: 1888
How to Remove Delete Duplicate Records Or Rows-Sql Server.
Answer: 1  |  Posted On: 05/09/2012 23:16:52  |  Posted By: Rahul  |  Viewed: 1878
DateTime Format in Sql Server...
Answer: 3  |  Posted On: 18/08/2012 18:56:20  |  Posted By: Rahul  |  Viewed: 1964
What are the Authentication Modes in SQL Server? How can it be Changed?
Answer: 1  |  Posted On: 15/08/2012 00:29:04  |  Posted By: Rahul  |  Viewed: 1906
Add Column With Default Column Constraint to Table..
Answer: 3  |  Posted On: 12/08/2012 18:10:19  |  Posted By: deepak  |  Viewed: 1842
What's the difference between a primary key and a unique key?
Answer: 1  |  Posted On: 19/07/2012 13:21:13  |  Posted By: Utsav  |  Viewed: 1662
What are the different index configurations a table can have?
Answer: 1  |  Posted On: 19/07/2012 13:19:22  |  Posted By: Utsav  |  Viewed: 1720
What are the difference between clustered and a non-clustered index?
Answer: 1  |  Posted On: 19/07/2012 13:15:09  |  Posted By: Rahul  |  Viewed: 1600
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us
Copyright © 2014 www.dotnetcodesg.com All Rights Reserved (Best Viewed In IE at 1024 * 768)