Tagged Questions

0
votes
0answers
36 views

MySQL Stored Procedure

I am developing a database for an eCommerce website, I have written the stored procedure for the following tables, user_master, authentication_master, country_master, public_master. I have ...
0
votes
0answers
55 views

Stored Procedures and Functions in MySQL

I just need to know about Stored Procedures and Functions in MySQL. While I designing a database for an eCommerce website, I was in a situation to write stored procedure for my database, this is new ...
0
votes
1answer
533 views

How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week

I´m new to SQL Server administration. I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary). Is there some way ...
5
votes
1answer
404 views

Stored Procedures Best Practices: Fenced or Unfenced?

I believe I understand the reasons behind fenced and unfenced stored procedures. Fenced run "outside" of the database (in our case DB2) so as to prevent possible corruption of the database engine ...
0
votes
0answers
302 views

Grouping a comma separated value on common data [closed]

I have a table with col1 id int, col2 as varchar(comma seperated value) and column 3 for assigning group to them. Table looks like col1 col2 group .............................. ...