Forum Replies Created
Viewing 15 posts - 106 through 120 (of 516 total)
-
RE: Temp Table Data Types
bitbucket-25253 (3/12/2013)
Nice question .. learned something from it ... thanks+1
Thanks Dave
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: INNER JOIN
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...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: INNER JOIN
Easy one for the day. Thanks Kapil:-)
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: DATETIME - 3
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!
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: SubQuery
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."
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: CREATE statement
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"...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: CREATE statement
demonfox (3/6/2013)
the explanations saysThe 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...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: CREATE statement
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() 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: CREATE statement
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...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: CREATE statement
Nice question Gary!!
This is how Create procedure and function should be written, so that they work:
-- Query #4USE DBDB;
GO
IF OBJECT_ID('dbo.uspUSP') IS NULL
EXEC ('CREATE PROCEDURE dbo.uspUSP AS...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: ISNUMERIC
happycat59 (3/5/2013)
Mmm, why have "ISNUMERIC" as the heading for this question ? This question is not really about the ISNUMERIC function. How about getting the heading to match...~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: Clustered Index
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...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: Clustered Index
Nice question demonfox... Overlooked and got the question wrong. Lesson learnt! 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: SETTINGS - 1
demonfox (3/3/2013)
nice and easy Q for the monday ...and a great explanation by Tom ...
thanks for Q & E
+1
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
RE: Can This Work?
demonfox (2/28/2013)
I got it right, but it was a sheer guess on the mind of OP ..will this code execute successfully
it should have been mentioned as the 4th step..
also, it...
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
Viewing 15 posts - 106 through 120 (of 516 total)