Use DATENAME and wrap the logic in a Function, not a Stored Proc declare @myTime as DateTime set @myTime = GETDATE() select @myTime select DATENAME(day, @myTime) + SUBSTRING(UPPER(DATENAME(month, @myTime)), 0,4) Returns “14OCT” Try not to use any Character / String based operations if possible when working with dates. They are numerical (a float) and performance … Read more
I believe the code and the pictures say more than I ever will. C# DB Layer (DB Layer has conn as a connection string): // Note: this is an instance (myDB in terms of the GUI Object) using System.Data; using MySql.Data.MySqlClient; … … public long MultBySeven(long theNum) { // Call a Mysql Stored Proc named … Read more
Figured it out. This is not a bug with PHP (though it used to be) – it’s a bug in some versions of phpmyadmin. The same bug intermittently reappears and is then fixed in various subversions (see above): #1312 – PROCEDURE [name] can’t return a result set in the given context This behavior appears limited … Read more
The reserved prefix that exhibits this behaviour is sp_. Not sp. A stored procedure called spAddUser will be resolved in the normal way without looking for a matching object in master. The relevant quote in books online is Avoid the use of the sp_ prefix when naming procedures. This prefix is used by SQL Server … Read more
Seems to work fine for me. I have a few suggestions: (1) stop doing all that string concatenation to build a date. You can do the same thing much easier as in: SELECT @StartDT = DATEADD(MONTH, DATEDIFF(MONTH, ‘19000101’, @MinDOS), ‘19000101’); (2) stop declaring varchar without length. And to ensure the right output, I prefer convert: … Read more
From the reference manual section B.3.2.12 Commands out of sync: B.3.2.12 Commands out of sync If you get Commands out of sync; you can’t run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute … Read more
Assuming that your collection is defined in SQL, not just in PL/SQL, you can use the TABLE operator (the definition you posted isn’t syntactically valid– you’d need to specify a length for the VARCHAR2) AND p.plc_status IN (SELECT column_value FROM TABLE( plcListchar )) Since I don’t have your tables, an example using the SCOTT schema … Read more
Permissions on tables are not checked (including DENY) if tables and proc have the same owner. They can be in different schemas too as long as the schemas have the same owner. See Ownership chaining on MSDN Edit, from a comment from a deleted answer. The context is always the current login unless EXECUTE AS … Read more
I believe there is nothing currently available in MySQL that allows access to the SQLSTATE of the last executed statement within a MySQL stored procedure. This means that … it is hard/impossible to derive the exact nature of the error. Luckily that is not true. SHOW ERRORS LIMIT 1 — for SQL-state > 2 SHOW … Read more
Victoria, You can run a stored procedure using ADO, like below… Set mobjConn = New ADODB.Connection mobjConn.Open “your connection string” Set mobjCmd = New ADODB.Command With mobjCmd .ActiveConnection = mobjConn .CommandText = “your stored procedure” .CommandType = adCmdStoredProc .CommandTimeout = 0 .Parameters.Append .CreateParameter(“your parameter name”, adInteger, adParamInput, , your parameter value) ‘ repeat as many … Read more