| Other SQL Server Interview Questions |
|| Asked @
|two tables with table name ship(name,year) and battle
(name,year),how to find the latest added year in the table
|How to get the count of distinct records. Please give me the
|Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times???
|The Difference between 'Count' and 'Count(*)'
|In which situation you use Self joins?
|how insert selected column only ?
|What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
|Can we drop user if user mapped to any logins
|How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
|is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
|What is the difference between windows authentication and
sql server authentication
|How cand Optimize SQL Server Stored Procedures
|For more SQL Server Interview Questions Click Here |