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...
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...
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
EMS Data Import for SQL Server is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, TXT, CSV and XML files to Microsoft SQL Server or MSDE tables. It provides adjustable import parameters, including source data formats for...
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...
Search for words that "sound like" other words in SQL Server is a tutorial in which the author explians you about how to search the words that have the same sound using built-in function such as SOUNDEX()DIFFERENCE() function. You can...
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...
Using Images and Files with SQL Server: Part 2 is a web based tutorial through which you can learn how to get the binary data of the Sql Server database and display it on the client side using ASP.NET. This tutorial uses the BinaryWriter method of...
SQL Server Data Access Components (SDAC) is a VCL/VCL .NET/CLX component library for fast direct access to Microsoft SQL Server from Delphi and C++Builder. SDAC is heavily performance- and stress-tested to provide the fastest available native...
An Introduction to XML Templates with SQL Server 2000 is an simple and easy to understand tutorial through which the programmers can get details about easy methods of using XML templates in SQL server 2000. From this artcile they can also learn... |