Sql Server Materials

-- SQL stored procedure last modified date - SQL datetime to string conversion USE AdventureWorks2008 ;    GO   SELECT    SchemaName = Schema_name ( schema_id ),          SprocName = name ,          CreateDate = left( convert ( varchar , create_date , 120 ), 10 ),          ModifyDate = left( convert ( varchar , modify_date , 120 ), 10 ) FROM      sys . objects WHERE     TYPE = 'P'          AND is_ms_shipped = 0 ORDER BY SchemaName ,          SprocName GO For  above example the out put is like below . OUT PUT:    SchemaName        SprocName                 ...

create   table  Employee2000   ( eno  int , ename  varchar ( 30 ), Sal  int   ); insert   into  Employee2000  values  ( 1 , 'ANIL' , 25000 ) insert   into  Employee2000  values  ( 2 , 'SUNIL' , 24000 ) insert   into  Employee2000  values  ( 3 , 'Rajesh' , 23000 ) insert   into  Employee2000  values  ( 4 , 'Kamesh' , 22000 ) insert   into  Employee2000  values  ( 5 , 'RUPESH' , 21000 ) select sal from Employee2000 e1 where 4 =( select COUNT (*) from Employee2000 f1 where e1 . Sal < f1 . Sal )