如何以某个表中以某列为关键字查看;
select * from AttDayData where EmpNo like'CHCD000598'
在数据(MS-SQL)表中插入数据和更新数据;
insert into dbo.time -- insert data
(id,name)
values(3, 'herry');
update dbo.time1 set id=4 where name='coly' -- update data
select * from dbo.time --left join
left join dbo.time1
on time.id=time1.id
select * from dbo.time --right join
right join dbo.time1
on time.id = time1.id
select * from dbo.time --inner join
inner join dbo.time
on time.id=time.id
insert into dbo.time -- insert data
(id,name)
values(3, 'herry');
update dbo.time1 set id=4 where name='coly' -- change data
select * from dbo.time
union
select * from dbo.time1 --union