|
|
-
Nakul Vachhrajani knew 10 Months ago through Just Learned | 1 Point
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 ...
|
-
Nakul Vachhrajani knew 10 Months ago through Just Learned | 1 Point
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 ...
|
-
Nakul Vachhrajani knew 10 Months ago through Just Learned | 1 Point
While writing a query with joining two tables from two different dbs, a collation error was encountered.
'Cannot resolve collation conflict for equal to operation.'
Fix:
add keyword `COLLATE DATABASE_DEFAULT` after join .
SELECT
...
|
RKA
91
·
2% ·
598
|
|
-
Nakul Vachhrajani knew 10 Months ago through Just Learned | 1 Point
While writing a query with joining two tables from two different dbs, a collation error was encountered.
'Cannot resolve collation conflict for equal to operation.'
Fix:
add keyword `COLLATE DATABASE_DEFAULT` after join .
SELECT
...
|
|
RKA
91
·
2% ·
598
|
|
-
Nakul Vachhrajani knew 10 Months ago through Just Learned | 1 Point
A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances.
A Tool can do the things as below:
1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...
|
-
Nakul Vachhrajani knew 10 Months ago through Just Learned | 1 Point
A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances.
A Tool can do the things as below:
1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...
|
-
Nakul Vachhrajani knew 11 Months ago through Just Learned | 1 Point
Recently I needed to convert a float value to nearest integer...
I used Convert.ToInt32
The problem found with is it will convert decimal like 7.5,8.5 to nearest even integer
Convert.ToInt32(7.5)=>8
Convert.ToInt32(8.5)=>8 !!!
The solutio...
|
-
Nakul Vachhrajani knew 11 Months ago through Just Learned | 1 Point
Recently I needed to convert a float value to nearest integer...
I used Convert.ToInt32
The problem found with is it will convert decimal like 7.5,8.5 to nearest even integer
Convert.ToInt32(7.5)=>8
Convert.ToInt32(8.5)=>8 !!!
The solutio...
|
-
Nakul Vachhrajani knew 11 Months ago through Just Learned | 1 Point
I love the track changes feature in Word. But a similar feature is not available in PowerPoint. The workaround is to post "comments" in PowerPoint. it's not as elegant as "track changes" feature in word but it's OK for now. ...
|
-
Nakul Vachhrajani knew 11 Months ago through Just Learned | 1 Point
I love the track changes feature in Word. But a similar feature is not available in PowerPoint. The workaround is to post "comments" in PowerPoint. it's not as elegant as "track changes" feature in word but it's OK for now. ...
|