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)

AZURE(3)

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(65)

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

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

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

What is Extent and Page?

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

Difference between stored procedure and user defined function

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

What is a Cursor?

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

What is a join? List different types of joins

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

What is the use of SET NOCOUNT ON?

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

Why Group BY and Order By clause are so expensive?

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

What is a View in SQL?

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

Why we use SET ROWCOUNT in Sql?

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

Difference between Set and Select.

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

Get top two records without Top keyword.

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

Can we create non primary key as cluster index?

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

Difference between cluster and non cluster index in sql?

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

What is the purpose of using SET ANSI NULLS ON?

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

When would you use stored procedure or functions ?

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

How to call one SP from another SP. . .

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

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

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

What are Aggregate and Scalar Functions?

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

Can you explain the between clause?

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

What is order by clause?

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

How do we select distinct values from a table?

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

What are DML and DDL statements?

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

Can you explain Fourth Normal Form and Fifth Normal Form ?

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

What is denormalization ?

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

What is normalization? What are different type of normalization?

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

What are E-R diagrams?

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

Get top two records without Top keyword.

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

Can we call a Trigger in store procedure?

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

Can we create non primary key as cluster index?

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

Difference between cluster and non cluster index in sql?

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

What is the difference between Primary key and unique key?

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

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

What are different types of Collation Sensitivity?

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

What are the different index configurations a table can have?

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

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

What is Filtered Index?

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

What will be the maximum number of index per table?

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

What are Magic Tables in SQL Server?

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

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

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

What are the types of Triggers?

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

What is a Trigger?

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

What is the purpose of FLOOR function?

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

How exceptions can be handled in SQL Server Programming?

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

What is COALESCE in SQL Server?

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

What is SQL server agent?

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

What is sub query and its properties?

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

What is CHECK constraint?

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

What are the differences between local and global temporary tables?

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

What Is SQL Profiler?

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

What are the two authentication modes in SQL Server?

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

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

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

Diff b\w Stored Procedure and Function..

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

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

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

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar..

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

What are the different index configurations a table can have?

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

What is SQL?

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

Types of DBMS...?

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

What is a database ?

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

What is Data?

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

Explain Triggers in Sql Server..?

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

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

How will you handle Errors in SQL SERVER..?

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

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

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

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

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

SQL: HAVING Clause

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

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

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

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

Advantages of using Stored Procedures in Application Development..

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

List All Stored Procedure in Database..

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

What is Index in sql server?

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

DELETE & TRUNCATE in Sql server

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

Different types of Stored Procedure in sql server.

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

Finding the nth highest salary of an employee..

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

Combine Multiple Columns And Records In SQL Server

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

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

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

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

DateTime Format in Sql Server...

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

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

Add Column With Default Column Constraint to Table..

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

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

What are the different index configurations a table can have?

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

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