/// <summary>
/// Create a new store procedure
/// </summary>
/// <param name="storedProcedureName"></param>
/// <param name="queryString"></param>
public static void CreateStoredProcedure(string storedProcedureName, string queryString)
{
DataTable dataTable = SQLDatabase.GetDataTable("SELECT name FROM sysobjects WHERE name = '" + storedProcedureName + "' AND type = 'P'");
if (dataTable.Rows.Count > 0)
{
SQLDatabase.ExecuteNonQuery("DROP PROCEDURE " + storedProcedureName);
}
SQLDatabase.ExecuteNonQuery("CREATE PROC " + storedProcedureName + "\r\n" + queryString);
}
//BELOW IS OK STATEMENT ----------------------------------------------
public static int ExecuteNonQuery(string commandText)
{
return(SQLDatabase.ExecuteNonQuery(commandText, CommandType.Text));
}
