|
|
-
satyajit Commented 7 Months ago through Just Learned | 1 Point
@MisterMagoo
Please check your facts before mentioning any post as incorrect.
I have mentioned to avoid using it...it means as a good practice one should try to use "EXISTS"/"NOT EXISTS" instead of "IN"/"NOT IN" ...
Its not a problem if one can use...
|
-
satyajit Liked 9 Months ago through Just Learned | 1 Point
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
satyajit Learned 9 Months ago through Just Learned | 1 Point
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
satyajit Liked 9 Months ago through Just Learned | 1 Point
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
satyajit Learned 9 Months ago through Just Learned | 1 Point
One can view & print excel files on computers that do not have excel installed. search for "excel viewer" .
Business scenario: when it does not make sense to buy a license when all you need is view & print excel files. ...
|
-
satyajit Commented 10 Months ago through Just Learned | 1 Point
Sorry guys could not get back soon due to work.
My take is ANSI_PADDING affects only storage not comparisons.I thought it would be a good blog topic so please go through below for details and examples
[http://beyondrelational.com/modules/2/blogs/381...
|
-
satyajit Commented 10 Months ago through Just Learned | 1 Point
Sorry guys could not get back soon due to work.
My take is ANSI_PADDING affects only storage not comparisons.I thought it would be a good blog topic so please go through below for details and examples
[http://beyondrelational.com/modules/2/blogs/381...
|
-
satyajit Commented 10 Months ago through Just Learned | 1 Point
wow....never knew a space has so many things in sql server(also I am wondering if a space deserves this much variation and thus attention)...
thanks nakul,vadivel and mitesh...
I will have to go through the examples mentioned before any reply...
|
-
satyajit Commented 10 Months ago through Just Learned | 1 Point
wow....never knew a space has so many things in sql server(also I am wondering if a space deserves this much variation and thus attention)...
thanks nakul,vadivel,Patrick and mitesh...
I will have to go through the examples mentioned before any reply...
|
-
satyajit Posted 10 Months ago through Just Learned | 5 Points
create table #temp
(
a varchar(10)
)
insert into #temp values(' a ')
select COUNT(*) from #temp where a=' a'
select COUNT(*) from #temp where a='a'
first query will return 1
2nd will return 0 as sql ser...
|