Suresh Behera

The Microsoft .Net Junkies

News

Blogroll

Reading

Browse by Tags

All Tags » SQL (RSS)
SQL Server Interview Questions and Answers
Awsome list of SQL Server Inteview Question by Pinal Dave ...Hats off pinal. Download SQL Server Interview Questions and Answers Complete List Complete Series of SQL Server Interview Questions and Answers SQL Server Interview Questions and Answers - Introduction...
Things to Check for Debugging problem
Debugging You have created your application and resolved the build errors. You must now correct those logic errors that keep your application or stored procedures from running correctly. You can do this with the development environment integrated debugging...
Single and Double Quote for XML document
On my last article we are talking about replacing special character for XML document which was working great but our testing team able to break it again. The single and double quote character are different from NOTEPAD to Microsoft Word .Here is how it...
Posted: Feb 28 2006, 05:04 PM by Suresh Behera | with 2 comment(s)
Filed under: ,
A-Z download from Microsoft
Here is a list of all downloads in the Microsoft Download Center, grouped by product or technology. A Access Accessibility ActiMates Active Accessibility ActiveSync ActiveX Control Pad ActiveX Data Objects ActiveX Developer's Kit ADO.NET Age of Empires...
Characters filteration or validation for XML document.
I was having hard time to filer form input from a asp.net page. This page accept text as input and send to database in terms of xml formats. All are ok when the text doest not include any of the following character. It gone for toss when you use these...
Posted: Feb 24 2006, 04:24 PM by Suresh Behera | with 7 comment(s)
Filed under: ,
The Unicode Character Code Charts By Script
All list of Unicode with PDF download document. This is great help for Unicode developer. The Unicode Character Code Charts By Script Thank you for all of your comments. I modified the links. I was using desktop client for first time so made mistake ;...
Cascade Delete
This is awsome query.It saved my lots of time but again i got another error message " Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)" . Cascade Delete CREATE Procedure spDeleteRows /* Recursive row delete procedure...
Posted: Feb 14 2006, 11:59 AM by Suresh Behera | with 3 comment(s)
Filed under: ,
How to use Microsoft Excel data tables to analyze information in a database
Comparison criteria are the most commonly used criteria to extract or analyze information from a Microsoft Excel database. The value that you place under the column heading in your criteria range is compared against the records in your database. If a...
Posted: Feb 02 2006, 01:33 PM by Suresh Behera | with no comments
Filed under: ,
Time Conversion on .Net and SQL Server
There was discussion on time conversion which i faced sometime ago. So,thought to compile the links and post it here. Please read or follow the links. Please read or follow the links. In SQL Server 7.0, you need to get this information from the registry...
RDs @ GrokTalk
Great resource from Mcirosoft RDs' The GrokTalks are Up - PodCast Them Richard Hundhausen presenting SQL Server 2005 Reporting Services Report Builder Stephen Forte presenting Ranking and Windowing Functions in SQL Server 2005 Edgar Sanchez presenting...
More Posts Next page »