SQL Server 2005 Interview Questions 


 

SQL Server 2005 Interview Questions
i have completed MCA in coimbatore thru distance education. now i came to know that the plenty oppurtunities are there for SQL Server. so i would like to know the details of institute, place, fees.
The server with trial edition has SP2 installed. But the retail version CD is just plain raw SQL server 2005 - without SPs. When I try to upgrade the database server as Microsoft spells out, it gives an error 'Missing component error'. Can I go ahead and uninstall all the SPs and try to upgrade at that point? Any help would be great.
I am trying to import a file into sql server 2005 from excel but it has a whole lot of hidden special characters. They seem to be mostly hex A0. It wont import because the data doesnt match existing foreign keys because it has the extra characters. I've tried using the trim functions and saving to csv format but this doesnt work. I can go into ultra edit and replace all the A0s and other special characters but I have to do this regularly. Is there a quick way of getting rid of any invisible characters?
I'm taking a SQL server 2005 course, but I have an option to switch to Oracle, I just want to know which one is better to take if I'm planning to take a Java course in the future. Please help!
I have a database on MS SQL Server 2005. I would like to export one of the tables in it to a MySQL database.

What software do I need ? How do I proceed ??
I need to install SQL Server on our server to install MS Dynamics CRM 4.0. We are running Small Business Server 2003 and I need to know if SQL Server 2005 will be ok to install on it?
Oracle 9i - 9.2 Enterprise (Developer edition)
Oracle 10g -10.2 Enterprise (developer edition)
SQL Server 2005 Developer Edition
I already installed the 9i and SQL Server 2005, with the appropriate services stopped (set to manual). I am planning to install 10g on the same machine and set the appropriate services to manual. Can I have them all in one machine?
How to create a database in SQL server 2005 and connect it with a XML web service. How to do. Plzzzzzz Help me.
I already know SQL using MySQL. Now, I am planning to learn Microsoft SQL Server 2005 which has more demand. Can you recommend a good book or website?. By the way, do you know how to get Microsoft SQL Server 2005 for free?
Professionally how long does it take to become an entry level sql server 2005 developer? Any .Net language combination that you guys might suggest? I am not talking about about DBA as I know that it takes years to achieve this particular goals. Any suggestions will be greatly appreciated. Thanks for your time.
From My perl program I want to retrieve data from SQL server 2005, do i need to install any plugins for this?
How to upload video files to sql server 2005 using vb? Can any one help me?
1242526Showing 376 to 390 of 387