Monday , December 11 2017
Home / Tips

Tips

sql server query pagination

From SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query Pagination. In most of the applications, a common requirement is how to fetch the data from the database servers as page wise. In earlier versions of SQL Server like SQL Server 2005/2008/R2, we can implement …

Read More »

Visual Studio 2017 Poster

Visual Studio thought it would be fun to put together a poster(Visual Studio 2017 Poster) that shows off some of favorite parts of Visual Studio 2017. You’ll also see some helpful tips and tricks to improve your productivity! Visual Studio 2017 Poster: download Visual Studio download poster as pdf   …

Read More »

How to find locked tables in sql server

Locked Tables

In multiuser environments, sql server ensures the integrity of the data by setting write locks on all the tables(Locked tables) when you are updating. This prevents other users from making changes to the same tables. if the table is locked we cannot do any CRUD(insert/select/update/delete) operations on table until it …

Read More »

What’s New in Visual Studio 2017

what's new in visual studio 2017

What’s new in Visual Studio 2017: Microsoft happy to announce the release of Visual Studio 2017. This release brings a new lightweight and modular installation experience which can be tailored to your needs. by using Visual Studio 2017 to develop apps for Android, iOS, Windows, Linux, web, and cloud. Code …

Read More »

dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

dbForge-Studio-for-SQL-Server

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis.The tool will help SQL developers to perform complex database changes, version-control database changes in popular source control systems, and speed up routine tasks. dbForge Studio for SQL Server Features Overview: Devart’s …

Read More »

Google Chrome Keyboard Shortcut Keys

studyclues_chrome_shortcut

Google Chrome Keyboard Shortcut Keys: By learning a few simple keyboard shortcuts, we can speed up our Internet Access via Google Chrome Below is a listing of all the major shortcut keys used with the Google Chrome Internet browser. 1.Tab and Window Shortcut Keys: Action Shortcut Open a new window Ctrl …

Read More »

Facebook keyboard shortcut Keys

studyclues_facebook_shortcut

Facebook keyboard shortcut Keys: In Today’s Life everyone is active on Facebook,  you can use keyboard shortcuts and make your activity on facebook much easier! Facebook has shortcuts (access keys) for people who only use their keyboards to navigate.Keep in mind that keyboard shortcuts can differ by browser (ex: Firefox, …

Read More »

Dynamic Dependent Select Box using Ajax in PHP

Dynamic Dependent Select Box using Ajax in PHP

Here in this Tutorial , I want to share a code for Dynamic Dependent Select Box by using a single Table with the help of Ajax .   1.Create a Database in Xampp named it as Demo. [crayon-5a2e823ce3fdd933614339/] 2. Make A PHP file and define markup and script for select …

Read More »

30 Basic Interview Questions in PHP

30 interview questions php by studyclues.com

30 Important interview questions with answers for php freshers 1.What is PHP? PHP is an open source server side scripting language commonly used for web applications. 2.What is Open Source Software? Software in which the source codes are freely used, modify, and shared by anyone are called Open Source Software. …

Read More »
Page 1 of 2
1 2