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

KNOW SQL SERVER INSTALLATION DATE

Answer: 1 | Posted On: 03/02/2021 09:40:05 | Posted By: Rahul Saxena | Viewed: 1534

LEFT OUTER JOIN to a MIN/MAX row

Answer: 0 | Posted On: 24/12/2014 20:02:59 | Posted By: Rahul Saxena | Viewed: 4876

Types of Views in SQL Server ?

Answer: 1 | Posted On: 16/12/2014 08:57:46 | Posted By: Rahul Saxena | Viewed: 4782

Can Foreign Key be null ?

Answer: 1 | Posted On: 23/08/2014 03:39:40 | Posted By: Kashish | Viewed: 2470

Difference between Delete and Truncate

Answer: 2 | Posted On: 28/02/2014 15:02:42 | Posted By: Rahul Saxena | Viewed: 3010

Delete Duplicate Rows In SQL

Answer: 3 | Posted On: 28/02/2014 14:58:49 | Posted By: Rahul Saxena | Viewed: 2820

What is the purpose of using SET ANSI NULLS ON?

Answer: 1 | Posted On: 24/09/2013 09:30:12 | Posted By: Rahul | Viewed: 2682

How would you handle error in SQL SERVER 2008?

Answer: 1 | Posted On: 30/07/2013 11:48:51 | Posted By: varun | Viewed: 2864

What is use of EXCEPT Clause?

Answer: 1 | Posted On: 30/07/2013 11:47:53 | Posted By: Rahul | Viewed: 2568

What is Isolation Levels?

Answer: 1 | Posted On: 30/07/2013 11:47:16 | Posted By: Rahul | Viewed: 2610

What are synonyms?

Answer: 1 | Posted On: 30/07/2013 11:46:29 | Posted By: Rahul | Viewed: 2608

What are the Advantages of using CTE?

Answer: 1 | Posted On: 30/07/2013 11:44:59 | Posted By: Rahul | Viewed: 2662

Which are new data types introduced in SQL SERVER 2008?

Answer: 1 | Posted On: 30/07/2013 11:44:20 | Posted By: Rahul | Viewed: 2750

What is Filtered Index?

Answer: 1 | Posted On: 30/07/2013 11:43:26 | Posted By: sachin | Viewed: 2514

What is CTE?

Answer: 1 | Posted On: 30/07/2013 11:41:51 | Posted By: sachin | Viewed: 2634

What are Sparse Columns?

Answer: 1 | Posted On: 30/07/2013 11:40:44 | Posted By: Sara | Viewed: 2746

What is Replication and Database Mirroring?

Answer: 1 | Posted On: 30/07/2013 11:40:17 | Posted By: Sara | Viewed: 2570

What is Service Broker?

Answer: 1 | Posted On: 30/07/2013 11:39:40 | Posted By: Sara | Viewed: 2504

What are the basic functions for master, msdb, model, tempdb and resource databases?

Answer: 1 | Posted On: 30/07/2013 11:37:36 | Posted By: Rahul | Viewed: 2492

What is Trigger? What is its use?

Answer: 1 | Posted On: 25/02/2013 12:27:59 | Posted By: Rahul | Viewed: 2576

What is isolation level?

Answer: 1 | Posted On: 25/02/2013 12:25:51 | Posted By: Rahul | Viewed: 2984

What are Magic tables in SQL Server?

Answer: 1 | Posted On: 25/02/2013 12:23:15 | Posted By: Rahul | Viewed: 2560

What are the recovery models for a database?

Answer: 1 | Posted On: 25/02/2013 12:17:56 | Posted By: Sara | Viewed: 2596

What is the difference between a Delete and Truncate?

Answer: 1 | Posted On: 25/02/2013 12:16:11 | Posted By: Sara | Viewed: 2606

How many columns can be created in a single table?

Answer: 1 | Posted On: 25/02/2013 12:15:10 | Posted By: Sara | Viewed: 2492

How many Clustered and Non-Clustered Indexes can be created on a single table?

Answer: 1 | Posted On: 25/02/2013 12:13:44 | Posted By: Sara | Viewed: 2538

What is the difference between Clustered and Non-Clustered Index?

Answer: 1 | Posted On: 25/02/2013 12:09:47 | Posted By: Sara | Viewed: 2466

What are the different constraints in SQL Server?

Answer: 1 | Posted On: 25/02/2013 12:07:19 | Posted By: Sara | Viewed: 2488

Write a SELECT statement without FROM Clause?

Answer: 1 | Posted On: 25/02/2013 12:05:20 | Posted By: Sara | Viewed: 2710

What is a CTE?

Answer: 1 | Posted On: 25/02/2013 12:04:39 | Posted By: Sara | Viewed: 2502

New Features of SQL Server 2008 Management Studio

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

What are the basic functions for master, msdb, model, tempdb and resource databases?

Answer: 1 | Posted On: 25/02/2013 11:37:50 | Posted By: Rahul | Viewed: 2468

Difference between LINQ and Stored Procedures

