Create a text box and submit button, on click
use method ="post"
next page
use request.form("Name of tHE text field")
u can use ADO to connect to ur database
% Set Conn = Server.CreateObject("ADODB.Connection")
' The following line must be changed to reflect...
You Can use DTS to do these. Create a DTS which fires up the query and using DTS export to csv file. You can automate this by scheduling the DTS Package
Hi
I have a table
Emname preference Location
David 1 Canada
David 2 Italy
Michael 1 USA
Michael 2 Japan
what iam trying to achive is
empname preferenc1 preference2
David Canada Italy
Michael USA Japan
without creating...
Strangely enough the same error popped into our system,
but we were not able to connect to our Shared drives.
The problem was because there was no memory free on our
servers, caused by running of norton antivirus.
A simple reboot did the trick, hope it works for you too,
best of luck.
I assume ur id column is the identity one. In this case
yoy have to set the value explicitly means like
3, 4 or some value. You will not be able to do a select ID
select id ( Needs an explict value like 1,3,4 etc)
See BOL
SET IDENTITY_INSERT (T-SQL)
Allows explicit values to be inserted into...
Whats the exact use of .ldf files? If we have the back up
of .mdf file, we ca attach it any time, so why do we need
the log files?
Also which option to choose for recovery?
Full, Simple or Bulk-Logged, in SQL Server 2000
CREATE PROCEDURE getAuthors
@Name varchar(20)='' ,
@FirstName varchar(20)='',
@Title Varchar(40)=''
AS
SELECT Name, FirstName, Title from
Authors
WHERE
( @Name = '' or Name like +'''+@Name + '%' + ''') and
( @FirstName = '' or FirstName like ''' + @FirstName + '%' + ''') and...
Try this it may work
Schedule The DTS package by right clicking the Package in the DTS Design Window. Now go to Jobs and Locate the Job the code, which shd be something like
DTSRun...
The client and server machine shd be in the same domain or
the 2 domains should have a trust relationship between them
We had this problem and we had to TCP/IP as there were in 2 different domains.
Anil
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.