Alltechmania

DECLARE @tbltemp TABLE( ID INT PRIMARY KEY IDENTITY(1,1), Name VARCHAR(MAX) DEFAULT '',Admission date ) INSERT INTO @tbltemp(Name, Admission) Values('manu',getdate()), ('raju',getdate()+2), ('lohith',getdate()-30), ('venu',getdate()+2), ('madhav',getdate()-30) Select entrydate,count(Id) as noofstudents FROM ( Select Id,Name,Admission as entrydate from @tbltemp ) subdata group by entrydate

Insert multiple rows at a time in sql server synatax: insert into @extable(id,firstname,lastname) values(val1,val2,val3), (val4,val5,val6) example declare   @ extable  table ( id   int , firstname   varchar ( 50 ), lastname   varchar ( 50) insert   into   @ extable ( id , firstname , lastname ) values (1 , 'krishna' , 'kumar' ), (2 , 'kalyan' , 'goud' ), (3 , 'praveen' , 'kumar' ) select * from   @extable

This Article explains you how to Encrypt and Decrypt a text in sql server EncryptByPassPhrase: Syntax:  ENCRYPTBYPASSPHRASE ('PASSPHRASE', ‘text’) creating table Login table create table login(id int identity(1,1),username varchar(10),password varchar(100))  insert into login (username,password)values('Ramprasad',EncryptByPassPhrase('12','AAA'))  insert into login (username,password)values('venkat',EncryptByPassPhrase('12','BBB'))  insert into login (username,password)values('hemanth',EncryptByPassPhrase('12','CCC')) select * from login id username         password 1 Ramprasad         2 venkat                 3 hemanth                 now we are not able to see the passwords .To visible the Passwords we need to Decrypt the passwords DecryptByPassPhrase :      Decrypt PassPhrase takes two parameters  one is  ' PASSPHRASE ' and