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

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

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

What is Extent and Page?

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

Difference between stored procedure and user defined function

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

What is a Cursor?

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

What is a join? List different types of joins

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

What is the use of SET NOCOUNT ON?

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

Why Group BY and Order By clause are so expensive?

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

What is a View in SQL?

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

Why we use SET ROWCOUNT in Sql?

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

Difference between Set and Select.

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

Get top two records without Top keyword.

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

Can we create non primary key as cluster index?

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

Difference between cluster and non cluster index in sql?

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

What is the purpose of using SET ANSI NULLS ON?

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

When would you use stored procedure or functions ?

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

How to call one SP from another SP. . .

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

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

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

What are Aggregate and Scalar Functions?

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

Can you explain the between clause?

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

What is order by clause?

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

How do we select distinct values from a table?

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

What are DML and DDL statements?

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

Can you explain Fourth Normal Form and Fifth Normal Form ?

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

What is denormalization ?

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

What is normalization? What are different type of normalization?

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

What are E-R diagrams?

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

Get top two records without Top keyword.

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

Can we call a Trigger in store procedure?

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

Can we create non primary key as cluster index?

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

Difference between cluster and non cluster index in sql?

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

What is the difference between Primary key and unique key?

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

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

What are different types of Collation Sensitivity?

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

What are the different index configurations a table can have?

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

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

What is Filtered Index?

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

What will be the maximum number of index per table?

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

What are Magic Tables in SQL Server?

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

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

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

What are the types of Triggers?

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

What is a Trigger?

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

What is the purpose of FLOOR function?

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

How exceptions can be handled in SQL Server Programming?

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

What is COALESCE in SQL Server?

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

What is SQL server agent?

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

What is sub query and its properties?

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

What is CHECK constraint?

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

What are the differences between local and global temporary tables?

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

What Is SQL Profiler?

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

What are the two authentication modes in SQL Server?

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

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

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

Diff b\w Stored Procedure and Function..

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

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

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

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar..

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

What are the different index configurations a table can have?

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

What is SQL?

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

Types of DBMS...?

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

What is a database ?

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

What is Data?

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

Explain Triggers in Sql Server..?

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

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

How will you handle Errors in SQL SERVER..?

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

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

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

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

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

SQL: HAVING Clause

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

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

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

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

Advantages of using Stored Procedures in Application Development..

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

List All Stored Procedure in Database..

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

What is Index in sql server?

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

DELETE & TRUNCATE in Sql server

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

Different types of Stored Procedure in sql server.

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

Finding the nth highest salary of an employee..

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

Combine Multiple Columns And Records In SQL Server

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

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

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

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

DateTime Format in Sql Server...

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

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

Add Column With Default Column Constraint to Table..

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

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

What are the different index configurations a table can have?

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

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