select DATETIME,AAA from table convert(char(8),datetime字段,108)='00:00:00'
SELECT DATETIME, AAA FROM table CONVERT(char(8), datetime, 108) = '00:00:00' 提示语法有错啊select datetime,aaa from table where datetime like '%00:00:00%' 这个好像得不到我想要的整点记录啊,什么结果也没啊
SELECT DATETIME, AAA FROM table where CONVERT(char(8), datetime, 108) = '00:00:00' --少写了where
DELETE ECOM_Department GOSET IDENTITY_INSERT ECOM_Department ONDECLARE @ID INT DECLARE @Name VARCHAR(64) DECLARE @Parent_Code VARCHAR(64) DECLARE @InputCode VARCHAR(64)DECLARE A_Cursor CURSOR FOR SELECT [id],[Name],[Parent_Code],[InputCode] FROM [eris32db].[dbo].[ECOM_Department] OPEN A_Cursor FETCH A_Cursor INTO @ID,@Name,@Parent_Code,@InputCodeWHILE (@@fetch_status=0) BEGIN
DECLARE @PID INT DECLARE GetPID CURSOR FOR SELECT eris.[id] FROM [eris32db].[dbo].[ECOM_Department] AS eris WHERE eris.[Code] = @Parent_Code
OPEN GetPID FETCH NEXT FROM GetPID into @PID WHILE(@@fetch_status = 0) BEGIN INSERT INTO [ECOMHealth].[dbo].[ECOM_Department]([id],[Name],[Parent_id],[InputCode]) VALUES(@ID,@Name,@PID,@InputCode) END
CLOSE GetPID DEALLOCATE GetPID --少了一句 FETCH A_Cursor INTO @ID,@Name,@Parent_Code,@InputCode
END CLOSE A_Cursor DEALLOCATE A_Cursor GOSET IDENTITY_INSERT ECOM_Department OFF GO
少写了一句.另外,你的代码中没有print啊
SELECT DATETIME, AAA FROM table where CONVERT(char(8), datetime, 108) = '00:00:00' --少写了where
SELECT DATETIME, AAA FROM table where CONVERT(char(8), datetime, 108) = '00:00:00' 这个是整天的吧?整点写成什么?'%00:00'?多谢了
SELECT DATETIME, AAA FROM table where CONVERT(char(8), datetime, 108) = '%:00:00' --这个就是整点
啊,我用另外一种方法搞定了,多谢! SELECT DATETIME, aaa FROM table WHERE (DATEPART(mi, DATETIME) = 0) AND (DATEPART(ss, DATETIME) = 0)
提示语法有错啊select datetime,aaa from table where datetime like '%00:00:00%'
这个好像得不到我想要的整点记录啊,什么结果也没啊
FROM table
where CONVERT(char(8), datetime, 108) = '00:00:00' --少写了where
GOSET IDENTITY_INSERT ECOM_Department ONDECLARE @ID INT
DECLARE @Name VARCHAR(64)
DECLARE @Parent_Code VARCHAR(64)
DECLARE @InputCode VARCHAR(64)DECLARE A_Cursor CURSOR FOR
SELECT [id],[Name],[Parent_Code],[InputCode]
FROM [eris32db].[dbo].[ECOM_Department]
OPEN A_Cursor
FETCH A_Cursor INTO @ID,@Name,@Parent_Code,@InputCodeWHILE (@@fetch_status=0)
BEGIN
DECLARE @PID INT
DECLARE GetPID CURSOR FOR
SELECT eris.[id] FROM [eris32db].[dbo].[ECOM_Department] AS eris
WHERE eris.[Code] = @Parent_Code
OPEN GetPID
FETCH NEXT FROM GetPID into @PID
WHILE(@@fetch_status = 0)
BEGIN
INSERT INTO [ECOMHealth].[dbo].[ECOM_Department]([id],[Name],[Parent_id],[InputCode])
VALUES(@ID,@Name,@PID,@InputCode)
END
CLOSE GetPID
DEALLOCATE GetPID --少了一句
FETCH A_Cursor INTO @ID,@Name,@Parent_Code,@InputCode
END
CLOSE A_Cursor
DEALLOCATE A_Cursor
GOSET IDENTITY_INSERT ECOM_Department OFF
GO
FROM table
where CONVERT(char(8), datetime, 108) = '00:00:00' --少写了where
FROM table
where CONVERT(char(8), datetime, 108) = '00:00:00'
这个是整天的吧?整点写成什么?'%00:00'?多谢了
FROM table
where CONVERT(char(8), datetime, 108) = '%:00:00' --这个就是整点
SELECT DATETIME, aaa
FROM table WHERE (DATEPART(mi, DATETIME) = 0) AND (DATEPART(ss, DATETIME) = 0)