Resource Responses

Search Guest Response by Email:
Total 57 responses found.
How to write a stored procedure in sql server
I didn't find any enhancement made to the Sql Server 2008 procedure when compared to earlier versions of Sql Server

Stored procedure is explored well but how it boosts the preformance is not well explained and also the definition of the Stored procedure is not prefect upto the feature of the Procedure.

On the whole Stored Procedure is neatly explained with examples. I have simplified a stored procedure from 2976 lines of code to approximately 600 lines of code.
Author: Alwyn Duraisingh      Posted Date: 06 Sep 2012
AutoCompleteExtender in ASP.NET
Instead of this approach we can get the same through JQuery in less than 7 lines of code...

This is not preferable in the real time development
Author: Alwyn Duraisingh      Posted Date: 08 Mar 2012
Case Sensitive search with SQL
We can also use VarBinary conversion to search using case-sensitive


CREATE TABLE #Test
(
Name VARCHAR(100)
)

INSERT INTO #Test
SELECT 'Alwyn'
UNION ALL SELECT 'ALWYN'
UNION ALL SELECT 'alwyn'
UNION ALL SELECT 'ALwyn'

SELECT * FROM #Test

DECLARE @Name VARCHAR(100)
SET @Name = 'Alwyn'
SELECT Name AS Result
FROM #Test
WHERE CONVERT(VARBINARY, Name) = CONVERT(VARBINARY, @Name)

DROP TABLE #Test

Author: Alwyn Duraisingh      Posted Date: 03 Jan 2012
Order of Execution of Clauses in Sql Statement.
Kushal Zamkade,

Precious resource, which can help many viewers to understand the process while executing the Query.

Keep up the Good Work.
Author: Alwyn Duraisingh      Posted Date: 03 Jan 2012
Procedure to Get the RowCount of all the Tables
This can also be achieved in a simple query


SELECT SO.[Name] AS [Table Name]
, SI.Rows AS [Rows Count]
FROM SysObjects SO
INNER JOIN Sys.SysIndexes SI
ON SO.id = SI.id
WHERE SO.XType = 'U'
AND SI.InDid < 2

Author: Alwyn Duraisingh      Posted Date: 28 Dec 2011
Event Handling of Control in JQuery
What are all the relative js file i should need to get the code run. Please add the link also while posting the JQuery resources.
Author: Alwyn Duraisingh      Posted Date: 30 Nov 2011
How to change the .aspx extension
Nice article Prem.
using this Resource a web developer could easily learn how the IIS handles the request. Thank you very much for your valuable resource.
Author: Alwyn Duraisingh      Posted Date: 21 Feb 2011
SQL Bulk Copy
Ranjith,

Please correct the error in this line of code

bulkData.DestinationTableName = "Product";

it should be like

bulkDataObj.DestinationTableName = "Product";
Author: Alwyn Duraisingh      Posted Date: 20 Oct 2010
Funny Virus
Anyone tried this? if you are really intereseted in these kinda virus, give me your email address, i have more than 20 exe's to haunt you all.

Author: Alwyn Duraisingh      Posted Date: 30 Aug 2010
String with single quote not saved in DB
This is not a wise idea to deal with.

while passing the parameter value for the stored procedure

Replace the single Quotes with "&rsquot;"

in the insert statement, replace the &rsQuot; value with the single quotes.

Author: Alwyn Duraisingh      Posted Date: 26 Aug 2010
Wonderful definitions of designations at office.
I just bursted out with laugh after a hectic work.

Thank you very much Padma for sharing this in DNS.

May god bless you in all your endeavours.

Keep posting and keep on posting this kinda jokes...

Author: Alwyn Duraisingh      Posted Date: 16 Aug 2010
Empty disk
please stop hurting singh's by posting singh's jokes;
they are really the persons of courtesy.
please let us stop writing jokes about singh's.

Author: Alwyn Duraisingh      Posted Date: 22 Jul 2010
Personality Test
Sourirajan,

If this test is really yours, i should appreciate your thinking.

This concept is really make a slip on logic.

i think i'm over stressed on my deadlines.

My huge applause to you :-)
Author: Alwyn Duraisingh      Posted Date: 22 Jul 2010
Using Search In Javascript
Hey this will work fine, if we know the string that we are going to pass inside the /../

but what will happen if we have the string in a variable?
Author: Alwyn Duraisingh      Posted Date: 20 Jul 2010
Break point not hiting problem.
Is this because of Internet Explorer Version 8.0?

