title: Default value for a parameter in bigquery procedure
body: <p>In SQL Server, we can specify a default value for a parameter. For eg:</p>
  <p>This procedure pattern matches the parameters passed or, if not supplied, uses the preset default (last names that start with the letter D).</p>
  <pre><code>CREATE PROCEDURE HumanResources.uspGetEmployees2
      @LastName NVARCHAR(50) = N'D%',
      @FirstName NVARCHAR(50) = N'%'
  AS
      SET NOCOUNT ON;
      SELECT FirstName, LastName, JobTitle, Department
      FROM HumanResources.vEmployeeDepartment
      WHERE FirstName LIKE @FirstName AND LastName LIKE @LastName;
  </code></pre>
  <p>I couldn't find anything related to default value for stored procedure's parameters. Is there no concept of default value for a parameter in Bigquery?</p>