Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BendJoe
Posting Yak Master
128 Posts |
 Posted - 2009-02-13 : 12:19:33
|
| exec Usp_InsertRolePrivilegeXRef 4,Convert(int(),Scope_Identity)What will be correct syntax for this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 12:32:45
|
| [code]DECLARE @Var intSET @Var=Scope_Identity()exec Usp_InsertRolePrivilegeXRef 4,@Var[/code] |
 |
|
|
|
|
|
Convert to int