Viewing 15 posts - 106 through 120 (of 515 total)
bitbucket-25253 (3/12/2013)
Nice question .. learned something from it ... thanks
+1
Thanks Dave
March 12, 2013 at 9:53 pm
kapil_kk (3/12/2013)
yes, I learned different new things from the feedback and interaction of the people......
That's the spirit Kapil. This happens with every one when you post your first QOTD. Believe...
March 12, 2013 at 9:44 am
db4breakfast (3/9/2013)
This was a tough one for me. I didn't know the default cut off year. thanks.
+1
something new for me to learn as well.
Thanks Ron!
March 10, 2013 at 11:19 pm
Must include an ORDER BY clause when a TOP clause is specified.
I think this statements should be "Must include an TOP clause when a ORDER BY clause is specified."
March 7, 2013 at 9:21 pm
Thank you Danny! I know how GO is used as a batch separator 🙂
Actually the confusion was this statement
"every create store procedure and create function, always contains a "GO"...
March 7, 2013 at 12:17 am
demonfox (3/6/2013)
The CREATE PROCEDURE statement cannot be combined with other Transact-SQL statements in a single batch. The same rule applies to Functions as well, but this is not...
March 6, 2013 at 11:50 pm
demonfox (3/6/2013)
select db_id('dbdb')
-- and the second one
select object_id('dbdb')
Nice catch demonfox....I misread and thought both are using DB_ID() 🙂
March 6, 2013 at 11:49 pm
Danny Ocean (3/6/2013)
If you check msdn, then you will find that every create store procedure and create function, always contains a "GO" statement before the definition.
Danny, I did not get...
March 6, 2013 at 10:36 pm
Nice question Gary!!
This is how Create procedure and function should be written, so that they work:
-- Query #4
USE DBDB;
GO
IF OBJECT_ID('dbo.uspUSP') IS NULL
EXEC ('CREATE PROCEDURE dbo.uspUSP AS...
March 6, 2013 at 10:35 pm
happycat59 (3/5/2013)
March 5, 2013 at 9:21 pm
ggeier (3/5/2013)
How can the index rebuild remove the fragmentation from the index? The table is empty at that step so it should already be at 0.00% fragmentation.
Nice catch!!
I think the...
March 5, 2013 at 7:34 am
Nice question demonfox... Overlooked and got the question wrong. Lesson learnt! 🙂
March 4, 2013 at 9:44 pm
demonfox (3/3/2013)
nice and easy Q for the monday ...and a great explanation by Tom ...
thanks for Q & E
+1
March 3, 2013 at 10:02 pm
demonfox (2/28/2013)
will this code execute successfully
it should have been mentioned as the 4th step..
also, it...
February 28, 2013 at 10:48 pm
Viewing 15 posts - 106 through 120 (of 515 total)