MS SQL/Expert Profile

Average Ratings

• Knowledgeability 9.71
• Clarity of Response 9.71
• Politeness 9.91
• Response Time(hr) 41.8
• Response Time(hr, last 90 days) 49.4

• Number of Questions Today 0
• Max Questions to be Asked in a Day 3
• Total Questions (since joining AllExperts) 516
• Volunteer Since 2000-10-22
• Prestige Points 6898

Recent Reviews from Users

Read More Comments

Recent Answers from Manoj Rajshekar

2010-11-24 DBMS:

Hi Sandeep,    These two cannot be compared as they mean different.    Database schema are the logical structure of entities (like tables or other Db objects) and their relationships in a database    As

2010-09-10 db2 distinct query that pulls the first value from column 3:

Hi Debbie,    You could get the distinct and one of the values from col3.  However on what basis does a specific row for col3 get selected? Is it the first occurence of it? If that's the case is there

2010-06-01 SQl query where backend is MSaccess:

Try this,    And I assume the datatype for col C is varchar/char (essentially a string value) since you have padded zeros in the front.    select * from table where substring(ColC, 3,1) = '1'      This

2010-05-24 sql server 2000 database:

Hello Sathik,    Based on the extension mentioned they seem like backup files. You could restore them in SQL 2000 if the backups were from SQl 2000. And the way to restore them could be found in Books

2010-01-28 Move/copy database mssql2005 yo mssql2008:

Hi Trinh,    There are few ways to do this.    In SQL 2008 there is a copy database wizard which you could use to move the DB.  OR  you could detach the DBs from SQL 2005, copy the files to where your