What you have mentioned is for manual debugging

for debugging the dotnet code, you need to check the Common language Runtime

aspnet_wp.exe - you can attach this one for debugging.
Author: Alwyn Duraisingh      Posted Date: 19 Jul 2010
Hexaware mumbai
These days they are not conducting interview to know what are
the stuffs we have, instead they are conducting interview to
dominate us and to prove like we are still a child.
Author: Alwyn Duraisingh      Posted Date: 16 Jul 2010
IFrame Problem with ASP.NET Pages
It's always good to add the header rather than doing the settings in Internet Explorer. Vamshi, please post
if you have any header to enable active x controls in the
browser.
Author: Alwyn Duraisingh      Posted Date: 15 Jul 2010
Debug Error - Silverlight 3.0
Very nice solution with an image. looks pretty.
Nishikant is nice with his resources.
Author: Alwyn Duraisingh      Posted Date: 15 Jul 2010
Mobile Bill
It's like a Bite-Joke
Post some good jokes.

Author: Alwyn Duraisingh      Posted Date: 15 Jul 2010
How to upload file to folder using asp.net
This code works well for a specific folder,
but how to upload a file without loading a page.
Can we do it using AJAX?

Author: Alwyn Duraisingh      Posted Date: 15 Jul 2010
How to Lock a Table in SQL SERVER Using VB.NET
At this time we have to use nolock
select * from TableName(nolock)
this will show the records in the Table
even if it's locked by the Transaction.
Author: Alwyn Duraisingh      Posted Date: 15 Jul 2010
How to get session value in Javascript
it's not wise to have the session value readable.

it would create a big problem and it will be easy to misuse.

how come you restrict the right click? there are so many
browsers available in the real world, will the script support
all the browsers?
Author: Alwyn Duraisingh      Posted Date: 08 Jun 2010
Validating a TextBox to enter only Numeric values
this is really a small piece of code.

Shital, you are really awesome.

this type of coding is called crispy crispy coding...
Author: Alwyn Duraisingh      Posted Date: 07 Jun 2010
Dataset slower than Data Reader. why?
i wish to mention one more step

using dataset one can very fastly serialize the DataSet to XML
using the WriteXML method.


Author: Alwyn Duraisingh      Posted Date: 07 Jun 2010
Sardar writes exam
we are using them for humours, but they are the real heroes !!!

"Those who make others laugh are Humans
But those who make laugh to hurt others are Beasts"


Author: Alwyn Duraisingh      Posted Date: 31 May 2010
MARKETING concepts
Very nice analogy. Really nice to find out the diference in each level of marketting.

Thanks Vamshi for posting it.
Author: Alwyn Duraisingh      Posted Date: 31 May 2010
Convert Money to Indian Currency Format
The above is not a sql Server Code, Saravana kumar could have posted it in the resource section.
Author: Alwyn Duraisingh      Posted Date: 26 May 2010
Diffrence between SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY ?
What do you mean by scope and session? Can you please explain in detail with an good example. so that i can understand the key difference. now i'm not able to know how the scope look like.
please explain with a good exapmle.
Author: Alwyn Duraisingh      Posted Date: 20 May 2010
Twins
sribharanidharan,

it is a very old joke. Also it is a split one.

please post some good one which you have created on your own.

Regards,

Alwyn Duraisingh.M

Jesus Saves!!! Rest of us better make backups...
Author: Alwyn Duraisingh      Posted Date: 30 Apr 2010
Trim function in Javascript
you are wrong, LTRIM will remove the leading spaces in a string

RTRIM will remove the trailing spaces in a string.

Trim will remove leading and trailing spaces in a string.

so no need to use LTRIM and RTRIM while you are using TRIM.
Author: Alwyn Duraisingh      Posted Date: 25 Feb 2010
Split Function In SQL Server
Bunty,

This function seems like an essay writing!

We can write the function in less than 20 lines to get the result, instead of writing more than 60 lines of T-SQL statements.

Please don't use DataLength function, it would count the trailing spaces also.
Author: Alwyn Duraisingh      Posted Date: 24 Feb 2010
Trim function in Javascript
can't it be done with the below code


function Trim(InputString)
{
while (InputString.substring(0,1) == ' ')
{
InputString = InputString.substring(1, InputString.length);
}
while (InputString.substring(InputString.length-1, InputString.length) == ' ')
{
InputString = InputString.substring(0,InputString.length-1);
}
return InputString;
}



