This tutorial is helpful for every SQL server administrators and its developers which explains them about the usage of apostrophe in a SQL statement. It clearly explains the users how to avoid apostrophe errors. Its an easy to follow tutorial for...
Counting Records in an SQL Table is an helpful tutorial for the .NET programmers to know about how to display the count of the database records. This tutorial explains it cleary with an example code. The example code is useful for the programmers...
SQLMonitor is an SQL statement tester software for local databases like Paradox, FoxPro or DBase.
Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
This is an easy to learn tutorial for the users. In this tutorial author cleary shows how to delete the data from the database table using the SQL delete statement. You can delete the records based on the specified condition in the SQL statement....
Using the XSLT document() function in .NET 1.1 is an easy to learn tutorial in which the author gives details about the procedure for migrating XML documents by using Transform() method. The author elaborates about document() function, which helps...
This is a simple tutorial that helps in inserting the records into the database table using the SQL statement. This tutorial does not use the recordset object to add the records. It uses the execute method of the connection object to run the SQL...
This online tutorial helps the developers about using apostrophe in their SQL statements. The author defines the apostrophe as SQL's illegal character. This article describes how to solve the problem of using an apostrophe in a SQL statement. The...
Using Images and Files with SQL Server: Part 1 is a tutorial which tells you the method for adding images to the Sql Server database table using various properties of the fileDataStream object. In this tutorial the author gets the size of the...
Displaying XML Data in an ASP.NET page: Binding DataGrid to an XML File / is a web based tutorial in which the author offers procedure to bind XML data with the data control by using Dataset class. The author gives details about ReadXML() method,... |