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

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

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

What is Extent and Page?

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

Difference between stored procedure and user defined function

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

What is a Cursor?

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

What is a join? List different types of joins

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

What is the use of SET NOCOUNT ON?

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

Why Group BY and Order By clause are so expensive?

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

What is a View in SQL?

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

Why we use SET ROWCOUNT in Sql?

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

Difference between Set and Select.

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

Get top two records without Top keyword.

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

Can we create non primary key as cluster index?

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

Difference between cluster and non cluster index in sql?

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

What is the purpose of using SET ANSI NULLS ON?

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

When would you use stored procedure or functions ?

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

How to call one SP from another SP. . .

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

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

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

What are Aggregate and Scalar Functions?

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

Can you explain the between clause?

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

What is order by clause?

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

How do we select distinct values from a table?

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

What are DML and DDL statements?

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

Can you explain Fourth Normal Form and Fifth Normal Form ?

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

What is denormalization ?

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

What is normalization? What are different type of normalization?

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

What are E-R diagrams?

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

Get top two records without Top keyword.

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

Can we call a Trigger in store procedure?

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

Can we create non primary key as cluster index?

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

Difference between cluster and non cluster index in sql?

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

What is the difference between Primary key and unique key?

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

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

What are different types of Collation Sensitivity?

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

What are the different index configurations a table can have?

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

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

What is Filtered Index?

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

What will be the maximum number of index per table?

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

What are Magic Tables in SQL Server?

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

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

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

What are the types of Triggers?

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

What is a Trigger?

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

What is the purpose of FLOOR function?

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

How exceptions can be handled in SQL Server Programming?

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

What is COALESCE in SQL Server?

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

What is SQL server agent?

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

What is sub query and its properties?

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

What is CHECK constraint?

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

What are the differences between local and global temporary tables?

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

What Is SQL Profiler?

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

What are the two authentication modes in SQL Server?

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

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

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

Diff b\w Stored Procedure and Function..

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

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

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

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar..

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

What are the different index configurations a table can have?

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

What is SQL?

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

Types of DBMS...?

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

What is a database ?

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

What is Data?

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

Explain Triggers in Sql Server..?

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

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

How will you handle Errors in SQL SERVER..?

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

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

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

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

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

SQL: HAVING Clause

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

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

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

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

Advantages of using Stored Procedures in Application Development..

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

List All Stored Procedure in Database..

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

What is Index in sql server?

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

DELETE & TRUNCATE in Sql server

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

Different types of Stored Procedure in sql server.

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

Finding the nth highest salary of an employee..

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

Combine Multiple Columns And Records In SQL Server

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

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

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

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

DateTime Format in Sql Server...

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

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

Add Column With Default Column Constraint to Table..

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

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

What are the different index configurations a table can have?

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

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