Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
VB VB (1648) (736)
C# C# (15) (779)
ASP ASP (41)
VC++ VC++ (25)
JScript JScript (5)
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
» (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» (4)
» VC (3)
» HTML/CSS/JavaScript (10)
» Regular Expr Tester
» Free Tools

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with, SQL Server and other MS technologies. He is, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

How to create dynamic query without loosing performance.
Total Hit (1336) We all know that in sql server you can use exec or execute statement to execute dynamic sql statement which can be on the fly but the biggest drawback of executing dynamic query using execute is query plan is not chached by sql server and so you get poor performance if you hitting many tables and se ....Read More
Serverside Paging using dynamic T-SQL
Total Hit (1701) This stored Procedure can page records for any specified query. «code LangId=6» SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO /* Description: Page a query. Query can have order by clause or it can pass separate orderby parameter Examples: ========================= [1] Defau ....Read More
How to Kill Process by name in Windows XP/2003/2k
Total Hit (2717) Here is the most easiest way to kill running process in WinXP/2003 «code LangId=1» Private Sub Command1_Click() KillProcess "notepad.exe" '//Replace with ur process name to kill End Sub Function KillProcess(ProcessName As String, Optional strComputer As String = ".") Dim objProces ....Read More
This is a link to a different site How To Use ADO with Excel Data from Visual Basic or VBA
Total Hit (708) This article discusses the use of ActiveX Data Objects (ADO) with Microsoft Excel spreadsheets as a data source. The article also highlights syntax issues and limitations specific to Excel. This article does not discuss OLAP or PivotTable technologies or other specialized uses of Excel data. ....Read More
This is a link to a different site How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET
Total Hit (483) This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so tha ....Read More
This is a link to a different site How To Transfer Data from ADO Data Source to Excel with ADO
Total Hit (960) Because Microsoft Excel is such a powerful data analysis tool, Visual Basic and VBA application developers often want to bring data into an Excel worksheet for analysis purposes. This article describes the ActiveX Data Objects (ADO) approach to this programming task, using Microsoft Jet-specific syn ....Read More
Debugging custom action in Visual Setup project
Total Hit (3314) I had spent quite bit of time searching around and finally got something which gives you ability to debug custom action in visual studio setup project. Here is few steps to debug custom action code. Generally you write a seperate DLL which includes custom action code. To learn more about how to w ....Read More
Backup and Restore of SQL Server database using easy script.
Total Hit (2224) In this article I will show you the most common backup/restore commands. - How to take full backup of a SQL Server database. - How to resore full backup over the existing/new database. - How to restore full backup at different path over existing/new database. <b>How to take full backup of a ....Read More
This is a link to a different site Encrypt and Decrypt Data in Yukon
Total Hit (831) Reports of more than 2 million credit card numbers stolen from merchants and data brokers in early 2005 brought about the expected knee-jerk reaction from federal lawmakers— new legislation that proposes to protect individuals against identity theft, such as the "Comprehensive Identity Theft Protect ....Read More
Using INFORMATION_SCHEMA views to get schema information (i.e. tables, columns, primary keys, foreign keys ...)
Total Hit (3459) INFORMATION_SCHEMA is ANSI standard and most of modern RDBMS support it. You can use INFORMATION_SCHEMA views can be used to get various schema information i.e. Table information Column information Primary Key information etc. <b>How to get list of tables</b> «code LangId=6»SELECT * ....Read More
How to create audit triggers?
Total Hit (1994) This article will show you the most easiest way to audit your data changes for a specific table in sql server. I will show you, how to use <Code>DBCC INPUTBUFFER</Code> command to capture some valuable audit information when update/insert/delete occurs. Step-By-Step Example - Run the follow ....Read More
How to read image Width and Height in Pixel (Works in VB, ASP, VBScript)?
Total Hit (2855) You can use the following code to read image height and width in pixels. If you want to use this code in ASP or VB Script then you have to compile the code in to DLL and then you can call CreateObject Method. <b>Steps if you are using in ASP/VBScript</b> - Create an ActiveX DLL project - R ....Read More
This is a link to a different site How To Manipulate Text Files in an ASP Page
Total Hit (796) This article describes how to create, write, read, move, copy, and delete text files from within an Active Server Pages (ASP) page. You may want to use a text file for the sake of simplicity (when a database or more complicated file format may be excessive) or when prior data exists in the form o ....Read More
This is a link to a different site Integrating PayPal into E-Commerce Applications with ASP.NET
Total Hit (581) E-commerce applications require user-friendly mechanisms for payment. Although e-commerce sites usually use full credit card processing gateways, offering PayPal for payment provides an option for those who don't want to send credit card information across the Internet. ....Read More
This is a link to a different site SQL Server 2005 Secures Your Data Like Never Before
Total Hit (559) Right out of the box, SQL Server 2005 does not install many of its services (such as SQL Server Reporting Services) or does not have features turned on by default (.NET integration), thereby reducing the attack vectors that hackers could use to compromise your data security. ....Read More
Error: Collection was modified; enumeration operation may not execute.
Total Hit (2102) This is very common error when you loop collection and try to remove some item inside the loop. If you try code like below it will fail with the following error <i><font color=red>Collection was modified; enumeration operation may not execute</font></i> «code LangId=2»Dim listItem As ListItem ....Read More
This is a link to a different site How do I change the connection port on the default Terminal Server Client (installed from a Windows 2000 server)?
Total Hit (2923) When working with Terminal Server or RDP you have the choice to use either the XP RDP 5.1 client (Download RDP 5.1), or the newer Windows Server 2003 RDP 5.2 client (Download RDP 5.2). But there are still people who would like to continue working with the "old" Windows 2000 Terminal Server client, t ....Read More
Export table/query to CSV, XLS or TXT format with column headers and custom row/field terminators
Total Hit (2868) If you never used BCP then I think you have not taken it seriously. BCP gives you non-logged functionality which is tremendously faster than logged operations. Many times we have requirements to export data from SQL server to disk file which can be CSV, XLS or text format. Generally people write pro ....Read More
Send email using CDOSYS with user defined SMTP port and other settings.
Total Hit (3053) provides classes to send SMTP email. System.Web.Mail and System.Web.Mail.SmtpMail both class provides functionality to send emails but still to get full flexibility you should consider COM interop to use CDOSYS library. CDOSYS provides greater control on configuration (e.g. Specifying custom ....Read More
How to prevent page caching in
Total Hit (2097) Web page caching is done by your browser in order to improve the performance of webpages but sometimes its required to load fresh copy of page everytime you hit the URL even using back button of your browser. In this can be done by the following code. «code LangId=2»Private Sub Page_Load( ....Read More
Language features - Array
Total Hit (7828) Arrays allow you to refer to a series of variables by the same name and to use a number, called an index or subscript, to tell them apart. This helps you create shorter and simpler code in many situations, because you can set up loops that deal efficiently with any number of elements by using the in ....Read More
Language features - String
Total Hit (4083) String is a powerful datatype which you use everyday. gives you great functionality with String class. In this article we will see some common functions of string class and will also learn about StringBuilder class for very fast string operations. <big>Facts about String class</big> <b> ....Read More
Language features - Operators
Total Hit (1674) In this article we will see all operators supported by Here is the list of operators categories «code LangId=999»<table class="dtTABLE" cellSpacing="0" id="table2" bordercolorlight="#808080" border="1" style="border-collapse: collapse" width="100%"> <tr vAlign="top"> <th wi ....Read More
Language features - DateTime and TimeSpan Objects
Total Hit (1973) In this article we will explore some key language features which are frequently used by VB programmers. «big»DateTimes in«/big» provides many new features for DateTime datatype. Unlike VB6 in you can initialize DateTime variable with verity of initial values. In you ....Read More
Check job status using T-SQL
Total Hit (4326) You can use the following stored proc to retrive status of SQL Server job. If user executing this SP is not in sysadmin then make sure that user has "Select" permission on <Code>msdb..sysjobs</Code> table and execute permission on <Code>master.dbo.xp_sqlagent_enum_jobs</Code> extended stored pro ....Read More
This is a link to a different site Google Suggest like Dictionary
Total Hit (690) This is an implementation of Google Suggest like dictionary in ASP.NET.
This is a link to a different site Tigra Menu v2.0 (Free)
Total Hit (2541) Tigra Menu is free JavaScript menu navigation component for web sites. This is the script thousands of webmasters around the world have chosen for its great feature set, flexibility and performance. Tons of support materials including cross-patform visual builder offered free of charge. No matter i ....Read More
This is a link to a different site Deploying ASP.NET Applications - Part 1
Total Hit (544) Before looking at the different steps involved in setting up and deploying an ASP.NET Web application, it is important to understand the difference between Setup and Deployment. Setup is an application or process that allows you to package up your application into an easy-to-deploy format, which can ....Read More
How to find first/last record in the group?
Total Hit (4109) Yes this is certainly a common situation where you have to write a query to only extract first or last record from the group. For example you might want to extract only first product from each category. Let's look at some examples. «code LangId=6»Drop table #TempTable Go create table #Te ....Read More
Stored procedure to Send SMTP mail from SQL SERVER 2000 (With very long email text, multiple attachments support)
Total Hit (8676) This article will show you how to use CDOSYS library (Provided with most of windows versions including win 2000, xp, 2003) to send mails from sql server. I have created a COM component so you can send emails with long body text. «code LangId=6»use master go /* Copyright © 2005 Nayan ....Read More

(Page 6 of 133) 3968 Result(s) found  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ...

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.