What are the different Authentication modes in SQL Server and how can you change authentication mode?
No Answer is Posted For this Question
Be the First to Post Answer
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is a self join in sql server?
What is the difference between grant and with grant while giving permissions to the user?
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
What are the benefits of normalization?
Explain “not null constraint” in sql server?
How does using a separate hard drive for several database objects improves performance right away?
Difference between report and query parameter. Why do we need different type of parameter?
Mention the 3 ways to get a count of the number of records in a table.
How many types of built in functions are there in sql server 2012?
What is use of except clause?
Where views are stored in sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)