CEILING, FLOOR, ROUND FUNCTION IN SQL TO ROUND UP NEAREST WHOLE NUMBER

--CEILING ROUND TO UP

SELECT CEILING(2.3) ---------Round to 3                                         

SELECT CEILING(2.6) ---------Round to 3 

--FLOOR ROUND TO DOWN

SELECT FLOOR(2.9) -----------Round to 2

SELECT FLOOR(2.4) -----------Round to 2

----What I need is 2.6 rounds up to 3. Also 2.4 rounds to 2.

SELECT ROUND(yourvalue,0)

SELECT ROUND(2.6,0)----------Round to 3

SELECT ROUND(2.4,0)----------Round to 2

LTRIM,RTRIM,LEFT ,RIGHT AND SUBSTRING FUNCTIONS IN SQL

Ltrim and Rtrim simply remove spaces from string on the Right and Left

SELECT * FROM SampleTable WHERE LTRIM(RegNo)='String'

SELECT * FROM SampleTable WHERE RTRIM(RegNo)='String'

LEFT ,RIGHT AND SUBSTRING  FUNCTIONS IN SQL

SELECT LEFT('HELLO WORLD',6)  --OUT PUT HELLO

SELECT RIGHT('HELLO WORLD',5) --OUT PUT WORLD

SELECT SUBSTRING('HELLO WORLD',1,5) --OUT PUT HELLO 

SELECT SUBSTRING('HELLO WORLD',7,11) --OUT PUT WORLD

Create ,Alter,Drop In SQL server

Create Table In SQL server

CREATE TABLE STUDENT

(

  Name Varchar(20),

  Housename varchar(20),

  Age int,

 

)

SELECT * FROM STUDENT

Declare Temtable In SQL server

DECLARE @TEMTAB TABLE

(

  Name VARCHAR(20),

  Age INT

)

INSERT INTO @TEMTAB VALUES('MARK',30)

--TO INSERT YOUR SELECTED TABLE DATA TO TEMP TABLE FIRST YOU MUST DECLARE YOUR TABLE FIELED

--INSERT INTO @TEMTAB

--SELECT * FROM TABLENAME

SELECT * FROM @TEMTAB

Add and Drop Column From Table  

ALTER TABLE STUDENT ADD   POST VARCHAR(20)

SELECT * FROM STUDENT

ALTER TABLE STUDENT

DROP COLUMN POST

SELECT * FROM STUDENT