摘要:
这个小问题,搞了好几次,记录一下 SQL SERVEL 合并表之间列:如下所示 合并前: select a.DisplayTime ,count(c.InsertDate) as AppointCount from TempDataNodeTime a left join TableAppointm 阅读全文
摘要:
IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id(N'View_DataNodeByDate') AND OBJECTPROPERTY(id, N'IsView') = 1) DROP View [View_DataNodeByDate] 阅读全文