Guest User

Untitled

a guest
Jan 19th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. EXEC MyStoredProc @Param1='My name is: '+@Name
  2.  
  3. EXEC MyStoredProc @Param1=CONCAT('My name is: ',@Name)
  4.  
  5. declare @Var1 varchar(50)
  6. select @Var1 = 'My name is: '+@Name
  7.  
  8. EXEC MyStoredProc @Param1=@Var1
  9.  
  10. EXEC MyStoredProc @Param1=getdate()
  11.  
  12. declare @Var1 datetime
  13. select @Var1 = getdate()
  14.  
  15. EXEC MyStoredProc @Param1=@Var1
Add Comment
Please, Sign In to add comment