Database

update a
set a.RoleId = d.RoleId
FROM UserRoles a
inner join Users b on a.UserId = b.UserId
inner join Roles c on a.RoleId = c.RoleId
inner join Roles d
where c.RoleName= 'Administrator' AND b.UserName='someuser' AND d.RoleName='AnotherRole'

Insert Into UserRoles (UserID,RoleID)
Values ((Select Userid from Users Where UserName = 'someuser'),(Select RoleID from Roles Where Rolename = 'Administrator'))

Delete From UserRoles
Where Userid = (Select Userid from Users Where UserName = 'someuser')
And Roleid = (Select RoleID from Roles Where Rolename = 'Administrator')

select * from sys.databases

USE master; 
GRANT EXECUTE ON OBJECT::dbo.sp_databases
    TO public;
GO 

exec master..sp_database

openboy2010 wrote:

using RowNum?

SELECT ROWNUM, T.*
FROM TEST_TABLE T
ORDER BY ROWNUM

openboy2010 wrote:

who can tell me the RowId in last Column?

SELECT C.ROWYOURBOAT
FROM
(SELECT COUNT(*) AS ROWCOUNT
FROM TEST_TABLE T
) A,
(SELECT ROWNUM AS ROWCOUNT, ROWID AS ROWYOURBOAT
FROM TEST_TABLE T
ORDER BY ROWNUM
) C 
WHERE A.ROWCOUNT = C.ROWCOUNT

openboy2010 wrote:

what's effect?

modified on Thursday, December 30, 2010 11:03 AM

openboy2010 wrote:

My Written English is not very well.