Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
1 58481. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
3 6724write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car
12 16190How will u test the stroded procedures and functions? difference between SP and Triggers
TCS,
2 7903
What is wide table?
Why use view instead of a table?
How to concatenate two binary strings together?
Define primary key?
What is parameterized reports in ssrs ?
What is the partitioning method?
What are triggers? How do you invoke a trigger on demand?
Is sql server implemented as a service or an application? : Sql server database administration
What is resource governor in sql server?
Explain about remote stored procedure?
What do you mean by stored techniques? How would we use it?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What are the diifferences between the ms sql server vs mysql?
What is difference between Datepart() and Datename() in SqlServer?
Explain the purpose of indexes?