Viewing 15 posts - 1 through 15 (of 36 total)
I could not understand the japanese words, so did a quick google transalate.
You are most welcome..:-)
March 31, 2015 at 10:35 am
Thanks Keith. My input date range table could look something like the below
Id Start_range ...
November 14, 2013 at 7:38 pm
The start_range and end_range would vary based on input. May be I am unable to explain but for now creating a physical table would not solve the problem. Sorry about...
November 14, 2013 at 6:37 pm
On the SQL Jobs links.. I am open for any location.
June 10, 2013 at 12:20 pm
If you concentrating to gain only on the theoretical knowledge of SQL Server, I would say 12 month is good enough. But, becoming an MCSA is not only about memorizing...
March 27, 2013 at 6:39 am
Can anyone please explain about the error level 14 and 16. I am not able to understand this
February 20, 2013 at 3:03 am
Great article Nakul.
Another use of the Checksum is for the hash index creation. When indexes are created over nvarchar or varchar datat type columns, CHECKSUM() hashes the value. This...
February 12, 2013 at 2:14 am
Please check if you have the necessary permission to perform INSERT/UPDATE/DELETE operation on the target table.
February 8, 2013 at 12:24 am
That was a googly :w00t:
February 8, 2013 at 12:18 am
declare @color varchar(20)
set @color = ''
SELECT * FROm TBLCOLOR
Where color = coalesce(NULLIF(@color,''),color)
When no value is entered, the value passed would be ‘’ . And the NULLIF returns a NULL value...
January 30, 2013 at 12:13 am
You can use PIVOT function to convert rows into columns. Bt please bear in mind that the reverse is not true.
January 17, 2013 at 5:11 am
The ACID property is interesting if we hook it to the conventional Db management system. If I talk about Mobile Database systems, in SQL Server CE for a SELECT operation...
January 17, 2013 at 2:59 am
I agree to the article highlighted by you. The best example I can see i sme. Not long ago when I started my career into SQL Server it seemed like...
January 15, 2013 at 6:55 am
Easy one.. But when I think I do find OUTER JOINS to work outfaster than NOT IN, of course it depends, but I will bet on JOINS as compared to...
January 11, 2013 at 1:47 am
Thank you Dave for your reply, if it is 5,2 then it would be aftere 1,2. I think you have rightly pointed it should be like the parent-child query. I'm...
January 4, 2013 at 6:24 am