Tag

sql server help
Problem: How to match whole word in SQL. We very frequently face the requirement to match an entire word, while developing the website/application. Solution: This problem can be very easily handled by Microsoft SQL query. For example when you search for “ram”, if you use “%ram%” it will also match “programme”. To resolve this, we...
Read More
Problem: We face the problem of how to find out the first day and last day of a week or a month while developing a website/application. Solution: This can simply be calculated with the help of SQL queries. We can have a query executed, which ultimately calls a SQL function to do the needful. Please...
Read More