Viewing 15 posts - 6,451 through 6,465 (of 15,381 total)
ericwenger1 (10/21/2013)
Can I get some recommendations on some Database Reverse Engineering Tools?Thanks in advance!
What are you trying to reverse engineer? Are you trying to get a database model or...
October 21, 2013 at 1:48 pm
dndaughtery (10/21/2013)
That worked, thanks
Which one?
October 21, 2013 at 1:42 pm
derekmcdonnell3 (10/21/2013)
October 21, 2013 at 1:41 pm
Hi and welcome to the forums. In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form...
October 21, 2013 at 1:04 pm
Nagaram (10/21/2013)
No where SomeCondition..need to delete all the records without logging the individual row deletions in tranasaction log
Easy enough to remove the condition.
You can't avoid row deletes being logged. That...
October 21, 2013 at 12:53 pm
You are mixing up your aggregates and scalar values. You are trying to use a case expression to control the whole column. This doesn't work at all. It is awfully...
October 21, 2013 at 12:39 pm
Nagaram (10/21/2013)
Looking for best way to archive and delete the exsting data from one table in the business hours.
We have one log table , An application is inserting the...
October 21, 2013 at 12:33 pm
mario17 (10/21/2013)
This is kind of my first DDL table, so just want to check with all gurus, it has some cust definition and totals like below:
Cust_Category | ...
October 21, 2013 at 12:21 pm
Please don't post multiple threads for the same thing. See the original thread here. http://www.sqlservercentral.com/Forums/Topic1506273-391-1.aspx
October 21, 2013 at 7:39 am
simonholzman 14059 (10/19/2013)
However, although TRUNCATE is much faster and does not log the changes, it does not normally allow any data to be kept.
This is not true. TRUNCATE is a...
October 21, 2013 at 7:37 am
Hi and welcome to the forums. In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form...
October 21, 2013 at 7:31 am
kennethrbell (10/18/2013)
Mine is, "is there a way to have the total count display as well?" In other words, is this row a "10" a...
October 21, 2013 at 7:18 am
patrickmcginnis59 10839 (10/18/2013)
T.Ashish (10/1/2013)
I consider CURSOR and TABLE as data types but some one has argued that these are database objects.
Can you please share your views on the same...
October 18, 2013 at 2:51 pm
kennethrbell (10/18/2013)
Thanks Sean. I'll test it later when I get home. I was trying to use a variable, but I can see how this would work.
You're welcome. Please post back...
October 18, 2013 at 1:10 pm
Pretty sparse on details here but I think you could do something like this. I'm not so sure about the "simple" part but it should work.
select * from
(
Select *
, case...
October 18, 2013 at 12:26 pm
Viewing 15 posts - 6,451 through 6,465 (of 15,381 total)