Close() Vs Dispose Method

Difference between Close() and Dispose() Method

The basic difference between Close() and Dispose() is, when a Close() method is called, any managed resource can be temporarily closed and can be opened once again. It means that, with the same object the resource can be reopened or used. Where as Dispose() method permanently removes any resource ((un)managed) from memory for cleanup and the resource no longer exists for any further processing.

Byte Count .Net

string strInputData="録";
Encoding japEnc = Encoding.GetEncoding("Shift_JIS");
int nByteCount = japEnc.GetByteCount(strInputData);
OutPut :
here Byte Count is 2.

SUBSTRING() in SQL Server

SELECT 'gangadhar',SUBSTRING('gangadhar', 1, 1)

this query returns the name in one column with only the first initial in the second column.

Output is:
gangadhar g

STUFF in Sql Server 2005

SELECT STUFF('gangadhar', 2, 3, '12345')
The following example returns a character string created by deleting three characters from the first string, gangadhar, starting at position 2, at a, and inserting the second string at the deletion point.
Output :
g12345adhar

difference between len() and datalength() in SQL Server 2005

select len(Column3) ,datalength(Column3) from dbo.tbl1

len(Column3)
1. LEN() return the Number of Character present neglecting space.
datalength(Column3)
1. DATALENGTH() return the Number of Byte , considering space.