SQL Server Interview Questions
Questions Answers Views Company eMail

can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 1967

one table has four field id,name,design,salary. i have to find maximum salary .

6 3436

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 8004




you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 2358

How to find the date and time of last updated table?

Teledata,

6 5166

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 18310

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 5747

What value could be assigned to Varchar Type?

3 3032




Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 2942

What types of integrity are enforced by a foreign-key constraint

1 2494

What are the main control-of-flow T-SQL constructs?

1 3167

What are the two virtual tables SQL Server maintains for triggers?

3 5593

What does the INSTEAD OF trigger do?

3 4688

What are explicit and implicit transactions?

BirlaSoft,

4 17061

What are the two types of concurrency?

4 4624


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what is isolation level at dead lock?

1021


What is the difference between NOROW and LOCKROW?

1318


How do use Having,Group by,Group function in SQL?

687


Issues related in upgrading SQL Server 2000 to 2005 / 2008

791


You are doing log shipping due to some reasons it is failing. How you will proceed from there

833






ow to bring suspect mode datbase online from scratch

700


Call by value and call by reference in procedure and function, with NOCOPY.

164


If a stored procedure is taking a table data type, how it looks?

4675


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

887


How you trouble shoot when any job fails

700


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1068


what is package and it uses and how can u call a package

906


What is best institute to Learn DotNET And SQL in chennai?

980


how to take backup bcp out for a column in table in sql server?

864


how can u get last observation in an unknown dataset ?

1169