The command for listing all triggers is: show triggers; or you can access the INFORMATION_SCHEMA table directly by: select trigger_schema, trigger_name, action_statement from information_schema.triggers You can do this from version 5.0.10 onwards. More information about the TRIGGERS table is here.
You could try something like this: string sql = “SELECT dscr FROM system_settings WHERE setting IN ({0})”; string[] paramArray = settingList.Select((x, i) => “@settings” + i).ToArray(); cmd.CommandText = string.Format(sql, string.Join(“,”, paramArray)); for (int i = 0; i < settingList.Count; ++i) { cmd.Parameters.Add(new SqlParameter(“@settings” + i, settingList[i])); }
Just do this: using(var connection = new SqlConnection(ConfigurationManager.ConnectionStrings[“MyConn”].ConnectionString)) using(var command = connection.CreateCommand()) { command.CommandText = “…”; connection.Open(); command.ExecuteNonQuery(); } Not calling dispose on the command won’t do anything too bad. However, calling Dispose on it will suppress the call to the finalizer, making calling dispose a performance enhancement.
If it’s always going to be the same length, then binary(length) would be suitable. If it’s going to vary in length, use varbinary(maxlength). binary and varbinary. And, as @p.s.w.g says, you pass it from code by placing it into a suitable parameter.
Use Add if you want to make all explicit with a little bit more work. Use AddWithValue if you are lazy. AddWithValue will derive the type of the parameter of its value, so ensure that it’s the correct type. You should, for example, parse a string to int if that is the correct type. There … Read more
Each object has a list of rules DENYing and GRANTing access. REVOKE is an operation that removes a rule from the list of access rules.
Use the DataTable.Load method to fill your table with values from the SqlDataReader: using (SqlDataReader dr = command.ExecuteReader()) { var tb = new DataTable(); tb.Load(dr); return tb; }
In my experience, I would make sure I do these things: make sure it’s you that defines the data type for the parameter. ADO.NET does a decent job at guessing, but in some cases, it can be terribly off – so I would avoid this method: cmd.Parameters.Add(“@Name”).Value = “Bob”; cmd.Parameters.AddWithValue(“@Name”, “Bob”); Letting ADO.NET guess the … Read more
using DataAdapter.Fill does not load the database schema, which includes whether a column is a primary key or not, and whether a column is read-only or not. To load the database schema, use DataAdapter.FillSchema, but then that’s not your questions. using DataReader to fill a table loads the schema. So, the index column is read-only … Read more
Just change the SqlCommand.CommandText instead of creating a new SqlCommand every time. There is no need to close and reopen the connection. // Create the first command and execute var command = new SqlCommand(“<SQL Command>”, myConnection); var reader = command.ExecuteReader(); // Change the SQL Command and execute command.CommandText = “<New SQL Command>”; command.ExecuteNonQuery();