Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tomMuc

    Function as an inbound parameter for SP????

    @nigelrivett: thanks for that. But in my environment i can not use this solution, because we are using a dynamic TSQL generator and there we can not add this kind of "work around". So, it seems that there's no way to pass a function as a parameter to a sp? thanks as well for the hint with the...
  2. tomMuc

    sequence/auto incrementing

    sure! you can use the identity property. CREATE TABLE test ( id_key int IDENTITY(1,1) PRIMARY KEY ) definition: IDENTITY (seed , increment)
  3. tomMuc

    Function as an inbound parameter for SP????

    Hi there, is it possible to call a procedure with a function as an inbound parameter like following: exec sp_test dbo.fn_read_value() this results in an error! is there a way to pass the return value from the function to the inbound parameter of the stored procedure? thanx in advance

Part and Inventory Search

Back
Top