Jim V. questions

Jim V. answers

• Can I give a Stored Procedure permission to SET IDENTITY_INSERT?
• Using an Alias column in the where clause in ms-sql 2000
• Get list of all database users with specified role
• Using WITH NOLOCK Table Hint in Query Using View - Does it Propagate Within the View?
• SQL Server: Find most popular category of products bought per user for use in subquery