sql rank function and complex queries

This following site very usefull for ranking for student and know about complex queries


http://www.1keydata.com/sql/sql-rank.html

style Menubar

http://javascript-array.com/scripts/simple_drop_down_menu/

sql server tutorial

http://msdn.microsoft.com/en-us/library/aa258864%28v=SQL.80%29.aspx

DOT net tutorial

http://www.devmanuals.com/tutorials/ms/aspdotnet/updatedataindatabase.html

SQL SERVER ALTER TABLE COLUMN

ALTER table CHILDINVENTORY ALTER COLUMN ItemDescription varchar(8000) NULL

SP_HELP CHILDINVENTORY

get count of tables from one database

1)Get all the table name from one database

SELECT table_name FROM INFORMATION_sCHEMA.TABLES

2)count how many tables from one database

Select count(table_name) FROM INFORMATION_sCHEMA.TABLES

TABLE SCHEMA GET COLUMN NAME FROM TABLE

SELECT COLUMN_NAME FROM INFORMATION_sCHEMA.COLUMNS WHERE TABLE_NAME='TABLENAME'


or

select * from sys.columns where object_id in(select object_id from sys.tables where name='tablename')