/// <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)); }