Answer: 1 | Posted On: 23/02/2013 06:14:39 | Posted By: Rahul | Viewed: 2518

Common Table Expressions

Answer: 1 | Posted On: 23/02/2013 06:10:25 | Posted By: Rahul | Viewed: 2606

Explain Cursor in SQL Server 2008?

Answer: 4 | Posted On: 29/10/2012 07:15:10 | Posted By: deepak | Viewed: 2792

Difference between union and union all in SQL Server 2008?

Answer: 1 | Posted On: 29/10/2012 07:12:54 | Posted By: deepak | Viewed: 2426

Primary Key Constraint in Sql Server ..?

Answer: 1 | Posted On: 29/10/2012 07:09:35 | Posted By: deepak | Viewed: 2374

How to generate GUID In sql Server..?

Answer: 1 | Posted On: 29/10/2012 07:06:51 | Posted By: deepak | Viewed: 2496

How will retrieve the 2nd highest salary from a table...

Answer: 1 | Posted On: 05/09/2012 23:20:11 | Posted By: naman | Viewed: 2568

How can you improve SQL Query performance...

Answer: 1 | Posted On: 03/09/2012 20:20:49 | Posted By: Rahul | Viewed: 2636

SQL LIKE Operator...

Answer: 2 | Posted On: 20/08/2012 23:42:41 | Posted By: Ayush | Viewed: 3320

What is the Difference between a HAVING clause and a WHERE clause?

Answer: 1 | Posted On: 15/08/2012 00:27:58 | Posted By: Rahul | Viewed: 2584

What are Pessimistic Lock and Optimistic Lock?

Answer: 1 | Posted On: 15/08/2012 00:27:14 | Posted By: sonam | Viewed: 2616

What is an SQL Server Agent?

Answer: 1 | Posted On: 15/08/2012 00:26:39 | Posted By: sonam | Viewed: 2676

What is the difference between UNION and UNION ALL?

Answer: 1 | Posted On: 15/08/2012 00:25:56 | Posted By: sonam | Viewed: 2580

What is CHECK Constraint?

Answer: 1 | Posted On: 15/08/2012 00:25:25 | Posted By: sonam | Viewed: 2696

What are Different Types of Locks?

Answer: 1 | Posted On: 15/08/2012 00:24:36 | Posted By: sonam | Viewed: 2588

What is Dirty Read?

Answer: 1 | Posted On: 14/08/2012 23:51:01 | Posted By: sonam | Viewed: 2548

What is the Correct Order of the Logical Query Processing Phases?

Answer: 1 | Posted On: 14/08/2012 23:50:24 | Posted By: sonam | Viewed: 2746

What do you mean by Identity in SQL Server?

Answer: 1 | Posted On: 14/08/2012 23:28:12 | Posted By: Ayush | Viewed: 2532

Explain Primary Keys and Foreign Keys?

Answer: 1 | Posted On: 14/08/2012 23:27:17 | Posted By: Ayush | Viewed: 2728

Explain JOIN...

Answer: 1 | Posted On: 14/08/2012 23:26:40 | Posted By: Ayush | Viewed: 2670

What is subquery?

Answer: 1 | Posted On: 14/08/2012 23:26:10 | Posted By: Ayush | Viewed: 2726

What is the Difference between a Function and a Stored Procedure?

Answer: 1 | Posted On: 14/08/2012 23:25:46 | Posted By: Ayush | Viewed: 2530

What is a Cursor?

Answer: 1 | Posted On: 14/08/2012 23:24:58 | Posted By: Ayush | Viewed: 2694

What is a Linked Server?

Answer: 1 | Posted On: 14/08/2012 23:24:35 | Posted By: Ayush | Viewed: 2672

What is an Index?

Answer: 1 | Posted On: 14/08/2012 23:24:08 | Posted By: Ayush | Viewed: 2622

What are the Different Types of Triggers?

Answer: 1 | Posted On: 14/08/2012 23:00:15 | Posted By: Ayush | Viewed: 2562

What is a Trigger?

Answer: 1 | Posted On: 14/08/2012 22:59:33 | Posted By: Ayush | Viewed: 2519

What is a Stored Procedure?

Answer: 1 | Posted On: 14/08/2012 22:58:10 | Posted By: Ayush | Viewed: 2550

What is Normalization?

Answer: 0 | Posted On: 14/08/2012 22:57:37 | Posted By: Rahul | Viewed: 2472

How we can get the full information about a table...

Answer: 2 | Posted On: 14/08/2012 22:45:11 | Posted By: Rahul | Viewed: 2542

How we can monitor SQL Server performance?

Answer: 0 | Posted On: 14/08/2012 22:43:23 | Posted By: Rahul | Viewed: 2536

ow do I get a list of SQL Server tables and their row counts?

Answer: 2 | Posted On: 14/08/2012 22:41:33 | Posted By: Rahul | Viewed: 2480

Which TCP/IP port does SQL Server run on?

Answer: 1 | Posted On: 19/07/2012 13:13:33 | Posted By: Rahul | Viewed: 2536