Hi,

In your query you can combine the LEN function with RTRIM and LTRIM and...

kstephens 90242 (4/9/2012)

---

Sorry about that, I would like it to fire before the insert/update.

so the data is in the correct format.

so instead of name+name I will insert this...

To be not given 0.0000 values from your query, you first make a backup on a database with a compression option.

The question is really good.

Hi All,

Yes, I agree with some members that the question is a bit ambiguous, but I put the third option to make the question “ambiguous” i.e. to make you think...

n00bDBA (3/31/2012)

---

Hello,

If I create a SQL Login using a Active Directory Account is there a way to check if the account can log into SQL Before i give it...

Yes, SSAS is aimed for analysis.

A good reference is for example "Applied Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform" from Teo Lachev

Regards

--SQL 2012

CREATE TABLE [dbo].[test](

[int] NULL

)

CREATE SYNONYM [dbo].[testSinonim] FOR [mytestdb].[dbo].[test]

GO

Alter table test

Add j int null

--================

After scripting the table, the result is following

CREATE TABLE [dbo].[test](

[int] NULL,

[j] [int] NULL

)

I just want...

GilaMonster (3/24/2012)

---

Yes. It won't work at all.

SQL databases can never...

Cursors may be up to 10 times slower than set-based solutions when compared.

Cursors are used when you need to do operations on a relatively small set of objects, e.g. update...

I run your question with

SET ANSI_NULLS ON and SET ANSI_NULLS OFF, and the result is same. I use SQL Server 2012

?

hm

?

I like your question. Thanks. My learning is growing very fast with this community.

Oh, I adore questions with fast retrieval of rows. Thank you

@@error will have the right error code if selected immediately after raiserror command

raiserror('oh no, another error!', 16,1)

select @@error

Thanks

Useful question, thank you

The following query with same structure as those in the question produces 0 joins

SELECT *

FROM QOTD

where qotdid = 1

because of "QOTD" which is clustered index

select * from ##TableNulls where col2 is not null

will give out the expected results at fist sight

Thank you for the question