'Performance Optimizations for XML Data Type in SQL Server Yukon' is a tutorial in which author describes about various method for modifying the XML datatype in the SQL server with the help of advanced technology. The author gives suggestion to...
Here is a procedure for SQL Server which can be created in a module and called from a query using InitCap([fieldname])....thanks to Paul
File List: @PSC_ReadMe_581_5.txt 1Kb sql.txt 2Kb
XML Best Practices for SQL Server Yukon is an simple tutorial in which author gives description about several methods of manipulating XML data and the methods of using it in SQL server in .NET. This simple tutorial will be helpful for ASP.NET...
XML, SQL Server 2000, and the SQLXML3 Managed Classes is an article through which programmers can gain knowledge about the process of creating customized XML documents with the help of SQLXML .NET managed classes. In this tutorial users can learn...
Extend the reach of SQL Server with SQLXML classes in .NET is an user friendly tutorial which concentrates on SQLXML, through which XML features can be used along with SQL server in .NET. In this tutorial the author explains about SQLXML classes...
This online tutorial is all about connecting the SQL server with ASP. The author narrates the linking process of SQL Server in an ASP Script. The author uses ActiveX Data Objects for this connection process. The connection pooling feature of ODBC...
This is an online tutorial which helps the developers to learn the usage of SQL server with Internet Information Server and Active Server Pages. The author tells about the configuration of SQL Server to accept the integrated security. In this...
This is an online tutorial which describes about server error logs and how to increase them using registry modifications. The tutor guides the users how to modify registry entry carefully in a friendly way to increase the SQL server error logs....
XmlDocument Cache / SQL Server nText Speed Enhancement is an article in which author explains the procedure for caching the XML document and storing it in cache memory in .NET framework. This tutorial demonstrates the process of loading the XML...
Count Records from SQL Server Database using ADO.NET, SQL, and Visual Basic.NET is a tutorial for those who needs to show the record count on the ASP page. In this tutorial author demonstrates it by calling the executescalar method. |