Re: sql expression

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Eitan <nospam@xxxxxxxxxxxxxxxxx> rambled:

How can I add input parameters to stored procedure
(And Crystal used them automatically).

Need, sample code, please.

Thanks :)

Refer to SQL Server's BOL. Everything you need to know to get you started
with stored procedures is in there.

--
KB

MCNGP #26
If you don't like techgeekpro, visit www.mcngp.com and hold down your
F5 key.


.

Relevant Pages

  • Re: date not datetime in datagrid while reading from db
    ... If you are using stored procedure to get data for dataset, ... use 'cast' and 'convert' functions of sql. ... you can refer: ...
    (microsoft.public.dotnet.general)
  • Re: Complicated stored procedure
    ... Please refer to the BOL to sp_executesql,how do we use it? ...
    (microsoft.public.sqlserver.programming)
  • Re: Query Statment is Fast But Stored Procedure is Slow
    ... WITH RECOMPILE (for more details please refer to BOL) ... "San" wrote in message ... > In a production environment we have to use the same stored procedure. ...
    (microsoft.public.sqlserver.programming)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I hope you are not suggesting you embed SQL queries into the application? ... A stored procedure logic will be exactly as fast as the algorithm you ... I understant that SQL Server supports hints. ... implementations (nestedloop, merge, hash, ..) on decent sized tables, then ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Procedures - Patterns and Practices
    ... >published the reasoning behind its opinions. ... I disagree that the debate in SQL Server related discussion forums ... If the natural key is long or spans too many ... I want to call a stored procedure that adds a customer ...
    (microsoft.public.sqlserver.programming)