Viewing 15 posts - 6,121 through 6,135 (of 9,643 total)
Duplicate post. Please post answers in this thread: http://www.sqlservercentral.com/Forums/Topic649461-338-1.aspx
February 3, 2009 at 7:25 pm
If this is a one-time thing why not download a product like RedGate SqlDataCompare or ApexSQL SQLDiff to transfer the data? If it is done regularly why not buy...
February 3, 2009 at 7:22 pm
Thanks for the nice comment on the article.
Well, based on what I have seen about INSTEAD OF triggers using them to make views updateable seems to be the most...
February 3, 2009 at 1:43 pm
Steve Jones - Editor (2/3/2009)
a gee-whiz fiber optic laser beam assembler?:D
Somebody has to tell me how I get one of these.
February 3, 2009 at 1:33 pm
I recommend that you read this excellent blog post[/url] by Gail Shaw (GilaMonster on SSC) and then this one as well. You may need to create an account or...
February 3, 2009 at 1:27 pm
I have never come across an instance where I found that INSTEAD OF triggers were necessary. Why are they proposing INSTEAD OF triggers?
If you check out the discussion of...
February 3, 2009 at 1:18 pm
What code is creating this global temp table? Any process trying to create another global temp table with the same name should error out with an error like this:
Msg...
February 3, 2009 at 10:10 am
josephptran2002 (2/3/2009)
Hello Mike,I'm sorry I don't know how to put in the right format in this SQL.
I apolozige for the inconvenient.
Thank you
Read the link that Michael provided (also in my...
February 3, 2009 at 10:07 am
Michael Earl (2/3/2009)
It would really help if you made your sample dataa easier to use:http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
Please read the article.
Thanks,
February 3, 2009 at 9:59 am
Mike's solution is probably going to perform better because you only hit the main table 1 time so I'd go with that, which, once you replace the temp table with...
February 3, 2009 at 9:29 am
Assuming you are doing an:
Insert Into
EXEC [procedure]
There is no way to do limit the columns returned by the procedure unless you add a...
February 3, 2009 at 9:25 am
This works, but is probably not ideal:
Create table #Select (id int, Name varchar(10))
Insert into
#Select
values
(1, 'Test')
Insert into
...
February 3, 2009 at 9:16 am
The status column tells you if a trace is active. The only possible statuses are 0 - stopped and 1 - active. This is alos property 5 from...
February 3, 2009 at 8:57 am
Well, you can change the names of folders to include more information. Of course you will need to note these changes so that when you deploy changes or new...
February 2, 2009 at 10:15 am
What do you want to sort by? If you go to detail view you have some sort options
February 2, 2009 at 10:11 am
Viewing 15 posts - 6,121 through 6,135 (of 9,643 total)