I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure is a little more complicated, which is why a stored procedure is necessary. Is it possible to select the output by calling this procedure? Something like: SELECT * FROM (EXEC MyProc) AS TEMP I … Read more
I am trying to select some fields from one table and insert them into an existing table from a stored procedure. Here is what I am trying: SELECT col1, col2 INTO dbo.TableTwo FROM dbo.TableOne WHERE col3 LIKE @search_key I think SELECT … INTO … is for temporary tables which is why I get an error … Read more
I have a stored procedure that returns 80 columns, and 300 rows. I want to write a select that gets 2 of those columns. Something like SELECT col1, col2 FROM EXEC MyStoredProc ‘param1’, ‘param2’ When I used the above syntax I get the error: “Invalid Column Name”. I know the easiest solution would be to … Read more
How can I see the list of the stored procedures or stored functions in mysql command line like show tables; or show databases; commands. 18 s 18 SHOW PROCEDURE STATUS; SHOW FUNCTION STATUS;
I’ve been learning Functions and Stored Procedure for quite a while but I don’t know why and when I should use a function or a stored procedure. They look same to me, maybe because I am kinda newbie about that. Can some one tell me why? 2Best Answer 21 The difference between SP and UDF … Read more
I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like ‘%[ABD]%’; I want to search for [ABD] in all stored procedures including square brackets, but it’s not giving … Read more
How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but using a stored procedure that returns data, is not quite the same. select … Read more
