Thursday , October 17 2019

Sql Server Important Queries

sql_queries

Sql Server Important Queries: 1.View All Tables in a Particular Database: [crayon-5da7df45aa2ea422350268/] For example if you want to know all table names which contains Sales [crayon-5da7df45aa2f5969153106/] 2.View All Triggers in a Particular Database: [crayon-5da7df45aa2f8377746045/] 3.View Any object definition: [crayon-5da7df45aa2fb230033153/] in the place of Name we can give either table name …

Read More »

How to know when database Restored in sql server

sqldb_restore

How to know when database Restored in sql server: In some situation we want to know from which location and in which time database was restored.at that time we will use below query [crayon-5da7df45aaf7c782434680/] It will return below output: Thanks for reading this article if you like this article please …

Read More »

How to know object information in sql server

sql module

How to know object information in sql server: Suppose we are working on a supporting project or Application Maintenance and we are new to that application and we don’t have the full knowledge on that database, in that situation some times we need to work on below things we need to …

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 »

When SQL Server Uses Indexes:

When SQL Server Uses Indexes: Sql sever uses indexes of a table provided the select or update or delete statement contained “where” condition in them and more over the where condition column must be a indexed column. If the select statement contain an “order by” clause also indexes will use. …

Read More »

MVC Introduction

studyclues_mvc_intro

MVC is a Web Application Framework developed by Microsoft. Ideally it is a 3 Layer Architectural Pattern. MVC Means Model, View and  Controller.Each Layer has its own responsibility.It is Widely Used Framework in Application Development, It is Light Weight and Highly Testable presentation framework. The pattern specifies where each kind of logic …

Read More »

Lesson 8: Object In C#

studyclues_c_object

c# object: A class and an object are different things. A class defines a type of object, but it is not an object itself. An object is a concrete entity based on a class, and is sometimes referred to as an instance of a class. Objects can be created by using …

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-5da7df45abe60272227538/] 2. Make A PHP file and define markup and script for select …

Read More »
Page 4 of 12
1 2 3 4 5 6 12