DotnetCodeSG: HelpBaord By Category


	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.

Home Article Submit Article ASP.NET 2.0 ASP.NET 3.5 MVC C# SharePoint WPF WCF Services Help Board Buzz! About Us

TECHNOLOGIES:

.NET 1.0/1.1(7)

.NET 3.0/3.5(24)

ADO.NET(10)

AJAX(2)

AngularJS(4)

ASP.NET 2.0(8)

ASP.NET 3.5(12)

ASP.NET MVC(10)

General Programming(31)

JavaScript(1)

JQuery(3)

LINQ(2)

LINQ(3)

OOPs(56)

Project Management(1)

SharePoint(55)

SQL Server 2005(84)

SQL Server 2008(64)

Testing(48)

UML(2)

Visual Studio 2008(2)

WCF(38)

Web Services(1)

WPF(13)

XML(7)

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: 1780

What’s the difference between "UNION" and "UNION ALL" ?

Answer: 1 | Posted On: 13/10/2013 00:16:55 | Posted By: Priyanka | Viewed: 1718

What is Extent and Page?

Answer: 1 | Posted On: 13/10/2013 00:13:32 | Posted By: Priyanka | Viewed: 1652

Difference between stored procedure and user defined function

Answer: 1 | Posted On: 13/10/2013 00:08:36 | Posted By: Priyanka | Viewed: 1650

What is a Cursor?

Answer: 1 | Posted On: 13/10/2013 00:07:51 | Posted By: Priyanka | Viewed: 1692

What is a join? List different types of joins

Answer: 1 | Posted On: 13/10/2013 00:06:31 | Posted By: Priyanka | Viewed: 1636

What is the use of SET NOCOUNT ON?

Answer: 1 | Posted On: 13/10/2013 00:05:42 | Posted By: Priyanka | Viewed: 1684

Why Group BY and Order By clause are so expensive?

Answer: 1 | Posted On: 13/10/2013 00:04:35 | Posted By: Priyanka | Viewed: 1658

What is a View in SQL?

Answer: 1 | Posted On: 13/10/2013 00:01:25 | Posted By: Priyanka | Viewed: 1600

Why we use SET ROWCOUNT in Sql?

Answer: 1 | Posted On: 13/10/2013 00:00:24 | Posted By: Priyanka | Viewed: 1572

Difference between Set and Select.

Answer: 1 | Posted On: 12/10/2013 23:58:13 | Posted By: Priyanka | Viewed: 1652

Get top two records without Top keyword.

Answer: 1 | Posted On: 12/10/2013 23:55:38 | Posted By: Priyanka | Viewed: 1692

Can we create non primary key as cluster index?

Answer: 1 | Posted On: 12/10/2013 23:53:25 | Posted By: Priyanka | Viewed: 1598

Difference between cluster and non cluster index in sql?

Answer: 1 | Posted On: 12/10/2013 23:50:24 | Posted By: Priyanka | Viewed: 1674

What is the purpose of using SET ANSI NULLS ON?

Answer: 1 | Posted On: 12/10/2013 23:23:35 | Posted By: Rahul | Viewed: 1626

When would you use stored procedure or functions ?

Answer: 1 | Posted On: 12/10/2013 04:06:49 | Posted By: Rahul | Viewed: 1638

How to call one SP from another SP. . .

Answer: 0 | Posted On: 02/10/2013 11:56:30 | Posted By: Rahul | Viewed: 1608

How to Get n no. of Rows From DataTable..

Answer: 0 | Posted On: 28/09/2013 12:37:37 | Posted By: Rahul | Viewed: 1638

What are Aggregate and Scalar Functions?

Answer: 1 | Posted On: 26/09/2013 10:27:40 | Posted By: Rahul | Viewed: 1614

Can you explain the between clause?

Answer: 1 | Posted On: 26/09/2013 10:22:46 | Posted By: Rahul | Viewed: 1604

What is order by clause?

Answer: 0 | Posted On: 26/09/2013 10:20:10 | Posted By: Rahul | Viewed: 1660

How do we select distinct values from a table?

Answer: 1 | Posted On: 26/09/2013 10:18:57 | Posted By: Rahul | Viewed: 1662

