Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @return_value int
- EXEC @return_value = my_stored_procedure
- @MyId = 1,
- @MyDateField = GETDATE()
- SELECT 'Return Value' = @return_value
- GO
- Execute a stored procedure or function
- [ { EXEC | EXECUTE } ]
- {
- [ @return_status = ]
- { module_name [ ;number ] | @module_name_var }
- [ [ @parameter = ] { value
- | @variable [ OUTPUT ]
- | [ DEFAULT ]
- }
- ]
- [ ,...n ]
- [ WITH RECOMPILE ]
- }
- [;]
- Execute a character string
- { EXEC | EXECUTE }
- ( { @string_variable | [ N ]'tsql_string' } [ + ...n ] )
- [ AS { LOGIN | USER } = ' name ' ]
- [;]
- Execute a pass-through command against a linked server
- { EXEC | EXECUTE }
- ( { @string_variable | [ N ] 'command_string [ ? ]' } [ + ...n ]
- [ { , { value | @variable [ OUTPUT ] } } [ ...n ] ]
- )
- [ AS { LOGIN | USER } = ' name ' ]
- [ AT linked_server_name ]
- [;]
- DECLARE @now DateTime
- SET @now = GETDATE()
- DECLARE @return_value int
- EXEC @return_value = my_stored_procedure
- @MyId = 1,
- @MyDateField = @now
- SELECT 'Return Value' = @return_value
- GO
- DECLARE @test DATE;
- SET @test = GETDATE();
- DECLARE @return_value int
- EXEC @return_value = my_store procedure
- @MyId = 1,
- @MyDateField = @test
- SELECT 'Return Value' = @return_value
- GO
- DECLARE @return_value int
- EXEC @return_value = my_store procedure
- @MyId = 1,
- @MyDateField = (SELECT GETDATE())
- SELECT 'Return Value' = @return_value
- GO
- DECLARE @dt as datetime
- SET @dt=GETDATE()
- EXEC @return_value = my_store procedure
- @MyId = 1,
- @MyDateField = dt
Add Comment
Please, Sign In to add comment