A little About SQL Queries


Arrays in SQL Server

SQL Server 2000 and Transact-SQL have many features, but one of the most often asked for features has been the implementation of some sort of array data type. This basic programming concept is notably absent from the development platform and results in many headaches and frustrations for DBAs. New author Alex Grinberg brings us his techniques for simulating arrays in SQL Server 2000.

http://www.sqlservercentral.com/columnists/aGrinberg/thearrayinsqlserver2000.asp

Passing Array as Stored procedure parameters

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

Alter Table Syntax

http://www.w3schools.com/sql/sql_alter.asp

My Second Audio Lecture


Introduction to Windows SharePoint services 2.0 UI and administration is available below. In this session I have talked about the

  • SharePoint UI
  • Web Parts
  • Lists
  • Views
  • Users
  • Security
  • Administration
  • Alerts
  • Personal and Shared Views
  • List , Grouping filtering and Columns
  • Zones and SharePoint Pages

This sessions 1 hour long will be quite help full. Once again the session is in Urdu and English.

My next lecture is about Windows SharePoint Services Central Administration and SharePoint Object model in details.