 |
How to create dynamic query without loosing performance.
|
| Total Hit (1656) |
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 |
Rating
 |
|
|
|
Serverside Paging using dynamic T-SQL
|
| Total Hit (2028) |
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 |
Rating
 |
|
 |
How to Kill Process by name in Windows XP/2003/2k
|
| Total Hit (3323) |
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 |
| Rating
|
|
|
|
How To Use ADO with Excel Data from Visual Basic or VBA
|
| Total Hit (1020) |
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 |
| Rating
|
|
|
|
|
|
How To Transfer Data from ADO Data Source to Excel with ADO
|
| Total Hit (1135) |
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 |
| Rating
|
|
 |
Debugging custom action in Visual Studio.net Setup project
|
| Total Hit (3792) |
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 |
| Rating
|
|
|
|
Backup and Restore of SQL Server database using easy script.
|
| Total Hit (2769) |
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 |
| Rating
|
|
|
|
Encrypt and Decrypt Data in Yukon
|
| Total Hit (1066) |
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 |
| Rating
|
|
|
|
|
|
How to create audit triggers?
|
| Total Hit (2304) |
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 |
| Rating
|
|
|
|
 |
How To Manipulate Text Files in an ASP Page
|
| Total Hit (1067) |
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 |
| Rating
|
|
 |
Integrating PayPal into E-Commerce Applications with ASP.NET
|
| Total Hit (726) |
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 |
| Rating
|
|
|
|
SQL Server 2005 Secures Your Data Like Never Before
|
| Total Hit (717) |
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 |
| Rating
|
|
|
|
|
|
|
|
|
|
|
|
How to prevent page caching in ASP.net
|
| Total Hit (2733) |
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 ASP.net this can be done by the following code.
«code LangId=2»Private Sub Page_Load(
....Read More |
| Rating
|
|
|
|
Language features - Array
|
| Total Hit (8726) |
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 |
Rating
 |
|
|
|
Language features - String
|
| Total Hit (4550) |
String is a powerful datatype which you use everyday. VB.net 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 |
Rating
 |
|
|
|
Language features - Operators
|
| Total Hit (1970) |
In this article we will see all operators supported by VB.net
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 |
| Rating
|
|
|
|
Language features - DateTime and TimeSpan Objects
|
| Total Hit (3338) |
In this article we will explore some key language features which are frequently used by VB programmers.
«big»DateTimes in VB.net«/big»
VB.net provides many new features for DateTime datatype. Unlike VB6 in VB.net you can initialize DateTime variable with verity of initial values. In VB.net you
....Read More |
| Rating
|
|
|
|
Check job status using T-SQL
|
| Total Hit (4880) |
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 |
| Rating
|
|
|
|
 |
Tigra Menu v2.0 (Free)
|
| Total Hit (3137) |
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 |
| Rating
|
|
|
|
Deploying ASP.NET Applications - Part 1
|
| Total Hit (700) |
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 |
| Rating
|
|
|
|
How to find first/last record in the group?
|
| Total Hit (4482) |
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 |
| Rating
|
|
|
|