Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
sury77
Starting Member
2 Posts |
Posted - 2010-07-07 : 09:05:38
|
Is there a way how create table for sql 2008 in vb net or do i have to use Stored Procedure |
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-07 : 09:30:17
|
A CREATE TABLE is a SQL statement and if you are able to have a SELECT statement in your vb-application then it should be possible to have a CREATE statement too.But I would not like applications to create tables in my database.Or what is your question? No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
sury77
Starting Member
2 Posts |
Posted - 2010-07-07 : 09:48:37
|
Well long story shortA lot of data take a time load in ADO Net.So i am thinking how make it faster and one way whoudl be create for each person their own table and colums.and then Fill the dataset with the right Data for the person."using batch and load just couple rows in my case doesnt do the job for example 1 row Name Bob and 1 000 000 Row Name Bob"I have to fill dataset with 1 000 000 rows to find Bobs data. I cant find anything how create table in sql using vb.net" thaks for any idea |
|
|
|
|
|