Skip to main content

Posts

Showing posts from June, 2016

C# - Difference between Initialization and Instantiation

Initialization Initialization means assigning initial value to variables while declaring. Example of Initialization Following is the simple example of initialization in application.   int  a; //Declaration   a = 10; //Initialization   or   int  a = 10; Instantiation Instantiation means defining or creating new object for class to access all properties like methods, operators, fields, etc. from class. Example Following is the example of defining instantiation in application. class   sampleclass  { // your code } class   Program { static   void  Main() { // Instantiating sampleclass sampleclass  sobj =  new   sampleclass (); } } If you observe above syntax we created new object by instantiating  sampleclass  class. By using new object  sobj  we can access all the methods and properties from  sampleclass  class

SQL Server 2014 Keyboard Shortcut Keys in Management Studio

Open New Query Window (Ctrl + N) Shortcut key to open new query window in  sql server  management studio is  Ctrl + N . It will open new key query window in current connection. Execute Highlighted Query (Ctrl + E) If want to execute highlighted or selected query in  sql server  management studio shortcut key is  Ctrl + E . Toggle between Open Tabs (Ctrl + Tab) If we want to toggle or switch between opened tabs in  sql server  management studio shortcut key is Ctrl + Tab . It will help us to move between opened tabs easily. Show / Hide Result Pane (Ctrl + R) By using Ctrl + R shortcut key we can show / hide result pane of executed query. We can easily make full screen by hiding / closing result pane using shortcut key  Ctrl + R . Display Estimated Execution Plan (Ctrl + L) If we want to show execution plan for queries which we are executing shortcut key is  Ctrl + L .   If we use Ctrl + L key combinations automatically it will show estimated executi