摘要：--方法1：select*fromopenrowset('SQLOLEDB','server=192.168.0.67;uid=sa;pwd=password','SELECT*FROMBCM2.dbo.tbAppl')--方法2：select*fromopenrowset('SQLOLEDB','192.168.0.67';'sa';'password','SELECT*FROMBCM2.dbo... 阅读全文

摘要：ALTER PROCEDURE [dbo].[Web_Count_New_order] AS BEGIN SET NOCOUNT ON Declare @MaxDateTime0 dateTime ----------处理开始！！！ ------初始化 Select @MaxDateTime0 = Max(CountDate) from Count_State if @MaxDate... 阅读全文

摘要：1.WAITFOR --WAITFOR --例 等待1 小时2 分零3 秒后才执行SELECT 语句 waitfor delay '01:02:03' select * from employee --例 等到晚上11 点零8 分后才执行SELECT 语句 waitfor time '23:08:00' select * from employee 2.查看sqlserver版本 sel... 阅读全文