Category - SQL Server
Results 1 - 5 of 103
09 Apr 2015
0 Comments   465 Views
Here Mudassar Ahmed Khan has provided a tutorial with simple example that explains

- What are Cursors in SQL Server?
- What is the syntax for writing Cursors in SQL Server?
- How to write and use Cursors in SQL Server?
- Disadvantages of a Cursor in SQL Server.

Cursor is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.
06 Apr 2015
0 Comments   830 Views
Here Mudassar Ahmed Khan has explained how to write (insert) data to Excel file Sheet (.xls and .xlsx) in ASP.Net using C# and VB.Net.
The data from database will be written (inserted) into the Excel file Sheet (.xls and .xlsx) and the file will be downloaded in ASP.Net.
05 Apr 2015
0 Comments   724 Views
Here Mudassar Ahmed Khan has explained SQL Injection attack and some examples of SQL Injection in SQL Server.
03 Apr 2015
0 Comments   596 Views
Here Mudassar Ahmed Khan has explained with an example how to return value from a Stored Procedure in SQL Server. SQL Server allows to return a single integer value from a Stored Procedure using the RETURN keyword.
The Return keyword is supported in Stored Procedures of all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.
03 Apr 2015
0 Comments   419 Views
Here Mudassar Ahmed Khan has explained with example the syntax to drop a Stored Procedure in SQL Server i.e. how to delete a Stored Procedure in SQL Server.
Using this tutorial you can easily delete (Drop) an existing Stored Procedure in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.
Results 1 - 5 of 103