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

Comments

EncryptByPassPhrase and DecryptByPassPhrase in sql server

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 : Dec...

Group by alias column name in sql server

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

Alltechmania

Search This Blog