Viewing 15 posts - 1,591 through 1,605 (of 2,038 total)
David,
What about this:
SELECT *
FROM mytab
WHERE col1 = ISNULL(@col1, col1)
AND col2 = ISNULL(@col2, col2)
...
April 2, 2009 at 1:07 pm
Hi Timothy
As far as CLR I actually have found another important use for it... though maybe there is a better way. In my development environment I have created a CLR...
April 2, 2009 at 10:40 am
eseosaoregie (4/2/2009)
I put that in and it worked. Could you explain how you knew where to put it. I thought the statement COLLATE SQL_Latin1_General_CP1_CI_AS would be with the BRENTREPODB02 alias?
Telling...
April 2, 2009 at 10:24 am
Hi Timothy
I may be sticking my neck out a little far here... but I do use cursors a bit.
Shame on you! ... not really... there are cases where it makes...
April 2, 2009 at 9:28 am
Falvio (4/1/2009)
:hehe:One more try for the XML....
Hi Flavio
First: Compliment for XML posting. 😀
You should have a look to the FOR XML EXPLICIT feature. There are many examples in BOL.
If...
April 2, 2009 at 4:49 am
As Mithun wrote you should have a look to TRY-CATCH blocks in SQL Server 2005.
Greets
Flo
April 2, 2009 at 4:40 am
AMJ (4/1/2009)
April 2, 2009 at 4:38 am
Hi Carlo
Thanks for feedback! There is another reason for me that I cannot use IDENTITIES, our C# OR-Mapper cannot handle them (not my design...).
I'm no DBA, I'm a developer so...
April 2, 2009 at 4:29 am
Vijaya Kadiyala (4/1/2009)
HiIn addition to the "Florian Reischl" store procedure its good to use TRANSACTIONS also.
If one INSERT fails then dont proceed with the next INSERT.
Hi Vijaya
Sure it should...
April 2, 2009 at 3:38 am
gsmccoy (4/1/2009)
Hi,I just want to insert a 'Yes' in the Assigned Column of the DIDs table.
Into your CustInfo table or the DIDs table? What is the problem?
Greets
Flo
April 2, 2009 at 3:36 am
Hi
That's not the execution plan but the executing statement ;-).
In Management Studio open your query, then go to menu -> Query -> Include Actual Execution Plan.
Then execute your query. When...
April 2, 2009 at 3:34 am
Hi Carlo
E.g. in our business case we are not able to use IDENTITY due to problems with replication. If you can/could use IDENTITY columns in SSE 2000 you don't need...
April 2, 2009 at 3:29 am
Hi Carlo
You have been faster than me... I wanted to explain directly after it becomes published.
Sure since SQL Server 2005 this is not needed any more because of the ROW_NUBER()...
April 2, 2009 at 2:28 am
By the way...
I just detected that the "sys.fn_varbintohexstr" in SQL Server 2008 handles VARBINARY(MAX) and VARCHAR(MAX). So this function becomes obsolete with SQL Server 2008.
Greets
Flo
April 1, 2009 at 3:00 pm
Hi thermanson
So why don't you publish it here? 😉
My script was only a simple helper I wrote sometime. Since now several people within my company asked for it, so I...
April 1, 2009 at 2:54 pm
Viewing 15 posts - 1,591 through 1,605 (of 2,038 total)