|
Related Questions |
View Answer |
|
What are data objects?
|
View Answer
|
|
What is the difference between User Identification and Authentication?
|
View Answer
|
|
How to display the table data in XML format using SQL Server.
|
View Answer
|
|
What is XMLA in SQL Server 2005
|
View Answer
|
|
How many types of system privileges are there, Can we add or delete privileges?
|
View Answer
|
|
Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure
|
View Answer
|
|
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
|
View Answer
|
|
I was asked in an interview... "Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why.....
|
View Answer
|
|
What is a "trigger"?
|
View Answer
|
|
How do you optimize stored procedures ?
|
View Answer
|
|
What is different between int and bint?
|
View Answer
|
|
How to remove duplicate records from a table?
|
View Answer
|
|
What is the difference between "procedure" and "function"?
|
View Answer
|
|
How will you copy the structure of a table without copying the data?
|
View Answer
|
|
What is DESCRIBE command in SQL Server?What is its purpose?How to use it?
|
View Answer
|
|
What are DTS subroutines? What is their use and How do you write them?
|
View Answer
|
|
What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level? Transaction isolation levels are used when we go for transactions in stored procedures used in Transact SQL.
|
View Answer
|
|
What is the difference between the full, simple and bulk log recovery models?
|
View Answer
|
|
What does the Log Reader agent in SQL Server 2005 replication do?
|
View Answer
|
|
What does this return? select (1324 & 1024)
|
View Answer
|