Author: Alwyn Duraisingh      Posted Date: 24 Feb 2010
Why You Need To Invest Your Money
Ebenezer,

You can post these kind of non-technical contents in indiastudychannel.com

DNS is purely meant for Technical discussion.
Author: Alwyn Duraisingh      Posted Date: 24 Feb 2010
Formatting Date and Time in Asp.Net
Hey, Very nice code!!!

Keep on posting many new codes into the code snippet section.

Also you can post the articles you have prepared for your paper presentation.
Author: Alwyn Duraisingh      Posted Date: 03 Feb 2010
ISNULL() function in MS SQL Server
your statement should be like this

set @s3 = (ISNULL(@s1, '') +' '+ ISNULL(@s2, ''))

instead of;

set @s3 = (@s1 +' '+ ISNULL(@s2, ''))

you will get the null as result if you have any null value for @s1.
Author: Alwyn Duraisingh      Posted Date: 27 Jan 2010
How to restrict page from posting back
Annela,

can you tell me in which place i have to set this?

I mean, In the OnSubmit button property or on the aspx page header?


Author: Alwyn Duraisingh      Posted Date: 27 Jan 2010
"Visual Studio .NET has detected that the specified Web server is not running ASP.NET version...
Faced the same problem,

I tried with your resolution steps, but still the error persists.

Author: Alwyn Duraisingh      Posted Date: 25 Jan 2010
Function to Convert Days into months
Soniumesh, You are wrong. i have organized the dates according to real world calender only.
Author: Alwyn Duraisingh      Posted Date: 19 Jan 2010
Alarm clock
Alarm is working fine,

but it would be nice if it has the option

to play atleast a song. so that we can have a happy beginning of a day.
Author: Alwyn Duraisingh      Posted Date: 19 Jan 2010
This is the way that work is done!
Blah Blah Blah !!!

Really higher level people will not ask the lower level people.

All the Lower people will be pushed into a situation to put Jaalra, except the Software engineers. this is the real IT Trend.

Author: Alwyn Duraisingh      Posted Date: 12 Jan 2010
Get next string replace by suffix value by Alphabet
Refer this to format your resource;

http://www.dotnetspider.com/resources/30247-Tips-for-Decorating-your-resources-get-Max.aspx
Author: Alwyn Duraisingh      Posted Date: 22 Dec 2009
Getting multiple row values in a single cell separated by comma`s in sql
I'm wondering why you have done a simple task in a complex way

can you give a try on this;


Declare @Name Varchar(Max)
Select @Name = @Name +','+ Name from abc
Select @Name as Names


Think simple :-), because every big problem will have a simple solution bounded with...


Author: Alwyn Duraisingh      Posted Date: 15 Dec 2009
Switch Case in SQL query
there is no switch case in Sql Server, only the case statement
is there in sql server. you are messed up with front End code,
i guess so.

Please use proper title, it will add credits to you only.
Author: Alwyn Duraisingh      Posted Date: 15 Dec 2009
Copy Data Between Servers
Thanks Jigar
Author: Alwyn Duraisingh      Posted Date: 08 Dec 2009
Difference between stored procedure and function
3>Procedure allow select as well as DML statement in it whereas function allow only select statement in it.

Bunty,

Can't we use insert, update... in Function?
Author: Alwyn Duraisingh      Posted Date: 07 Dec 2009
The Frog Princess.
u rock !!!!!!!!!


Author: Alwyn Duraisingh      Posted Date: 22 Nov 2009
Stuff Function in sql server
Do i have to copy the code in a image and have to attach it?
Author: Alwyn Duraisingh      Posted Date: 19 Nov 2009
Stuff Function in sql server
i'm asking u to explain about the code block and how it should be with an example.
Author: Alwyn Duraisingh      Posted Date: 18 Nov 2009
Stuff Function in sql server
May i know what does it mean to me?
Author: Alwyn Duraisingh      Posted Date: 17 Nov 2009
HOW TO GET A LIFE
Molly, How it's allowing u to post this Joke into DNS?
Author: Alwyn Duraisingh      Posted Date: 16 Nov 2009

    Next Results  


Top Contributors
TodayLast 7 Daysmore...

Awards & Gifts

Online Members

Murugesan.P
More...
 
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India