Explain what are sparse columns?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How can sql server instances be hidden? : sql server security

0 Answers  


statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  


How to list all field names in the result set using mssql_field_name()?

0 Answers  


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  


In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,






What is stored procedures?

0 Answers  


Define full outer join?

0 Answers  


What are the steps to insert a table?

0 Answers  


Is it important for a database administrator to understand the operating system and file access?

0 Answers  


What is an indexed view?

0 Answers  


Explain what are db_options used for?

1 Answers   InterGraph,


how many type of subquery?

2 Answers  


Categories