Find duplicate rows in a table? OR I have a table with one column which has many records which are not distinct. I need to find the distinct values from that column and number of times it’s repeated.
How to know how many tables contains empno as a column in a database?
Hi Friends ,i am writing this article to know how many tables contains empno as a column in a database?
How To Find age from date of birth
Hi Friends i am writing this article to find the age from date of birth
Returning String Instead of NULL:
Consider a situation in which your database table contains NULL and you don't want to return NULL but some message. Like suppose you have a Person table and a Phone Table and a person does not have a phone number so we can easily return a message saying "No Phone Number Found" instead of returning a NULL.
How can I find the last day of the month?
Hi friends i am writing this article to find the last day of the month.I think it may useful to you.
What is a deadlock “GRANT” and “REVOKE’ statements in SQL Server
What is a deadlock in SQL Server?
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.
Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other’s piece. Each process would wait indefinitely for the other to release the lock, unless one of the user processes is terminated.
Subscribe to:
Posts (Atom)