Title | Posted Date |
What operator performs in pattern matching in SQL Server | December 24, 2009 |
Which command executes the contents of a specified file? | December 24, 2009 |
Which system tables contain information on privileges granted and privileges obtained? | December 24, 2009 |
Which system table contains information on constraints on all the tables created? | December 24, 2009 |
What is the use of CASCADE CONSTRAINTS? | December 24, 2009 |
What are the Text and Image Functions? | December 24, 2009 |
Tell me some String Functions? | December 24, 2009 |
Tell me some Aggregate Functions? | December 24, 2009 |
Write a function to find distance between two points? | December 24, 2009 |
How do we rename a database through query? | December 24, 2009 |
What is a trigger? | December 24, 2009 |
What is a view? | December 24, 2009 |
What is an Index? - | December 24, 2009 |
What are the types of indexes available with SQL Server? | December 24, 2009 |
What is the basic difference between clustered and a non-clustered index | December 24, 2009 |
What is the default index for primary key | December 24, 2009 |
What are cursors? | December 24, 2009 |
Can we use Truncate command on a table which is referenced by FOREIGN KEY? | December 24, 2009 |
What is the use of DBCC commands? | December 24, 2009 |
Can you give me some DBCC command options?( | December 24, 2009 |
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? | December 24, 2009 |
What is a Linked Server? | December 24, 2009 |
In SSIS where the package related information are stored? | December 24, 2009 |
Which stored procedure will you be running to add a linked server? | December 24, 2009 |
What are the OS services that the SQL Server installation adds | December 24, 2009 |
What are the authentication modes in SQL Server? | December 24, 2009 |
What is log shipping? Can we do logshipping with SQL Server 7.0 | December 24, 2009 |
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow? | December 24, 2009 |
What is BCP? When do we use it? | December 24, 2009 |
What is DTS? | December 24, 2009 |
What''s the latest version of DTS? | December 24, 2009 |
What is the file extenstion of SSIS package | December 24, 2009 |
Which one is best DTS or BCP? | December 24, 2009 |
What should we do to copy the tables, schema and views from one SQL Server to another? | December 24, 2009 |
I need to export tables, data,relationship, constraints etc from ACCESS to sqlserver? how shall I do it | December 24, 2009 |
What is the use of SET ROWCOUNT | December 24, 2009 |
There is a DELETE statement inside a transaction. What happens if the transaction is rolled back? | December 24, 2009 |
What is a cube? | December 24, 2009 |
What is snow-flake schema? | December 24, 2009 |
What is star schema? | December 24, 2009 |
What is a fact table? | December 24, 2009 |
What is a dimension table? | December 24, 2009 |
What is the use of @@fetch_status? | December 24, 2009 |
What''s the use of @@trancount in sql server 2005 | December 24, 2009 |
Which command displays the SQL command in the SQL buffer, and then executes it? | December 25, 2009 |
What are the wildcards used for pattern matching? | December 25, 2009 |
!=, <>, ^= all denote the same operation. It is True of False | December 25, 2009 |
What are the privileges that can be granted on a table by a user to others? | December 25, 2009 |
What is the difference between TRUNCATE and DELETE commands? | December 25, 2009 |
Which command is used to create a table by copying the structure of another table? | December 25, 2009 |