Explain some SQL Server 2000 Query

Home >> Dababase Interview Questions >> Sql Server Interview Questions

Posted on May 22nd , 2009 by Admin

Here are some sql server 2000 query like Sql Insert Query, Delete Sql Query, Update Sql Query and Sql Create Query:

1) Sql Insert Query:

a) How to encrypt data by using Sql Insert Query.

--: insert into table_name(Tablecolumn1, tablecolumn2,. . . . .) values ('value1', pwdencrypt('value'),. . . .)

b) How to copy data from one table to another with the help of Sql Insert Query.

--: insert into table_name(column1,column2,. . . . )

select column1, column2, . . . . from table_name2

c) Sql Insert Query using where clause

--: insert into tablename(column1,column2) select column1,column2 from tablename2 where id=value.