What are the types of authentications supported SQL Server
Latest Answer: 1) Windows Authentication2) SQL Server Authentication ...
How to define unique key in table? Is it possible to define one primary key and one unique key in a single table?
Latest Answer: Yes, its possible to have PRIMARY KEY and UNIQUE keys in the same table on different columns.UNIQUE key constraint allows the column to have distinct & one NULL values. ...
What is tail log backup? Where can we use it?
Latest Answer: Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time recovery.Consider a scenerio where in, we have full backup ...
How to deny insert, update, delete, update permissions for a specific user of a specific user database?
Latest Answer: So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ...
How to display list of tables from a particular database in MS-SQLHow to display description of that particular table?
Latest Answer: To Display list of tables in the database:SELECT * FROM INFROMATION_SCHEMA.TABLES WHERE TYPE='basetable'To describe the structure of a particular tableSP_HELP table_name; ...
What is the difference between Subqueries and Joins? Which is better and Why? Give an example of each.
Latest Answer: Join is a Methodology to get a data from more than one table, its work under the condition. Example: If we want to display the Employee no and his Department no SELECT Empno,Deptno FROM Emp,Dept ...
What is the Difference between Attach and Restore of a Database?
Latest Answer: Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore. ...
How many levels a trigger can be nested? Explain about nested triggers.
Latest Answer: There are up to 32 nested trigger levels. ...
How optimisation and Performance in Sql Server 2000 can be achieved?What are the steps involved?
How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.
Latest Answer: Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will ...
View page << Previous 1 2 [3] 4 5 6 7 Next >>
Go Top
