Viewing 15 posts - 46 through 60 (of 102 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,...
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...
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...
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.
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...
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...
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...
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'...
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,...
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...
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...
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...
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
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...
December 24, 2001 at 12:16 pm
Viewing 15 posts - 46 through 60 (of 102 total)