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.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 create table for sql 2008 vb net?

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.
Go to Top of Page

sury77
Starting Member

2 Posts

Posted - 2010-07-07 : 09:48:37
Well long story short
A 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
Go to Top of Page
   

- Advertisement -