I am confused about a few points: What is the difference between a stored procedure and a view? When should I use stored procedures, and when should I use views, in SQL Server? Do views allow the creation of dynamic queries where we can pass parameters? Which one is the fastest, and on what basis … Read more
I have a linkedserver that will change. Some procedures call the linked server like this: [10.10.100.50].dbo.SPROCEDURE_EXAMPLE. We have triggers also doing this kind of work. We need to find all places that uses [10.10.100.50] to change it. In SQL Server Management Studio Express, I didn’t find a feature like “find in whole database” in Visual … Read more
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ I have gone through several other posts and was not able to solve this problem. The part affected is something similar to this: CREATE TABLE users ( userID INT UNSIGNED NOT NULL AUTO_INCREMENT, firstName VARCHAR(24) NOT NULL, lastName VARCHAR(24) NOT NULL, … Read more
I’m looking at MySQL stored procedures and functions. What is the real difference? They seem to be similar, but a function has more limitations. I’m likely wrong, but it seems a stored procedure can do everything and more than a stored function can. Why/when would I use a procedure vs a function? 6 Answers 6
I need to check when function was changed last time. I know how to check creation date (it is in function properties window in SQL Server Management Studio). I found that in SQL Server 2000 it wasn’t possible to check modify date ( look at this post: Is it possible to determine when a stored … Read more
Is it somehow possible to create a stored procedure, when using SQLite? 5 Answers 5
I have a stored procedure that alters user data in a certain way. I pass it user_id and it does it’s thing. I want to run a query on a table and then for each user_id I find run the stored procedure once on that user_id How would I write query for this? 7 Answers … Read more
I am very impressed with the results of Dapper Micro ORM for stackoverflow.com. I am considering it for my new project and but I have one concern about that some times my project requires to have Stored Procedure and I have search a lot on web but not found anything with stored procedure. So is … Read more
I have a stored procedure that I am trying to test. I am trying to test it through SQL Management Studio. In order to run this test I enter … exec my_stored_procedure ‘param1Value’, ‘param2Value’ The final parameter is an output parameter. However, I do not know how to test a stored procedure with output parameters. … Read more
