SQL Tutorials and .Net Tutorials

Blogger Buzz: Blogger integrates with Amazon Associates

2010-04-22T00:01:00.000-07:00

Blogger Buzz: Blogger integrates with Amazon Associates

Exe in Local Computer

2009-08-10T23:52:00.000-07:00

i also find different exe here
C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin
1.ildasm.exe
2.SqlMetal.exe
3.wsdl.exe
etc...

Ajax Nested Update Panel

2009-07-03T05:49:00.001-07:00

                                                                               Parent UpdatePanel                 Last refresh <%=DateTime.Now.ToString() %> 
                                                                                                         Nested UpdatePanel                          Last refresh <%=DateTime.Now.ToString() %>

Close() Vs Dispose Method

2009-06-26T06:18:00.000-07:00

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

2009-06-26T05:32:00.000-07:00

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

SUBSTRING() in SQL Server

2009-06-26T05:12:00.000-07:00

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

2009-06-26T04:58:00.000-07:00

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

2009-06-26T04:01:00.000-07:00

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.

Grid Javascript

2008-10-13T06:54:00.000-07:00

Cursor Use

2008-09-23T06:54:00.000-07:00

This is my First Blog on Database, that how to use the Cursor.
simple example of cursor is:-

--Copy Department for ScenarioId
DECLARE Cur_Department CURSOR
FOR SELECT DepartmentID FROM Department
WHERE ScenarioID=@intScenarioID AND (Deleted IS NULL OR Deleted=0)
OPEN Cur_Department
FETCH NEXT FROM Cur_Department INTO @intOldDepartmentID
WHILE @@FETCH_STATUS=0
BEGIN
INSERT INTO Department
(
ScenarioID,
DepartmentName,
DepartmentX,
DepartmentY,
DepartmentW,
DepartmentDescription
)
SELECT @intNewScenarioID,
DepartmentName,
DepartmentX,
DepartmentY,
DepartmentW,
DepartmentDescription
FROM Department
WHERE ScenarioID=@intScenarioID AND DepartmentID=@intOldDepartmentID AND (Deleted IS NULL OR Deleted=0)
FETCH NEXT FROM Cur_Department INTO @intOldDepartmentID
END
CLOSE Cur_Department
DEALLOCATE Cur_Department

this simple example show how to copy the previous record.

Thanks And Regards
MAHINDRAKAR G GANGADHAR