title: FireDAC - How to execute Stored procedure with default parameters?
body: <p>i have created following stored procedure on MS SQL Server</p>
  
  <pre><code>CREATE PROCEDURE sppl_ParamTest
   @ID int = 666
  AS
   BEGIN
    SELECT @ID;
   END
  </code></pre>
  
  <p>And trying to call it with FireDAC (without creating any parameters): </p>
  
  <pre><code>FCommand:TFDCommand;
  ...
  FCommand.Params.Clear;
  FCommand.SQL.Text:='sppl_ParamTest';
  FCommand.CommandKind:=skStoredProc
  if FCommand.Params.Count=0 then
  FCommand.Open;
  </code></pre>
  
  <p>But stored procedure returns NULL(supose to return 666)</p>
  
  <p>As i understood, its caused by FireDAC magic power to query each procedure meta data, before procedure actually calls.</p>
  
  <p>Is it possible to solve this ?</p>