I just can not resist sharing this video which my wife took while I was reading the book I co-authored. After long debate with my wife I have decided to put this video on youtube for public viewing. I initially thought, it is good to just have this in personal collection but my wife Nupur insisted on putting it live.
[youtube=http://www.youtube.com/watch?v=l1rvrBQUU-s]
You can buy my book from Amazon.com and Flipkart. We did receive few notes from user that it is listed as out-of-stock. There may be some glitch but the book has been always available as there is enough copies of the same.
US:
India:
If you are from other countries, you can still get it from Amazon where it delivers. The content of Book4 are as listed below:
- Contraints
- After Triggers
- Other Triggers
- Views
- Updating and Maintaining Views
- Stored Procedures
- Stored Procedure Techniques
- User-Defined Functions
- SQL Error Messages
- Error Handling
- Change Tracking
- Change Data Capture
- Performance Tips by Pinal Dave
- Next Steps for Aspiring SQL Pros
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
4 Comments. Leave new
Hi Sql Team,
I Need Your Help.
I Have One Table In Which I Have one Column Having name ‘Status’.
In Which I Have Stored ‘Match’ and ‘UnMatch’. Value.
I Want the Total Num. Of match and Unmatch Values.
SELECT [Status], COUNT(*)
FROM [dbo].[Table]
GROUP BY [Status]
Good Answer
I liked it, and agree with your wife.