Search results for query: *

Good question? Are you doing this from an application development perspective or running it from query analyzer. If it is from query analyzer you can just save the results of your query as a csv or txt file when you run the query (click in the results pane and click File, Save). From an...

The treeview has an event that can take care of all this. Expand/Collapse. And you can check the siblings/children of each node.

Is there any way you can put the data from dbase to a txt file and then import it to sql server. It works fine with txt files.

You can transfer your database to another server using 1 of two ways 1) SQL scripts - and create the database on the user server 2) Use sp_detach_db stored procedure to detach your database from your server and use sp_attach_db stored procedure to attach it to the user server.

Have you consider using a cursor?

Change this line: set @error_result = EXEC @myproc1 to: exec @error_result = @myproc1 then do a select on the @error_result: select ' error code ',@error_result This will do the trick.

Why not, when you do your back, create a sql script (once) and every time you restore run the sql script? It should work fine.

You can do it two ways. 1) Create a command object in ado, create the parameters for the command object, get the resultset (with a recordset) and bind the recordset to the data report. First create the report with the specific fields in the report textbox object and type in the field names in...

ie. PGB.Max = rst.RecordCount do until rst.eof 'Code to do something pgb.value = pgb.value + 1 .movenext Loop

1. First, check to see if your server/computer/whatever has the component registered. 2. If it is register, check the progid.classid names. Tellek,

I assume the activeX control you're talking about is the datatimepicker. If so you can get the date value by using VALUE. Form1.DataTimePicker1.Value will give you the value of that ocx control. Or try using the month, year, day, dayofweek, hour, minute and seconds properties to help you out. I...

Try this: SELECT @iFound = Count(ID) FROM t_Articles WHERE Title = @Title AND ID <> @ID This is much easier...

Have you considered using a hierachical recordset. It takes care of your problem more efficiently. You can get the recordset from the server as a connectionless recordset; update the records on the fly and when done you can send the recordset to the server and commit changes using updatebatch...

To copy and move files use the File::Copy module that has the copy and move modules.<br>i.e.<br><br>use File::Copy;<br>copy(&quot;file.txt&quot;,&quot;file2.txt&quot;);<br>move(&quot;file2.txt&quot;,&quot;..&quot;);<br><br>To delete a file use unlink function.<br>i.e.<br>print 'Deleted '...

What if you use a loop to go through the user inputs. Or with the TransferSpreadSheet method specify a wildcard expression to get all the files.

jimmyclams<br> <br> Another way of doing this is to create a Sub Main procedure in a general module attached to your project. In it you may show the splash screen (FromName.Show) and while it is being displayed you can do other operations like opening a database or something you would like to do...