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
SQL server data recovery software easily repairs the corrupt, damaged files of SQL server version 2000 and 2005. The sql recovery software is easy to operate and recovers tables, deleted records, views, triggers, stored procedures from the .mdf...
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.
Automating Server Side Tracing in SQL Server is an reference article which helps the webmasters and developers to outline the SQL server tracing. This article provides various details about the functionalties to trace systems stored procedures and...
Developing SQL Server Database Explorer is a tutorial for those who needs to list various databases, tables and columns of the tables. In this tutorial the author gives you the sample source code for a windows based application that helps you to...
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...
How To Call SQL Server Stored Procedures in ASP.NET by Using Visual Basic.NET is an article which briefly explains the method of creating and executing the stored procedures of the Sql Server database in ASP.NET. The article demonstrates it by...
How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual Basic .NET is an article in which the author demonstrates the procedure for utilizing SQLDataAdapter objects for updating the modified data of the dataset in the...
HOWTO: SQL Server with Integrated Security, IIS on Same Machine is a tutroial which concentrates on securing the SQL server and IIS in a same machine. Here author provides step by step method for performing the security on the server from...
Part 1: Retrieving Data From SQL Server 7.0 with C# is a tutorial in which the author shows the step-by-step process of creating table in Sql Server database, establishing the DSN connection and using various object of the ADO.NET it fetches the... |