Search results for query: *

Hi! To obtain a value using dynamic SQL, in Oracle I used EXECUTE IMMEDIATE 'SELECT name FROM emp WHERE empno = :no' INTO lcv_name USING lnv_empno where: lnv_empno variable with employee ID value lcv_name variable filled after statement execution with employee name In SQL Server i can execute...

Hi ! I need to extract data from a binary type variable the way i can extract string data using SUBSTRING. In Oracle i used UTL_RAW package, but in SQL i don't know how to do this. Can anyone help me ? Thankx!

I had to simulate a tree in SQL so a used a recursive procedure, but i receive an error message ( "Maximum stored procedure nesting level exceeded" ). What can i do to solve this situation? Does anyone know if i can remove the limits for recursive calls ? Thanx !

Hello, i'm working with T-SQL stored procedures and i am interested in obtaining the formated error message from sysmessages when a constraint violation occurs. i can obtain the error message using a select from sysmessages table based on the number of error i received through @@ERROR, but the...

Hello, i'm working with T-SQL stored procedures and i am interested in obtaining the formated error message from sysmessages when a constraint violation occurs. i can obtain the error message using a select from sysmessages table based on the number of error i received through @@ERROR, but the...

Could anyone tell me if there is a formula which i could use to give proper values ( in order to increase performance ) to parameters used in the "storage" clause from "create table" ? The params which I consider are: INITIAL, NEXT , MINEXTENTS, MAXEXTENTS, PCTINCREASE...

Could anyone tell me what should i do to be able to call a function such as OutputDebugString( string ) from within my stored procedures ? Or maybe someone knows if I can use a tool such as DebugViewer to see messages sent from within my stored procedures at runtime ... Please help me! Tankx !