S.No | Particulars | Cluster | NON-Cluster |
---|---|---|---|
1 | data rows | sort and store the data rows in the table or view based on their key values. | have a structure separate from the data rows. |
2 | Read | Faster to read than NON-Cluster | |
3 | Store | Physically, Store Index Order | |
4 | Faster Insert/Update | Qucikly Insert and Update Data than a Cluster Index. | |
5 | Table | Only One Per Table | can be used many time per Table |
6 | Order | Data is in Physical Order | Logical Order |
Cluster vs NON-Cluster Index
Labels:
Interview Question and Answer
Function vs Methods
S.No | Particulars | Funciton | Methods |
---|---|---|---|
1 | independent existence | they can be defined outside of the class | they are always defined with in class |
2 | languages | Structure languages | object oriented languages |
3 | independently | called independently. | called using instance or object. |
4 | Functions are self describing unit of code. | Methods are used to manipuate instance variable of a class |
Labels:
OOPS
Web Services vs WCF
S.No | Particulars | Web services | WCF |
---|---|---|---|
1 | Support SOAP | Yes | Yes |
2 | Support | HTTP | TCP, HTTP, HTTPS, Named Pipes, MSMQ. |
3 | Return Data | XML | XML |
4 | Open Source | No, can be consumed by any client that understands xml. | No, can be consumed by any client that understands xml. |
5 | Host | only IIS | IIS or Windows Services |
Labels:
ASP.Net
Create Directory Date Format in C#.Net
This is a Code for "Create Directory Date Format in C#.net"
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
namespace GetOfficeVersion
{
class ClsDirectory
{
public static void CreateDirectory(string DesignationPath)
{
if (!Directory.Exists(DesignationPath))
{
Directory.CreateDirectory(DesignationPath);
}
}
public static string currentYear()
{
string Year = string.Empty;
DateTime dt = DateTime.Now;
string format = "yyyy";
Year = dt.ToString(format);
return Year;
}
public static string currentMonth()
{
string Month = string.Empty;
DateTime dt = DateTime.Now;
string format = "MM";
Month = dt.ToString(format);
return Month;
}
public static string currentDate()
{
string day = string.Empty;
DateTime dt = DateTime.Now;
string format = "dd";
day = dt.ToString(format); return day;
}
}
}
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
namespace GetOfficeVersion
{
class ClsDirectory
{
public static void CreateDirectory(string DesignationPath)
{
if (!Directory.Exists(DesignationPath))
{
Directory.CreateDirectory(DesignationPath);
}
}
public static string currentYear()
{
string Year = string.Empty;
DateTime dt = DateTime.Now;
string format = "yyyy";
Year = dt.ToString(format);
return Year;
}
public static string currentMonth()
{
string Month = string.Empty;
DateTime dt = DateTime.Now;
string format = "MM";
Month = dt.ToString(format);
return Month;
}
public static string currentDate()
{
string day = string.Empty;
DateTime dt = DateTime.Now;
string format = "dd";
day = dt.ToString(format); return day;
}
}
}
Labels:
C#.Net