Contents tagged with SQL
-
SQL Server Interview Questions and Answers
Awsome list of SQL Server Inteview Question by Pinal Dave...Hats off pinal.
-
Things to Check for Debugging problem
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 functions. These allow you to stop at procedure locations, inspect memory and register values, change variables, observe message traffic, and get a close look at how your code works or does not work.
-
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 looks and it's decimal/Hex value
-
A-Z download from Microsoft
Here is a list of all downloads in the Microsoft Download Center, grouped by product or technology.
-
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 charactes -
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
-
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)" .
-
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 record matches that value, the record is extracted or included in the group of records to be analyzed by the database functions.
-
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.
-
RDs @ GrokTalk