Well,
USE [cpqaAnswers]
GO
CREATE TABLE [cpqa].[tbl_SB_Vendors](
Company_Name nvarchar(100),
Flat nvarchar(30),
Area nvarchar(30),
Street nvarchar(30),
City nvarchar(30),
State nvarchar(30),
Pin nvarchar(10),
Phone nvarchar(20),
Fax nvarchar(20),
E_Mail nvarchar(30),
Web_Site nvarchar(20),
ContactPerson nvarchar(20),
CreatedOn nvarchar(666)
)
CREATE PROC [cpqa].[sp_SB_SP_I_Vendors]
(
@Company_Name nvarchar(100),
@Flat nvarchar(30),
@Area nvarchar(30),
@Street nvarchar(30),
@City nvarchar(30),
@State nvarchar(30),
@Pin nvarchar(10),
@Phone nvarchar(20),
@Fax nvarchar(20),
@E_Mail nvarchar(30),
@Web_Site nvarchar(20),
@ContactPerson nvarchar(20),
@CreatedOn nvarchar(666)
)
AS
BEGIN
INSERT INTO [cpqa].[tbl_SB_Vendors]
(
Company_Name,Flat,Area,Street,City,[State],Pin,
Phone,Fax,E_Mail,Web_Site,ContactPerson,CreatedOn
)
VALUES
(
@Company_Name,@Flat,@Area,@Street,@City,@State,@Pin,
@Phone,@Fax,@E_Mail,@Web_Site,@ContactPerson,GETDATE()
)
end
EXECUTE [cpqa].[sp_SB_SP_I_Vendors] 'a', 'b', 'c', 'd' ,'e' ,'f', 'g', 'h', 'i', 'j' ,'k', 'l', 'm'
SELECT [Company_Name]
,[Flat]
,[Area]
,[Street]
,[City]
,[State]
,[Pin]
,[Phone]
,[Fax]
,[E_Mail]
,[Web_Site]
,[ContactPerson]
,[CreatedOn]
FROM [cpqaAnswers].[cpqa].[tbl_SB_Vendors]
GO
Seems to work, so ....
Company_Name Flat Area Street City State Pin Phone Fax E_Mail Web_Site ContactPerson CreatedOn
a b c d e f g h i j k l Oct 20 2013 2:43PM