Mssql serverdeki en büyük handikaplardan biri kod yazarken tablonun yapısını ve kolon tiplerini görememenizdir, Aşağıdaki prosedure 2 parametre ile çalışır, ilk parametre sizden tablo adını bekler , ikinci parametre ise schema adını ister, [code=sql] CREATE PROC dbhelp ( @TableName varchar(50) =null, @SchemaName varchar(50) = null ) AS BEGIN SELECT o.name AS ObjectName,c.name as ColumnName,TYPE_NAME(c.user_type_id) as DataType FROM sys.objects o inner join sys.columns c on o.object_id =c.object_id where o.name=@TableName and o.schema_id =schema_id(@SchemaName) END [/code] Şu kodu çalıştırırsak EXEC dbhelp 'DimEmployee','dbo' Çıktısı [code=sql] ObjectName ColumnName DataType DimEmployee EmployeeKey int DimEmployee ParentEmployeeKey int DimEmployee EmployeeNationalIDAlternateKey nvarchar DimEmployee ParentEmployeeNationalIDAlternateKey nvarchar DimEmployee SalesTerritoryKey int DimEmployee FirstName nvarchar DimEmployee LastName nvarchar DimEmployee MiddleName nvarchar DimEmployee NameStyle bit DimEmployee Title nvarchar DimEmployee HireDate date DimEmployee BirthDate date DimEmployee LoginID nvarchar DimEmployee EmailAddress nvarchar DimEmployee Phone nvarchar DimEmployee MaritalStatus nchar DimEmployee EmergencyContactName nvarchar DimEmployee EmergencyContactPhone nvarchar DimEmployee SalariedFlag bit DimEmployee Gender nchar DimEmployee PayFrequency tinyint DimEmployee BaseRate money DimEmployee VacationHours smallint DimEmployee SickLeaveHours smallint DimEmployee CurrentFlag bit DimEmployee SalesPersonFlag bit DimEmployee DepartmentName nvarchar DimEmployee StartDate date DimEmployee EndDate date DimEmployee Status nvarchar DimEmployee EmployeePhoto varbinary [/code] Elde etmiş oluruz, bu sayede çok büyük bir sorudan kurtulmuş oluruz.