Search In
In writing the stored procedure we always need to work with the default value for the proper execution of the programs and the stored procedure we have made for the application.
So for doing it sometimes we have scenarios when we don
Following is a list of best practices for SQL Server
1) Use correct formatting
Following is a sample select query for reference:
SELECT
X.column1,
In September 2002, Mozilla Foundation developed a free, open-source and cross platform graphical interface Web Browser, known as Mozilla Firefox. Now, it’s the most popular open- sourced internet web browser around the whole
Hello, readers Today in my blog I have tried to create something different as we all see clouds in the sky , while looking over the clouds an idea to create them came in my mind and therefore I have penned it out in the blog.
In my blog, I h
Constraints in SQL are used to define rules for the table and columns in a database and also make sure that data are accurate and trusted in the database. Constraints are responsible for the termination of action if any violation is found.
Str
Retrieve last message between multiple users and display it in inbox
Hello friends today I am going to tell you how to display last conversation in Inbox. For example: In whatsapp chat list we can see the last conversation of each user. Here
In SQL, LIKE clause is basically used to search the homogeneous data using wildcard from a database. The LIKE operator is used to find out the particular string from a table's field into database.
Some wildcard examples are given as b
In a negotiation, it’s commonly accepted that there’s a winner and a loser. It doesn’t always have to be that way, and the best negotiations end in both parties leaving happy. Whatever the outcome, however, your goal is always to
Difference between @@IDENTITY, SCOPE_IDENTITY () and IDENT_CURRENT
@@IDENTITY
Syntax : SELECT @@IDENTITY
The keyword "@@IDENTITY" in current session is capable of returning newly inserted or last record id of any
App Store Optimization is a necessary element to focus for any of your mobile application uploaded to Google Play Store & Apple App Store. ASO defines the basic guidelines to meet ranking fundamentals of app stores and help apps to rise on top
