stored-procedures Archives

Programming, sql

IT Nursery

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 ...

June 4, 2022
0 Comments

Programming, sql-server

IT Nursery

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:...

June 3, 2022
0 Comments

linq, Programming

IT Nursery

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, ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

MySQL, Programming

IT Nursery

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 ...

June 2, 2022
0 Comments

Programming, sql-server-2008

IT Nursery

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 ...

May 28, 2022
0 Comments

Programming, sqlite

IT Nursery

Creating stored procedure and SQLite?

Is it somehow possible to create a stored procedure, when using SQLite? 5 Answers 5

May 27, 2022
0 Comments

Programming, sql

IT Nursery

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 ...

May 26, 2022
0 Comments

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 ...

May 26, 2022
0 Comments

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 ...

May 25, 2022
0 Comments