Viewing 15 posts - 406 through 420 (of 562 total)
GilaMonster (2/6/2014)
ben.brugman (2/6/2014)
To see how efficient code is working I want to count how many times a function is accessed.
Depends on the execution plan. The rule that functions cannot have...
February 6, 2014 at 7:56 am
Lowell (2/6/2014)
i actually make things system functions , system procedures, and stuff quite a bit i have a ton of developer tools i've created and adapted that go in master.
Do...
February 6, 2014 at 6:08 am
Eugene Elutin (2/6/2014)
Closest think you might want to do is to...
February 6, 2014 at 5:52 am
chetan.deshpande001 (2/6/2014)
Just a thought ...why not use FQN (fully qualified name) to access function created in different database ?
On a Single instance this would be a reasonable solution. But...
February 6, 2014 at 5:44 am
RTaylor2208 (11/29/2013)
WHERE b.PropertyCode='PCH'AND b.CreatedON BETWEEN '2013-11-29' AND '2013-11-30'
This will give you the time range '2013-11-29 00:00:00.000' till '2013-11-29-29 23:59:59.999' encompasing the whole day.
Time (and datetime as wel) is...
November 29, 2013 at 6:37 am
GilaMonster (11/29/2013)
No. It's a property of the client tool only, not something that SQL Server sets within itself
Thanks Gail,
I thought so, but it's nice to know for sure.
Are there suggestions...
November 29, 2013 at 2:47 am
Alexander Suprun (11/28/2013)
Your client application should take care of formatting.
Sometimes the client application is less suetable for the formatting.
For example I sometimes do the formatting within SQL-server when serving for...
November 29, 2013 at 2:20 am
This is a rather old thread, so for this question it would have been better to start a new thread.
I use the numbers always as a rough indication;
Table Name ...
November 10, 2013 at 8:41 am
Use the following code to just see what is happening:
--------------------------------------------------------
-- Actual code to prepare for an UPDATE a Select
--------------------------------------------------------
;with
A as...
October 14, 2013 at 8:46 am
Sean Lange (10/8/2013)
I am not really sure what you are trying to do or what the question is.
Sp_generate_Inserts, generates insert statements from an existing table. For example to create (part)...
October 14, 2013 at 8:33 am
--------------------------------------------------------
-- Actual code to UPDATE
--------------------------------------------------------
;with
A as (
select
...
October 8, 2013 at 8:04 am
For this type of problem I like the Windows functions to give each row a number which makes the row unique.
With CTE the 'double' rows can be removed.
...
October 8, 2013 at 7:56 am
Sorry additional,
I did write:
I am aware of the 'database task generate scripts'.
But I do not know how to do this with a scripted command.
(As with sp_generate_inserts, example:
sp_generate_inserts My_Table
)
sorry...
October 8, 2013 at 6:51 am
Thanks all,
Did try the suggested code, and indeed this was different than I expected. Thank you for educating me.
Thanks,
Ben
August 2, 2013 at 9:32 am
Eugene Elutin (8/1/2013)
It's not just "allows" dirty read. It does exactly perform what is called "dirty reads"!
For my understanding:
1. Dirty reads is the reading of data which is not (yet)...
August 1, 2013 at 4:20 am
Viewing 15 posts - 406 through 420 (of 562 total)