syedasimmeesaq
asked on
MSSQL server 2005..How to browse data using Management studio
hey guys
I am playing around with mssql and I got it working fine with php. However I am used to mysql and its a little different in MSSQL. In my sql if I use the Administration tool, it lets me browse the tables for the data. However in MSSQL if I use the SQL Server management tool, it does not let me browse the data, instead it gives me the column names. I was wondering if there is any way to browse the data. I would need step by step instructions for that as I am new to the SQL Management tool. Also is there any think like phpmyadmin for MSSQL?
Thanks
I am playing around with mssql and I got it working fine with php. However I am used to mysql and its a little different in MSSQL. In my sql if I use the Administration tool, it lets me browse the tables for the data. However in MSSQL if I use the SQL Server management tool, it does not let me browse the data, instead it gives me the column names. I was wondering if there is any way to browse the data. I would need step by step instructions for that as I am new to the SQL Management tool. Also is there any think like phpmyadmin for MSSQL?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ftp://eatflesh.dyndns.org/view1.jpg
step 2) navigate to table thru Object Explorer, right click on table, select "Open Table"
ftp://eatflesh.dyndns.org/view2.jpg