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
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