SQL Server - Get Time Part Only From DateTime Column in 2008 / 2005

Introduction:

Here I will explain how to get only time from datetime in SQL Server 2008 / 2005 or SQL Query to get only time part from datetime column or field in SQL Server 2008 or 2005.

Description:

In previous posts I explained get only date from datetime in SQL Server, Add row items as string with comma separated values, Exception handling in SQL Server with try catch, Add identity property to existing column in sql server, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get only time from datetime in SQL Server.  

SQL Server Get List of Stored Procedures Where a Table Name is Used

Introduction:

Here I will explain SQL Server query to get a list of stored procedures where table is used or SQL query to get list of procedures which contains table name in SQL Server.

Description:

In previous posts I explained can function return multiple values in SQL Server, Difference between view & stored procedure in SQL, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get list procedures which contains particular table in SQL Server.  

SQL Server - Invalid Use of a Side-Effecting Operator 'insert' within a Function

Introduction:

Here I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

jQuery Autocomplete Clear Textbox After Select

Introduction:

Here I will explain how to clear autocomplete textbox in jQuery after select or jQuery clear autocomplete textbox after select.    

Description:

In previous posts I explained jQuery get selected text value from autocomplete, jQuery autocomplete textbox with webservice, jQuery autocomplete textbox with multiple words separated by commas, jQuery UI autocomplete textbox with database and many articles relating to autocomplete, asp.net, jQuery,  Now I will explain how to clear autocomplete textbox in jQuery after select.

SQL Server - Can Function Return Multiple Values in SQL Server 2008

Introduction:

Here I will explain how SQL Server function will return multiple values in SQL Server 2008 or return multiple values from SQL user defined function in SQL Server 2008.    

Description:

In previous posts I explained SQL Server difference between view and stored procedure, SQL Server split function example to split comma separated string, SQL Server update statement with inner joins, interview questions in asp.net, sql server, c# and many articles relating to SQL Server. Now I will explain how SQL Server function will return multiple values in SQL Server 2008.

jQuery Wiki Plugin to Show Wikipedia Description in Tooltips

Introduction:

Here I will explain how to use jQuery wikiup plugin to show or display wikipedia description in tooltips or show Wikipedia information related to word or string using jQuery wikiup plugin.

Description:
  
In previous articles I explained create simple tooltip with jQuery UI, show gridiview row details in tooltip on mouseover, jQuery Simple Slideshow example, jQuery image slideshow with text overlay, jQuery image slideshow with next and previous buttons and many articles relating to JavaScript, jQuery, asp.net. Now I will explain how to show Wikipedia information related to word or string using jQuery wikiup plugin.

SQL Server- Difference between View and Stored Procedure

Introduction:

Here I will explain difference between SQL SERVER view and stored procedure in SQL Server 2008.  

Description:

In previous posts I explained difference between wcf and web application, interview questions in asp.net, sql server, c#, Difference between functions and stored procedures in SQL Server, difference between len and datalength in sql server and many articles relating to SQL Server. Now I will explain the differences between SQL view and stored procedures.

C# - Add/Copy Rows from One Datatable to Another Datatable

Introduction:

Here I will explain simple code snippet in c# to add rows from one table to another table in vb.net, asp.net or copy rows from one datatable to another datatable in  c#, vb.net.

Description:

In Previous posts I explained using statement example in c#, Get all files from folder and subfolders in c#, Export webpage with images to pdf in asp.net and many articles relating to c#, vb.net, Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain how to add rows from one table to another table in c#, vb.net, asp.net.  

To add rows from one table to another table we need to use ImportRow function like as shown below

C# - Using Statement Example | Uses of Using Statement in C#

Introduction:

In this article I will explain uses of using statement in c# and how to declare and use using statement in c#, vb.net, Asp.net.

Description:

In Previous posts I explained lot of articles regarding Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain about using statement in c#.

Generally in our applications we will write code like create connection object to handle connectionstring after that open a connection and create command object etc. to interact with database to get data that would be like this

jQuery Get Query String Parameter Values with Spaces

Introduction: 

Here I will explain how to use jQuery to get query string parameter value with space.

Description:
  
In previous articles I explained jQuery get query string parameter values, jQuery Remove first/last character from string, Best Drag and Drop Plugin examples, Scroll back to top plugin Examples, jQuery create rounded corners for textbox and many articles relating to JQuery. Now I will explain how to get query string parameter value with space using JQuery.