Monday, 25 July 2011

SQL SERVER

FIND NAME OF DATABASE IN SQL SERVER

select * from sys.databases

FIND NAME OF TABLES IN DATABASE

use DATABASE_NAME
go
select * from sys.tables
go

FETCH DATA FROM A TABLE

SELECT * FROM TABLE_NAME

No comments:

Post a Comment