Category - SQL Server
Results 1 - 5 of 147
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.
Here Mudassar Ahmed Khan has explained with an example, how to dynamically change (modify) Connection String of SqlDataSource control in Code Behind in ASP.Net using C# and VB.Net.
In order to dynamically change (modify) Connection String of SqlDataSource control in ASP.Net, the SqlDataSource has to be dynamically added in Code Behind.
Here Mudassar Ahmed Khan has explained with example how to perform select, insert, edit, update, delete in Repeater control in ASP.Net using C# and VB.Net.
This process is also known as CRUD i.e. Create, Read, Update and Delete in Repeater control with SQL Server database backend in ASP.Net.
Results 1 - 5 of 147