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.

Grid Javascript

function CheckBoxForScreenEmpty()
{
var flag=false;
var TargetBaseControl = document.getElementById('ctl00_ContentPlaceHolder1_grdTransaction');
for(var i=0; i< TargetBaseControl.rows.length;i++)
{
if(TargetBaseControl.rows(i).cells(0).children(0)!=null)
{
var theGridViewCheckBox = TargetBaseControl.rows(i).cells(0).children(0);
var ckb=TargetBaseControl.rows(i).cells(0).children(0).all[0].checked;
var txt=trim(TargetBaseControl.rows(i).cells(2).all(0).value);
if ( ckb == true && txt=='')
{
alert('transaction view name cannot be empty!');
TargetBaseControl.rows(i).cells(2).all(0).value=txt;
TargetBaseControl.rows(i).cells(2).all(0).focus();
return false;
}
}
}
}

Cursor Use

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