SQL Server Difference between DML, DDL, DCL and TCL Commands

Introduction:

Here I will explain what is the difference between DDL, DML, DCL and TCL commands or statements in sql server with examples. In sql server database operations like insert, update, delete, etc… categorized into multiple operations those are DDL, DML, DCL and TCL. In sql server DDL means data definition language, DML means data manipulation language, DCL means data control language and TCL means transactional control language.

Description:

In previous articles I explained find hierarchical data in sql server, cursor example in sql server,  joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, query to remove first and last characters from string in sql server and many articles relating to SQL server. Now I will explain difference between DDL, DML, DCL and TCL statements in sql server.

SQL SERVER DML, DDL, DCL and TCL Commands Examples

Introduction:

Here I will explain what is the difference between DDL, DML, DCL and TCL commands or statements in sql server with examples. In sql server database operations like insert, update, delete, etc… categorized into multiple operations those are DDL, DML, DCL and TCL. In sql server DDL means data definition language, DML means data manipulation language, DCL means data control language and TCL means transactional control language.

Description:

In previous articles I explained find hierarchical data in sql server, cursor example in sql server,  joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, query to remove first and last characters from string in sql server and many articles relating to SQL server. Now I will explain difference between DDL, DML, DCL and TCL statements in sql server.

SQL Server Add Hours (Minutes) to Current Date using DateAdd Function

Introduction:

Here I will explain how to add hours to current date using DateAdd function in sql server with example or adding hours or minutes to date in sql server. By using DateAdd function in sql server we can add hours or minutes to current date in sql server.

Description:

In previous articles I explained SQL Server get only hours, minutes, date and time from datetime, take database backup in sql server, encrypt and decrypt string in sql server, sql server interview questions for experienced, cursor example in sql server and many articles relating to SQL server. Now I will explain how to add hours or minutes to current date in sql server.

jQuery Set Dropdownlist Selected Value (Text) based on Text / Value

Introduction: 

Here I will explain how to use jQuery to set dropdownlist selected value or text based on value / text or jQuery set dropdownlist value based on value or text with example. By using jQuery map functions we can set dropdownlist selected value based on value or text.

Description:
  
In previous articles I explained jQuery autocomplete textbox with masterpage in asp.net, filter gridview with dropdownlist using filter expression in asp.net, jQuery UI datepicker with master page example, get selected values from dropdownlist in angularjs, jQuery show asp.net exception message in ajax calls and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to set dropdownlist selected value or text based on value / text in jQuery.

Set Dropdownlist Selected Value (Text) in Asp.net on Page Load / Code Behind

Introduction: 

Here I will explain how to set dropdownlist selected value on page load or code behind in asp.net using c#, vb.net or set dropdownlist selected item by value or text in asp.net using c#, vb.net. In dropdownlist we can set selected item by value or text using FindByValue and FindByText properties in asp.net using c#, vb.net.

Description:
  
In previous articles I explained dropdown validation using javascript in html, populate dropdownlist from database in asp.net, cascading dropdownlist in asp.net gridview, country, city, state cascading dropdownlist in asp.net and many articles relating to dropdownlist, gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to set dropdownlist selected value in asp.net using c#, vb.net.

Set Default Value in Dropdownlist in Asp.net using C#, VB.NET

Introduction: 

Here I will explain how to set default value in dropdownlist in asp.net using c#, vb.net or setting default value for dropdownlist in asp.net using c#, vb.net. In dropdownlist we can set default value by using selectedindex and selectedvalue properties in asp.net using c#, vb.net.

Description:
  
In previous articles I explained populate dropdownlist from database in asp.net, filter gridview with dropdownlist using filter expression in asp.net, get selected values from dropdownlist in angularjs, jQuery show asp.net exception message in ajax calls, cascading dropdownlist in gridview using asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to set default value in dropdownlist in asp.net using c#, vb.net.

SQL Server Get Only Hours, Minutes, Date, Time from DateTime Field

Introduction:

Here I will explain how to get only hours and minutes from datetime in sql server or extract / get only time from datetime field in sql server or get hours datetime in sql server  or get only minutes from sql server or query to get only date / time / hours / minutes from sql server.

Description:

In previous articles I explained joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, query to remove first and last characters from string in sql server, Pass XML file as parameter from C# to SQL stored procedure, cursor example in sql server and many articles relating to SQL server. Now I will explain how to get only date / time / hours / minutes from datetime field in sql server.

jQuery Autocomplete Textbox Example in Master Page using Web Service in Asp.net using C#, VB.net

Introduction: 

Here I will explain how to populate jQuery autocomplete textbox in master page using web service example in asp.net using c#, vb.net or bind or fill a jQuery autocomplete textbox example with master page using web service in asp.net using c#, vb.net or jQuery autocomplete textbox with content page and master page example in asp.net using c#, vb.net.

Description:
  
In previous articles I explained jQuery google currency conversion as per exchange rates example, jQuery countdown timer example, jQuery increase or decrease font size of website, jQuery autocomplete textbox with multiple words in asp.net, jQuery autocomplete with images in asp.net and many articles relating to autocomplete, css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to implement jQuery autocomplete textbox in master page using web service example in asp.net using c#, vb.net with example.

jQuery Autocomplete Clear Textbox if No Match Found in Asp.Net

Introduction: 

Here I will explain how to use jQuery to clear autocomplete textbox if no records match found in asp.net using c#, vb.net or jQuery autocomplete clear textbox if no records match found while searching in asp.net using c#, vb.net.

Description:
  
In previous articles I explained jQuery show or hide loading image in asp.net, jQuery autocomplete textbox with multiple words in asp.net, jQuery autocomplete with images in asp.net, jQuery slideup, slidedown, slidetoggle effects example and many articles relating to autocomplete, css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to clear in jQuery autocomplete textbox in asp.net with example.

jQuery Display No Results (Match) Found Message in AutoComplete in Asp.Net

Introduction: 

Here I will explain how to use jQuery to show or display no results found message in autocomplete textbox when no matching records found in asp.net using c#, vb.net or jQuery autocomplete textbox display no records found message when no matching results found in asp.net using c#, vb.net.

Description:
  
In previous articles I explained jQuery show or hide loading image in asp.net, jQuery autocomplete textbox with multiple words in asp.net, jQuery autocomplete with images in asp.net, jQuery slideup, slidedown, slidetoggle effects example and many articles relating to autocomplete, css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to display no records found message in autocomplete textbox when no matching records found in jQuery using asp.net with example.