What are DML and DDL statements?

Answer: 1 | Posted On: 26/09/2013 10:17:39 | Posted By: Rahul | Viewed: 1650

Can you explain Fourth Normal Form and Fifth Normal Form ?

Answer: 1 | Posted On: 26/09/2013 10:16:39 | Posted By: Rahul | Viewed: 1572

What is denormalization ?

Answer: 1 | Posted On: 26/09/2013 10:15:51 | Posted By: Rahul | Viewed: 1624

What is normalization? What are different type of normalization?

Answer: 1 | Posted On: 26/09/2013 10:14:38 | Posted By: Rahul | Viewed: 1508

What are E-R diagrams?

Answer: 1 | Posted On: 26/09/2013 10:13:52 | Posted By: Rahul | Viewed: 1630

Get top two records without Top keyword.

Answer: 1 | Posted On: 24/09/2013 09:33:34 | Posted By: Rahul | Viewed: 1640

Can we call a Trigger in store procedure?

Answer: 1 | Posted On: 24/09/2013 09:32:24 | Posted By: Rahul | Viewed: 1676

Can we create non primary key as cluster index?

Answer: 1 | Posted On: 24/09/2013 09:31:40 | Posted By: Rahul | Viewed: 1606

Difference between cluster and non cluster index in sql?

Answer: 1 | Posted On: 24/09/2013 09:31:07 | Posted By: Rahul | Viewed: 1592

What is the difference between Primary key and unique key?

Answer: 1 | Posted On: 13/08/2013 11:24:51 | Posted By: Rahul | Viewed: 1604

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: 1550

What are different types of Collation Sensitivity?

Answer: 1 | Posted On: 05/07/2013 05:37:37 | Posted By: Siddarth | Viewed: 1676

What are the different index configurations a table can have?

Answer: 1 | Posted On: 05/07/2013 05:36:26 | Posted By: Siddarth | Viewed: 1664

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: 1656

What is Filtered Index?

Answer: 1 | Posted On: 02/07/2013 12:38:05 | Posted By: Rahul | Viewed: 1602

What will be the maximum number of index per table?

Answer: 1 | Posted On: 02/07/2013 12:27:28 | Posted By: Rahul | Viewed: 1598

What are Magic Tables in SQL Server?

Answer: 1 | Posted On: 02/07/2013 12:25:48 | Posted By: Rahul | Viewed: 1684

What is the use of SET NOCOUNT ON/OFF statement?

Answer: 1 | Posted On: 02/07/2013 12:24:41 | Posted By: Rahul | Viewed: 1664

What are the types of Triggers?

Answer: 1 | Posted On: 02/07/2013 12:22:53 | Posted By: Rahul | Viewed: 1592

What is a Trigger?

Answer: 1 | Posted On: 02/07/2013 11:46:51 | Posted By: Rahul | Viewed: 1764

What is the purpose of FLOOR function?

Answer: 1 | Posted On: 02/07/2013 11:44:48 | Posted By: Rahul | Viewed: 1672

How exceptions can be handled in SQL Server Programming?

Answer: 1 | Posted On: 02/07/2013 11:43:19 | Posted By: Rahul | Viewed: 1630

What is COALESCE in SQL Server?

Answer: 1 | Posted On: 02/07/2013 11:41:33 | Posted By: Rahul | Viewed: 1630

What is SQL server agent?

Answer: 0 | Posted On: 02/07/2013 11:40:32 | Posted By: Rahul | Viewed: 1656

What is sub query and its properties?

Answer: 1 | Posted On: 02/07/2013 11:38:41 | Posted By: Rahul | Viewed: 1676

What is CHECK constraint?

Answer: 1 | Posted On: 02/07/2013 11:37:28 | Posted By: Rahul | Viewed: 1590

What are the differences between local and global temporary tables?

Answer: 1 | Posted On: 02/07/2013 11:36:05 | Posted By: Rahul | Viewed: 1632

What Is SQL Profiler?

Answer: 1 | Posted On: 02/07/2013 11:34:02 | Posted By: Rahul | Viewed: 1620

What are the two authentication modes in SQL Server?

