In earlier post, we have learnt how to generate row number for each row using a variable as MySQL does not have any system function like SQLServer’s row_number() to generate the row number. 315 more words
Tags » SQL Authority
MySQL does not have any system function like SQL Server’s row_number () to generate the row number for each row. However, it can be generated using the variable in the SELECT statement. 142 more words
A very common question which I often receive is -
“How big my table name can be?”
The answer is simple 128. You can figure this out by executing stored procedure sp_server_info on SQL Server. 205 more words
: This is a 18th episode of Notes from the Field series. Performance is very crucial subject and to come up with the right strategy along with a performance one needs to have more knowledge related to the overall performance of the server. 974 more words
Modern opportunities of electronic document management systems can significantly simplify the process of decision-making at an enterprise.
Along with the opportunities they provide, the traditional printed documentation still plays an important role by allowing to conveniently operate the required information by means of reports. 267 more words
If you are developer you must have faced situations which I am going to mention next.
A Developer’s Wish
Have you ever built a database application where you are driving your navigation with the help of Data? 511 more words
SQL SERVER - Images and media file management in SQL Server and MySQL - Coding Media Management Tools is Never Easy
A core element to both web and mobile app development is rich media management. How you approach the control of images in particular can be tricky. 657 more words