Help for this page

Select Code to Download


  1. or download this
        declare @intpos int
        declare @intuser int
    ...
        set @intuser = (select userid from [$dbname].[dbo].[users] where [
    +name] = '$user')    
        set @intpos = (select top 1 permissionid from [$dbname].[dbo].[sec
    +urity] where [userid] = @intuser order by permissionid desc)
        set @dtlastpost = (SELECT top 1  [PostDate] FROM [$dbname].[dbo].[
    +Messages] where userid = @intuser order by postdate desc    )
    
  2. or download this
    Couldn't execute statement: [Microsoft][ODBC SQL Server Driver][SQL Se
    +rver]Incorrect syntax near the keyword 'declare'. (SQL-42000)