You do it the exact same way that you pass a parameter to a stored procedure from a batch. The fact that you invoke the stored procedure from a...

SQL Server doesn’t keep this kind of information. If you need to know when data in table was modified, you’ll need to create you own mechanism. You can...

You can use NULL as default value for all parameters and then use case in the update statement. Your set clause should look like this:

…SET suppid = CASE WHEN...

I once started working in a place and also noticed that there are few indexes that had the same structure but different names. I’ve made the mistake of deleting...

Not sure that I understand the way that you want the join, because the description that you wrote doesn’t match the results that you showed (or at least it didn’t...

If by unused you mean that no one activates the procedures and no one runs any DML statements on the tables (including select statements), then the impact would be very...

Have to admit that I started thinking that something is wrong with my email:-P

Yes you can. I've done it few times and there is no problem.

Adi

You can check for this kind of format. Take a look at the script bellow that shows you how to check for format. I think that it is...

I wouldn’t recreate the views. If you recreate the views in the wrong order, you’ll have the same problem again (e.g. if view B is based on view A...

Thank you. Nice to get a good feedback sometimes:-)

Adi

Your join is fine. This is the way that auto mode works. If you’ll look closely at your XML, you’ll see that there is a hierarchy in it....

About 13 years ago the internet was not as developed as it is today, and there were a lot of myths about it. I remember getting an email saying...

Your procedure has no transaction at all, so there could be cases where only part of the procedure will be committed.

If the procedure will encounter a...

If I now understand you correctly, you just want...