Viewing 15 posts - 10,756 through 10,770 (of 26,489 total)
One suggestion, change ON [PRIMARY] to ON [DEFAULT].
One reason, for me, is that when I create new databases I add at least one new file group, Data, and I make...
July 12, 2012 at 10:36 am
By the way, Joe, I cleaned up your code a bit. Hope you don't mind.
CREATE TABLE Contacts(
contact_id CHAR(10) NOT NULL PRIMARY KEY,
...
July 12, 2012 at 10:23 am
bernard75 (7/12/2012)
UPDATE table SET column = ELT(FLOOR(RAND()*3)+1, 'string1', 'string2', 'string3');
Just need something to add 2 more strings. So the output will be:
string1 string2 string3
string3 string1 string2
string2 string3 string1
...
I...
July 12, 2012 at 10:21 am
Saga... (7/12/2012)
Yes I am asking in terms of application.... that application needs staging database, with main database to start some services.just want to know generic terminology for staging.
Not knowing...
July 12, 2012 at 10:18 am
ChrisM@Work (7/12/2012)
CELKO (7/12/2012)
... WHERE S.sales_order_id = D.sales_order_id;Better duck now, Joe.
Yes, Joe, duck. You may want to consider turning in your SQL Developer card.
Take a close look at your code....
July 12, 2012 at 10:06 am
SQLDCH, Since this is your baby, who all is back so far this year?
July 12, 2012 at 8:47 am
sqluser_8119 (7/11/2012)
How do you make this:yyyy/mm/dd hh:mm:ss
Look like this:
mm/dd/yyyy hh:mm --hh:mm needs to be in military time
You are getting a lot of responses, but the biggest...
July 12, 2012 at 8:34 am
Sean Lange (7/12/2012)
SGT_squeequal (7/12/2012)
I used the while loop within while loop worked a treat for what i need 🙂
So with 5 other methods that are faster you still choose to...
July 12, 2012 at 8:29 am
SGT_squeequal (7/12/2012)
i used the loop before any of the set based ooptions appeard plenty to ponder for the future :);-)
And that is a reason to not change which method you...
July 12, 2012 at 8:28 am
Fraggle-805517 (7/12/2012)
The types table has a PK on the ID column, so it can't have duplicates.Fraggle
Just an FYI, your DDL in your original post doesn't show that, so it was...
July 12, 2012 at 8:11 am
Jeff Moden (7/12/2012)
SGT_squeequal (7/11/2012)
July 12, 2012 at 8:05 am
What does the following query return?
select
[name] as DatabaseName,
log_reuse_wait_desc
from
sys.databases;
July 11, 2012 at 10:14 pm
What does the following query return while the log files get bigger?
select
[name] as DatabaseName,
log_reuse_wait_desc
from
sys.databases;
July 11, 2012 at 10:14 pm
cljolly (7/11/2012)
Select *
into #tbl_casualty
From Openquery(oracletable,
'
select
LPAD(WORK_ORD_NBR,5,''0'')as WO,
INCD_DATE AS OCCDATE,
REQS_DATE AS REQS_DATE,
PROJ_DESC AS PROJ_DESC,
CLTY_TYPE AS CLTY_TYPE
from EES.EES_CLTY_PROJ
WHERE WORK_ORD_NBR IS...
July 11, 2012 at 10:08 pm
dastagiri16 (7/11/2012)
i have two statements as below
select * From doctor_list where doctor_registered_date between '2012-05-01' and '2012-05-02'
and
select * From doctor_list where doctor_registered_date between '2012-05-01 00:00:00' and '2012-05-02 00:00:00'
is there any...
July 11, 2012 at 10:02 pm
Viewing 15 posts - 10,756 through 10,770 (of 26,489 total)