Alexandre
Reputation: 13328
Insert into table which has only one column
There's a table with one column - MyTable(ID), where ID is primary key with identity(1,1). How to insert one row into this table by stored procedure?
CREATE PROC MyProc
AS
INSERT INTO [dbo].[MyTable] VALUES()
Upvotes: 0
Views: 82
Answers (1)
Related Questions
- INSERT SELECT statement with only one column for SELECT
- INSERT INTO, but retain blank columns?
- Insert values into a table using stored procedure without parameters
- Insert Into Statement - Omitting one Column
- INSERT ONLY SPECIFIC COLUMN FROM A STORED PROCEDURE RESULT
- Inserting rows into table with only one column left and with out using column names
- Insert one table values to query
- Insert into table with one column value as select query
- SQL Server single stored procedure for insertion
- Insert column procedure into table