private string GetNewRoutineText()
{
StringBuilder sb = new StringBuilder("CREATE ");
sb.AppendFormat("{0} {1}\r\n", isFunction ? "FUNCTION" : "PROCEDURE", Name);
sb.Append("/*\r\n(\r\n");
sb.Append("parameter1 INT\r\nOUT parameter2 datatype\r\n");
sb.Append(")\r\n*/\r\n");
if (isFunction)
sb.Append("RETURNS /* datatype */\r\n");
sb.Append("BEGIN\r\n");
if (isFunction)
sb.Append("RETURN /* return value */\r\n");
sb.Append("END");
return sb.ToString();
}