Pls check my code for the stored procedure which i created for the companydetails including companyid P.K. Not Null int(4), companyname Not Null varchar (20), address varchar(30) where companyid is the primary key and it should be autogenerate. I also want that it should check if the name exits or not...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
riaaa
on
04-03-2007, 12:00 AM
Filed under: Primary Key, Problems loading records into database, restrict query results, return value, sql 2005, SQL 2005 ASP.NET, SQL datatable, SQL Server 2005, sql stored procedure, store procedure update, stored procedure, stored procedure insert sql, stored procedure variables WHERE clause, StoredProcedure, thanks, UPDATE, Web Forms, Database, Datatables, datatype, insert, Microsoft SQL Server 2005, .NET SQL Server 2005