Viewing 15 posts - 3,601 through 3,615 (of 26,490 total)
angelreynosog (6/28/2016)
It is the same query , not wanting to send it twice
Run this:
SELECT name, log_reuse_wait_desc from sys.databases
June 28, 2016 at 1:36 pm
If it isn't one thing it is another. Not getting any good news today.
Just prayers for the family for wisdom and guidance.
Thanks.
June 24, 2016 at 4:00 pm
Sean Lange (6/24/2016)
Jeff Moden (6/24/2016)
Sean Lange (6/24/2016)
create view [dbo].[getNewID] as select newid() as new_id;
Really? A view to get a...
June 24, 2016 at 11:21 am
Jeff Moden (6/24/2016)
Luis Cazares (6/24/2016)
Sean Lange (6/24/2016)
create view [dbo].[getNewID] as select newid() as new_id;
Really? A view to get a...
June 24, 2016 at 10:36 am
Luis Cazares (6/24/2016)
June 24, 2016 at 9:59 am
al.yukhvidin (6/23/2016)
I have script:
Select CASE WHEN (ABS.VALUE<90 AND ABC1.VALUE<140) THEN 1 ELSE 0 END AS status
returns "Conversion failed when converting the varchar value '118.' to data type int." error...
June 23, 2016 at 11:39 am
If the question was as vague as your initial post I would have asked what error messages were we getting when attempting to drop the tables, views, stored procedures, and/or...
June 23, 2016 at 7:54 am
curious_sqldba (6/22/2016)
Sean Lange (6/22/2016)
curious_sqldba (6/22/2016)
Thanks. This is just displaying, i want to store the data in the variable and then use the variable different places.
Do you know how to use...
June 22, 2016 at 4:35 pm
Brandie Tarvin (6/22/2016)
Lynn Pettis (6/22/2016)
Actually, Brandie you are not quite right here.
I knew as soon as I hit POST that I said something wrong, but wasn't able to get back...
June 22, 2016 at 8:48 am
A little more on INSTEAD OF triggers.
They can be declared on views. They can be used to make non-updateable views updateable because you can handle the updates (in this...
June 22, 2016 at 8:45 am
Brandie Tarvin (6/22/2016)
BWFC (6/22/2016)
Lynn Pettis (6/21/2016)
Brandie Tarvin (6/21/2016)
Lynn Pettis (6/20/2016)
June 22, 2016 at 8:38 am
Good database design is needed in data warehouse and data mart systems just as it is needed OLTP systems.
Data Warehouses pulling data from multiple sources should cleanse and standardize (not...
June 21, 2016 at 12:24 pm
Brandie Tarvin (6/21/2016)
Lynn Pettis (6/20/2016)
Does anyone else see a...
June 21, 2016 at 7:30 am
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Does...
June 20, 2016 at 3:12 pm
Sean Lange (6/20/2016)
Lynn Pettis (6/20/2016)
Does anyone else see a...
June 20, 2016 at 2:44 pm
Viewing 15 posts - 3,601 through 3,615 (of 26,490 total)