Answer: 1 | Posted On: 02/07/2013 11:32:46 | Posted By: Rahul | Viewed: 1636

How to generate row number in SQL Without ROWNUM...?

Answer: 1 | Posted On: 02/07/2013 11:27:54 | Posted By: Rahul | Viewed: 1626

Diff b\w Stored Procedure and Function..

Answer: 9 | Posted On: 13/06/2013 12:18:46 | Posted By: Rahul | Viewed: 1664

Difference between char, varchar and nvarchar in sql server...

Answer: 0 | Posted On: 17/04/2013 06:49:59 | Posted By: Rahul | Viewed: 1644

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar..

Answer: 1 | Posted On: 17/04/2013 05:20:04 | Posted By: Rahul | Viewed: 1668

What are the different index configurations a table can have?

Answer: 1 | Posted On: 12/03/2013 04:08:46 | Posted By: Rahul | Viewed: 1670

What is SQL?

Answer: 0 | Posted On: 07/03/2013 02:16:19 | Posted By: shubh | Viewed: 1594

Types of DBMS...?

Answer: 1 | Posted On: 07/03/2013 02:14:58 | Posted By: shubh | Viewed: 1598

What is a database ?

Answer: 1 | Posted On: 07/03/2013 02:13:31 | Posted By: shubh | Viewed: 1614

What is Data?

Answer: 1 | Posted On: 07/03/2013 02:12:14 | Posted By: shubh | Viewed: 1596

Explain Triggers in Sql Server..?

Answer: 1 | Posted On: 01/11/2012 08:32:01 | Posted By: varun | Viewed: 1736

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: 1584

How will you handle Errors in SQL SERVER..?

Answer: 3 | Posted On: 01/11/2012 07:44:02 | Posted By: varun | Viewed: 1630

How to get table size in SQL Server 2005 ..?

Answer: 1 | Posted On: 01/11/2012 07:42:09 | Posted By: varun | Viewed: 1658

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: 1604

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: 1758

SQL: HAVING Clause

Answer: 1 | Posted On: 15/10/2012 10:42:20 | Posted By: Rahul | Viewed: 1668

what is a magic table in sql server...?

Answer: 1 | Posted On: 03/10/2012 19:15:10 | Posted By: Kanak | Viewed: 1806

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: 1734

Advantages of using Stored Procedures in Application Development..

Answer: 1 | Posted On: 03/10/2012 18:52:41 | Posted By: sachin | Viewed: 1726

List All Stored Procedure in Database..

Answer: 2 | Posted On: 03/10/2012 10:53:03 | Posted By: deepak | Viewed: 1720

What is Index in sql server?

Answer: 1 | Posted On: 27/09/2012 11:38:12 | Posted By: Kanak | Viewed: 1592

DELETE & TRUNCATE in Sql server

Answer: 1 | Posted On: 27/09/2012 11:36:47 | Posted By: Kanak | Viewed: 1882

Different types of Stored Procedure in sql server.

Answer: 1 | Posted On: 27/09/2012 11:36:05 | Posted By: Kanak | Viewed: 1642

Finding the nth highest salary of an employee..

Answer: 2 | Posted On: 26/09/2012 20:40:39 | Posted By: Shraddha | Viewed: 1634

Combine Multiple Columns And Records In SQL Server

Answer: 1 | Posted On: 05/09/2012 23:25:11 | Posted By: naman | Viewed: 1586

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: 1682

How to Remove Delete Duplicate Records Or Rows-Sql Server.

Answer: 1 | Posted On: 05/09/2012 23:16:52 | Posted By: Rahul | Viewed: 1664

DateTime Format in Sql Server...

Answer: 3 | Posted On: 18/08/2012 18:56:20 | Posted By: Rahul | Viewed: 1728

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: 1702

Add Column With Default Column Constraint to Table..

Answer: 3 | Posted On: 12/08/2012 18:10:19 | Posted By: deepak | Viewed: 1636

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: 1474

What are the different index configurations a table can have?

Answer: 1 | Posted On: 19/07/2012 13:19:22 | Posted By: Utsav | Viewed: 1526

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: 1414