If there is failure during updation of certain rows, what will be the state?2 9008
What is the difference between Userdefined function and stored procedure? Explain and give the example also5 7201
how to dispaly a particular row details from a given table2 4365
What is a transaction and what are ACID properties?3 5272
Explain different isolation levels?4 8264
Explain Active/Active and Active/Passive cluster configurations?1 3447
What is lock escalation?1 5750
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?9 14070
Explain the storage models of OLAP?1 5979
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?1437
What are constraints? Explain different types of constraints?26 123667
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?2 8517
what operator performs pattern matching?2 9471
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
How can change procedure in sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to invoke a trigger on demand?
Explain about builtinadministrator?
What is the importance of a recovery model?
What is the purpose of sql profiler in sql server? : sql server database administration
Do you know spatial data types - geometry and geography in sql server 2008?
Explain optimistic and pessimistic concurrency?
What is the need for indexing?
What is exporting and importing utility?
What is it unwise to create wide clustered index keys?
Explain filtered indexes benefits?
what type of index will get created after executing the above statement? : Sql server database administration
What is best institute to Learn DotNET And SQL in chennai?