Showing posts with label sql server best questions. Show all posts
Showing posts with label sql server best questions. Show all posts

Wednesday, January 14, 2015

sql server to day question

CREATE TABLE mytable ( id INT, name VARCHAR(10) );
 GO
 INSERT mytable ( id, name )
 VALUES 
 ( 1, 'S' ), 
 ( 2 , 'P'),
 ( NULL, 'Q' ), 
 ( 4, 'T' ), 
 ( NULL, 'M' ), 
 ( 6, 'N' ); 

 SELECT COUNT(*) FROM mytable;


ANSWER: 
1) 2

2) 4

3) 6

4) NULL


post the right answer