Is truncate autocommit?
Can you explain the types of Joins that we can have with Sql Server?
What is index, cluster index and nonclustered index?
What is difference between views and stored procedures?
How will u find the query which is running in some other machine
4 Answers CarrizalSoft Technologies, IBM,
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
What are four major operators that can be used to combine conditions on a where clause?
What is enhanced database mirroring in sql server 2008?
How to find the date and time of last updated table?
How is foreign key related to primary key?
If a stored procedure is taking a table data type, how it looks?
What is a transaction and why is it important?
Mention the 3 ways to get a count of the number of records in a table.