- Q You are creating an ASP.NET application that uses role-based security to allow users to access only those pages that they are authorized to access. You use a Microsoft SQL Server database to manage the list of users and roles for the ASP.NET application. A table named Roles contains a column named RoleID and a column named RoleName. A table named Users contains a column named UserID, a column named UserName, and a column named Password. A table named UserRoles contains a column named UserID and a column named RoleID. You need to create a stored procedure that returns all users who belong to a specific role. You write the following Transact-SQL code to define the stored procedure: CREATE PROCEDURE GetRoleMembers @RoleID int AS Which code segment should you use to complete the stored procedure? A. SELECT UserRoles.UserID, Users.UserName FROM Users INNER JOIN Roles UserRoles On UserRoles.RoleID = Users.UserID WHERE UserRoles.RoleID = @RoleID B. SELECT UserRoles.UserID, Users.UserName FROM UserRoles INNER JOIN Roles On UserRoles.RoleID = Roles.RoleID, Users WHERE UserRoles.RoleID = @RoleID C. SELECT UserRoles.UserID, Users.UserName FROM UserRoles INNER JOIN Users On Users.UserID = UserRoles.UserID WHERE UserRoles.RoleID = @RoleID D. SELECT Users.UserID. Users.UserName FROM Users, UserRoles INNER JOIN Roles On UserRoles.RoleID = Roles.RoleID WHERE UserRoles.RoleID = @RoleID
- Q Tell me something about Syntel.
- Q Can I send a message from thread-a to thread-b, if thread-b didn't prepare its looper?
- Q Advantages of appln servers.
- Q In which way does a Primitive data type is passed ?
- Q Commonwealth Games 2014
- Q Why is strain a major factor in aircraft engineering?
- Q Difference between tsq and tdq?
- Q Can you really take pictures and video of people without them noticing?
- Q Write a C program to determine how much money will accumulated in a bank after n years, if a known amount, p, is deposited initially and the amount collects interest at a rate of r percent per year compounded annually.
- Q The edible part of an Onion is?