Viewing 2 posts - 1 through 2 (of 2 total)
maybe try the following using object_id
If
Object_Id('<dbname>.dbo.<table_name>') is Not Null
September 6, 2007 at 1:10 am
#731713
maybe try converting the value into a date
CREATE VIEW test_IV WITH SCHEMABINDING AS
select sno, ref_val_id, ref_val_nm, ref_typ_id
from dbo.test
where exp_dt >= convert(datetime, '9999-01-01', 120)
go
June 20, 2007 at 8:30 pm
#714236