Viewing 15 posts - 691 through 705 (of 8,731 total)
February 8, 2018 at 8:15 am
You can delete any number of rows, you just need to use the correct WHERE clause.
https://docs.oracle.com/cd/B14117_01/appdev.101/b10807/13_elems014.htm
February 8, 2018 at 6:01 am
February 7, 2018 at 1:45 pm
Are you clicking on the green arrow (Debug) instead of the red exclamation sign (Execute)?
February 7, 2018 at 7:19 am
Jobs and logins are not part of the database, they're part of the instance (server).
Jobs are stored in the msdb database and logins are stored in the master database....
February 7, 2018 at 6:47 am
I actually used the Quirky Update which is great for this sort of things. I would test it as I'm not sure about updating 2 columns at once. Check the...
February 6, 2018 at 11:27 am
February 5, 2018 at 12:08 pm
February 5, 2018 at 12:08 pm
Maybe you have a BEGIN without END? Or something similar.
February 5, 2018 at 12:01 pm
The weird part is that when it was running on SQL Server 2008,...
February 1, 2018 at 10:54 am
I've inherited a software application using a SQL 2008 DB. We migrated...
February 1, 2018 at 10:28 am
January 31, 2018 at 1:31 pm
Business defines the formula. For simplicity, assume that formula is fixed in this...
January 31, 2018 at 1:27 pm
I would start by defining adequate clustered indexes to your tables. Then add any nonclustered indexes that might be needed.
Check the following for more help:
How...
January 31, 2018 at 1:20 pm
January 31, 2018 at 1:12 pm
Viewing 15 posts - 691 through 705 (of 8,731 total)