What is Histogram?
Can you tell me how to add new column in existing views?how?How is possible?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
difference of using cursor for loop and open,fetch,close.which one is better
What are local and global Indexes and where they are useful.
what are sequences
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Explain few examples of stored procedure over triggers?
What are the different types of backups that exist?
What can be used instead of trigger?
What does asynchronous call backs means?
How do you implement session management in SQL Server mode?
How many databases Microsoft SQL server provides?
What does Master database contains?