Category - SQL Server
Results 1 - 5 of 149
Here Mudassar Ahmed Khan has explained with an example, how to send user confirmation email after registration with Activation link in ASP.Net MVC Razor. The Registration Form will save (insert) data to database using Entity Framework.
User will fill up the registration form with details such as username, password, email address, etc. and these details will be saved in the database table.
In order to validate the email address of the user provided during registration, a confirmation email with activation link in sent to the email address and when user clicks the link, his email address is verified and his account gets activated.
Here Mudassar Ahmed Khan has explained with an example, how to upload files, save (insert) to database table, retrieve (display) files from database table and download the files from database table in ASP.Net MVC Razor.
Files will be uploaded and then will be saved (inserted) to database table. The saved (inserted) files will be retrieved and displayed in HTML Grid (Table) consisting of a Link for downloading the file from database.
Here Mudassar Ahmed Khan has explained with an example, how to execute multiple SQL Scripts (Queries) using GO statement in C# and VB.Net.
The records returned from multiple SELECT queries (statements) are populated into DataTables and then these DataTables will be inserted into a DataSet.
Here Mudassar Ahmed Khan has explained an example, how to insert value for Time Datatype in SQL Server.
1. Use the SQL Server Time Data Type and define its columns in Tables.
2. Understanding the precision in Time Data Type.
3. Get Current System Time.
4. How to insert Time Values using SQL Query into Tables.
Here Mudassar Ahmed Khan has provided a simple Cursor tutorial with Syntax example in SQL Server.
Cursor is supported in all SQL Server versions i.e. 2000, 2005, 2008, 2008R2, 2012 and 2014.
Results 1 - 5 of 149