How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
3 9224How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.
1 5597What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?
4 10420Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
1 3856
What is the data type of time?
What is difference between cte and view?
What are the requirements for sql server 2016?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How to search for a string in all stored procedure in sql server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Explain what is lock escalation and what is its purpose?
What is nolock?
What is spatial and temporal data?
Where can you find the error log information? : sql server database administration
Explain about thread and memory management process of SQL?
What is sql server agent and what are the two modes of authentication in sql server?
List the data types available in mssql?
List all the types of user-defined functions?
What is meant by dirty read?