| Other SQL Server Interview Questions |
|| Asked @
|Explain couple pf features of SQL server
|Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables?
|How are SQL Server databases physically stored under
|How many .ndf files can we create in Sql server 2005?
|How to swap the data of two columns in a table. both the
columns containing varchar values.
|What are the advantages of using views. Why do we need
views when we have SPs?
|system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
|can foreign key take role of primary key?
|Is trigger fired implicitely?
|how to give input dynamically to a insert statement in
|what is the use of database index(apart from the last
searching of records) and what is the use of composite key?
|could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
|For more SQL Server Interview Questions Click Here |