log.txt

数据库连接查询

SELECT [t0].[ID], [t0].[UserName], [t0].[PostTime], [t0].[Message], [t0].[IsReplied], [t0].[Reply]
FROM [dbo].[tbGuestBook] AS [t0]
WHERE [t0].[ID] = @p0
-- @p0: Input Guid (Size = 0; Prec = 0; Scale = 0) [edfec4e3-aaeb-46fb-a6dd-ec6447c637fb]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1

UPDATE [dbo].[tbGuestBook]
SET [Reply] = @p5
WHERE ([ID] = @p0) AND ([UserName] = @p1) AND ([PostTime] = @p2) AND ([Message] = @p3) AND ([IsReplied] = 1) AND ([Reply] = @p4)
-- @p0: Input Guid (Size = 0; Prec = 0; Scale = 0) [edfec4e3-aaeb-46fb-a6dd-ec6447c637fb]
-- @p1: Input String (Size = 8; Prec = 0; Scale = 0) [notadmin]
-- @p2: Input DateTime (Size = 0; Prec = 0; Scale = 0) [2007-8-16 11:34:36]
-- @p3: Input String (Size = 2; Prec = 0; Scale = 0) [22]
-- @p4: Input String (Size = 15; Prec = 0; Scale = 0) [111dfgdfgdsfsdf]
-- @p5: Input String (Size = 9; Prec = 0; Scale = 0) [sdfsdfdsf]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1

SELECT [t0].[ID], [t0].[UserName], [t0].[PostTime], [t0].[Message], [t0].[IsReplied], [t0].[Reply]
FROM [dbo].[tbGuestBook] AS [t0]
ORDER BY [t0].[PostTime] DESC
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1