it is identity(x,y)

x = start positon

y = value to increament

You can use user defined functions that returns tables and then treat the tables returned from the function as any other table

http://www.sqlservercentral.com/Forums/Topic473301-169-1.aspx

it also helped me

and this one one too

http://msdn.microsoft.com/en-us/library/ms186755.aspx

read the following article to understand more about functions

http://www.databasejournal.com/features/mssql/article.php/3348181/User-Defined-Functions-in-Microsoft-SQL-Server-2000.htm

You can execute the stored procedure like this

USE AdventureWorks

GO

DECLARE @rc int

DECLARE @StartProductID int

DECLARE @CheckDate datetime

-- TODO: Set parameter values here.

EXECUTE @rc = [AdventureWorks].[dbo].[uspGetBillOfMaterials]

...

Try this

http://www.mssqltips.com/tip.asp?tip=1641

http://www.kimballgroup.com

Am not sure if you can do this but you can try creating a report project in VB.Net 2008

http://www.packtpub.com/article/creating-report-with-visual-studio-2008

You can research on these functions and get a simpler way to get your results

SUBSTRING

LTRIM

RTRIM

CHARINDEX

Thanks this is helpful

I found this article to be very useful on linked servers

http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx

and there more from msdn

Is this SQL Server Database Request Form the as the database design document?

http://www.psexam.com/MCQ-Collection-for-Fundamentals-of-Computer/computer-fundamentals-objective-questions-mcq-with-solutions-set-5.html

May be the people are getting it wrong did not answer it on 9 July 2010