| Other SQL Server Interview Questions |
|| Asked @
|when u import an excel file into sql if suppose one column
has got a date field with system time attached to it what
data type u will use in sql to import it in a table?
Note: a condition is the excel file has no primary key
defined to a column...also u r importing bulk data into sql
|If there is failure during updation of certain rows, what
will be the state?
|write the query for taking database restore in sql?
|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???
|write the query for taking database backup in sql
|Can you explain the types of Joins that we can have with Sql
|how to change column into row in sql
|What is Outter Join?
|How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode?
|Accidentally i deleted my table. How can i get that table?
|how many types of store procedre in sqlserver 2000?
|How to truncate a table first before running a package?
|For more SQL Server Interview Questions Click Here |