Hi
here is the another solution..
First, you have to make sure that no one else but the administator is currently using this database.
Next, create a backup of the database. For this open...
Type: Posts; User: bhaskarjha; Keyword(s):
Hi
here is the another solution..
First, you have to make sure that no one else but the administator is currently using this database.
Next, create a backup of the database. For this open...
Create an array of ArrayList obejcts depending on the count you provide and then use it accordingly in the code.
e.g.
using System.Collection; // this namespace holds the definition for ArrayList
...
If your only intention is to save diskspace by transferring entire dabase to another server and not want to use this database on other server. Then you don't have to bother about sql server and use...
Thank you for this reply. But instead of using SQL server tools, if i have to insert records programatically say in C# what could I do?
Another option that can be applied is to use temporary table...
Use this query for the CommandText property of your selectcommand:
select name from sysobjects where xtype='U'
this works in MS sql server.
whether it solve the problem do inform me.
if your question is about adding one record at a time:
insert into <tablename> values(val1,val2,val3,...valn);
where tablename is name of the table, val1, val2 are the values you want to add...
First I would like u to understand what the event is?
Event in simple meaning is any interaction of a user to the system that causes the system to take actions is event. E.g. when you (a user)...