Differences between Stored Procedures and Functions | Stored Procedures vs Functions (Difference between SP & UDF)

                                Hi Friends, in this article I will explain about what is the differences between stored procedures and functions in SQL Server. In many interviews this question is compulsory.

                             I already explained in the previous article Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER.

Difference between stored procedures and functions:

• Stored Procedure can return zero or n values whereas function can return 1 value.Function must return a value which is mandatory but in stored procedure it is optional. Procedure can   return multiple values (max 1024).

Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER

                                     Hi Friends, in this article I will explain about the Difference between TRUNCATE, DELETE and DROP commands in SQL SERVER.For many interviews this question is frequently asked.

First of all we know those individually after that we will know differences.

Truncate:

TRUNCATE Command  removes all the data or all rows from a table.
·         We cannot use where clause with Truncate command.
·         The operation cannot be rolled back and no triggers will be fired because it does not log individual rows.
·          As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.
·         It frees the space containing the table.
·         Identity columns are re-seeded on this operation, if no seed was defined then the default value 1 is used.
·         This is a DDL command as its resets identity columns, deallocates data pages and empties them for use of other objects in the database.

How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime

                       Hi Friends, in this article I will explain about How to add dynamic controls in VB.NET or C# windows forms or  How to add textbox at runtime or How to dynamically add control with loop at Run time.

                       Suppose if we want to add textboxes in the loop then we use this process. Suppose if we to display some number of textboxes then we can’t take the textboxes before run the code. For that time we can display textboxes at runtime. Not only textboxes we can any controls like labels, buttons, checkboxes etc.

Shortcut Keys for Visual Studio || Visual Studio ShortCut KEYS

                            Hi friends, in this article I will give some important shortcuts to Visual Studio.      
In previous articles i explained about how to readthe data from excel in VB.NET or C# windows Forms.,the TreeView Control,SiteMapDataSource Control in ASP.NET ,how to send email using Gmail in VB.NET or C#.                    

                            I think it will useful to all .NET Developers and learners. Because Shortcut keys decreases the time when we writing the code. I searched in so many sites and get some Shortcut keys and place them in below tables. I think it may useful to you. Happy reading my blog and Thanks for reading my Blog.  If you want to give any advices then give advice as comment in the comment box.

Read data from Excel in VB.NET or C# windows forms | Export data from Excel to Text file

                                    Hi friends, in this article I will explain about how to read the data from excel in VB.NET or C# windows Forms.

                                   I searched so many sites and finally get the solution of how to read the data from excel in VB.NET or C# windows Forms.You can know the How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime in the next article How to add dynamic controls in VB.NET or C# windows forms | How to add textbox at runtime | How to dynamically add control with loop at Runtime

For this first we have to add the reference Microsoft.Office.Interop.Excel.

Menu—project—Add reference—COM—Microsoft Excel 12.0 Object Library

Next come to code and imports or using Microsoft.Office.Interop.Excel