Displaying 1 result from an estimated 1 matches for "pk_id".
Did you mean:
p_id
2010 Oct 03
1
Package for converting R datasets into SQL Server (create table and insert statements)?
...9;: 50 obs. of 2 variables:
$ speed: num 4 4 7 7 8 9 10 10 10 11 ...
$ dist : num 2 10 4 22 16 10 18 26 34 17 ...
>
would become
create table dbo.cars (
id int identity(1,1) not null,
speed int not null,
dist int not null,
constraint PK_id primary key clustered (id ASC)
on [PRIMARY]
)
insert into dbo.cars
values (N'4', N'2'),
(N'4', N'10'),
(N'7', N'4'),
etc.
-J