Tuesday, 10 September 2013

Sept12_2013

if not exists ( select fileid from  FileDetails where FileName='G:\New folder\StataContribution_20130905.xlsx')
insert into FileDetails values('G:\New folder\StataContribution_20130905.xlsx','G:\New folder\StataContribution','Shyam',GETDATE())

--select fileid from FileDetails where FileName='G:\New folder\StataContribution_20130905.xlsx'
select * from FileDetails 

No comments:

Post a Comment