Problem In Setting Date;

create table t(id int identity(1,1),name char(30),date datetime)

here the name is parsed out from a XML dataset., i want to set
getdate() to date coumn how can i set it for all rows for future inserts.,

i have given the procedure used.,


create PROCEDURE sp_sample_xml
@strXML ntext
AS
DECLARE @insert int
EXECUTE sp_xml_preparedocument @insert OUTPUT, @strXML

insert into t (SELECT * FROM OpenXML(@insert, '/NewDataSet/Table1', 2)
WITH
(
name char(30))
EXECUTE sp_xml_removedocument @insert


and exec sp_sample_xml '<NewDataSet>
<Table1><name>karthik</name></Table1></NewDataSet>