What is the difference between a stored procedure and a view?
I am confused about a few points: What is the difference between a stored procedure and a view? When should I use stored … Read more
stored-procedures
How to find a text inside SQL Server procedures / triggers?
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 … Read more
LINQ-to-SQL vs stored procedures? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, … Read more
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
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 … Read more
MySQL stored procedure vs function, which would I use when?
I’m looking at MySQL stored procedures and functions. What is the real difference? They seem to be similar, but a function has more … Read more
How to check date of last change in stored procedure or function in SQL server
I need to check when function was changed last time. I know how to check creation date (it is in function properties window … Read more
Creating stored procedure and SQLite?
Is it somehow possible to create a stored procedure, when using SQLite? 5 Answers 5
How do I execute a stored procedure once for each row returned by query?
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 … Read more
Is there a way to call a stored procedure with Dapper?
I am very impressed with the results of Dapper Micro ORM for stackoverflow.com. I am considering it for my new project and but … Read more
Execute stored procedure with an Output parameter?
I have a stored procedure that I am trying to test. I am trying to test it through SQL Management Studio. In order … Read more