SQL Server Stored Procedures Optimization Tips
Here are twelve helpful tips for ensuring that you've constructed your SQL Server stored
procedures to perform in the most efficient manner possible.
1. Use stored procedures instead of heavy-duty queries.
This can reduce network traffic, as...
Hello,
Having should be used after the Group By clause. Something like this..
SELECT m.PONo, m.SubconCode
FROM POMaster m, PODetails d, GoodsReceipt g
WHERE m.PONo=d.PONo and d.PONo=g.PONo and d.ItemNo=g.ItemNo
GROUP BY m.PONo,m.SubconCode,d.QtyOrder
HAVING SUM(g.QtyRecv) >...
Hi,
I need to generate HTML files and mail to various users as attachments. This HTML file would typically consists of the task details for each employee and project. Each HTML file might be upto 1-2 MB depending on the data. And there maybe thousands of mails to be generated. Could anyone...
Hi,
Or Probably you can use casting also instead of setting the Quoted_Identifier Off. Like
set @sqltext = 'update tbl_claimdata set ' + cast(@colname as varchar) + ' = ' + cast(@colvalue as varchar) + ' where referencenumber = 2'
Hi,
Give the javascript function you wish to call in the form action and ur problem is solved. Like this..
<form name="test1" method="POST" action="javascript:FocusMe()" >
Hi,
For validating numbers you can use this javascript function..
<script LANGUAGE="javascript">
function OnlyNumeric(intAllowDecimal)
{
var KeyAscii = window.event.keyCode;
if (intAllowDecimal==1 && KeyAscii == 46)
{
return;
}
else
{
if ( KeyAscii < 48 || KeyAscii > 57 )...
Focus works fine even if it's a drop down. For eg..
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
<SCRIPT LANGUAGE=javascript>
<!--
function FocusMe()
{
document.test1.select1.focus();
}
-->
</SCRIPT>
</HEAD>
<BODY>
<form...
Hi,
The post method does not work with enctype="multipart/form-data" . Use a get method if the data is not too large. Or Refer this link for more details
http://forums.devshed.com/t94309/s.html
How do I check whether a textarea is empty? If the user does not enter any data but presses the enter key, then the form.textarea.value is not empty. How to keep a check on this?
Hope this article helps..
SQL 2K allows nested transactions.
For e.g.
BEGIN TRAN 1 do something BEGIN TRAN 2 do something COMMIT TRAN 2 do something
COMMIT TRAN 1
It says that all transactions become permanenet only when the outermost transaction
is committed. In the above example till...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.