Viewing 15 posts - 46 through 60 (of 103 total)
DTS has 1 disadvantage as it does not create tables with the same constraints as the original table.
quote:
DTS is the easiest way,...
Paras Shah
Evision Technologies
Mumbai, India
April 25, 2002 at 11:05 am
Yes only the schema but with all the table constraints.
quote:
the copy table you're trying to create off of the original table, does...
Paras Shah
Evision Technologies
Mumbai, India
April 18, 2002 at 5:46 am
I am using Proc Blaster free, its a good product. It has reduced my development type drastically. I can concentrate more on my other development time rather than spending more...
Paras Shah
Evision Technologies
Mumbai, India
April 17, 2002 at 11:54 pm
Yeah I tried this... this is too good! But the problem now I face is how to change the table name and the contraints name.
Paras Shah
Evision Technologies
Mumbai, India
April 17, 2002 at 11:47 pm
🙂 yeah ... but how to do it programatically... as I have to make a backup utility for my product.
quote:
One quick way...
Paras Shah
Evision Technologies
Mumbai, India
April 16, 2002 at 12:58 pm
Thankx, but by using this I am not able to copy the constraints of the tables. How is it possible to do that too? What I want is the replica...
Paras Shah
Evision Technologies
Mumbai, India
April 16, 2002 at 11:57 am
I am trying to make a backup utility where I will create an xml file from the source end and restore it on the destination end. I want to create...
Paras Shah
Evision Technologies
Mumbai, India
April 11, 2002 at 11:39 am
Your query was answered into a different thread. Anyways pasting the code here
Weekdays between two days
---------------------------------------
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
DECLARE @Cnt INT
DECLARE @Diff INT
DECLARE @OutCnt INT
SET @StartDate = '2/1/2002'...
Paras Shah
Evision Technologies
Mumbai, India
March 22, 2002 at 4:41 pm
and o.name= 'addresses' --Add this condition to the query above. Replace 'addresses' with the tablename u want to query. So your query would look like :
select c.name AS ColumnName,...
Paras Shah
Evision Technologies
Mumbai, India
March 22, 2002 at 4:34 pm
its simple... find the first day of the next month and subtract a day from it. You will get the last day of that month. To find the day, use...
Paras Shah
Evision Technologies
Mumbai, India
March 22, 2002 at 4:24 pm
In JMail you could have used .AddAttachments method to do so. Have not exactly worked with CDONTS EMail Attachments, but that too should work the same way. Dont have any...
Paras Shah
Evision Technologies
Mumbai, India
March 22, 2002 at 4:16 pm
How would it be beneficial by creating a VIEW and then querying on the VIEW? Wouldn't it add up to an extra step for the SQL Server to return a...
Paras Shah
Evision Technologies
Mumbai, India
December 25, 2001 at 2:02 pm
Thankx Steve... ROWCOUNT did not click me!
quote:
Use SET ROWCOUNT @nbefore the select and
SET ROWCOUNT 0 after.
Steve Jones
Paras Shah
Evision Technologies
Mumbai, India
December 25, 2001 at 2:53 am
But this does not the number of fridays in a particular month. So how do i find that out.
quote:
convert(varchar(6),@dte,112)+'01)will give the start...
Paras Shah
Evision Technologies
Mumbai, India
December 24, 2001 at 12:16 pm
Viewing 15 posts - 46 through 60 (of 103 total)