|
|
-
Mitesh Modi Commented 10 Months ago through Ask
see the link
[http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html][1]
[1]: http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html...
|
-
Mitesh Modi Commented 10 Months ago through Ask
Please Mark this as answer if it is working or reply if any problem. so this question is closed....
|
-
Mitesh Modi Commented 10 Months ago through Just Learned
**How SQL Server Compares Strings with Trailing Spaces**
[http://support.microsoft.com/kb/316626][1]
[1]: http://support.microsoft.com/kb/316626...
|
-
Mitesh Modi Commented 10 Months ago through Just Learned
**How SQL Server Compares Strings with Trailing Spaces**
[http://support.microsoft.com/kb/316626][1]
[1]: http://support.microsoft.com/kb/316626...
|
-
Mitesh Modi Commented 10 Months ago through Just Learned
Try this example also
DECLARE @Test CHAR(10), @Test2 CHAR(10)
SET @Test = 'test'
SET @Test2 = 'Test2'
SELECT LEN(@Test), LEN(@Test + '_') , LEN(@Test2), LEN(@Test2 + '_')...
|
-
Mitesh Modi Commented 10 Months ago through Just Learned
Try this example also
DECLARE @Test CHAR(10), @Test2 CHAR(10)
SET @Test = 'test'
SET @Test2 = 'Test2'
SELECT LEN(@Test), LEN(@Test + '_') , LEN(@Test2), LEN(@Test2 + '_')...
|
-
Mitesh Modi Commented 10 Months ago through Ask
Full-Text is token (word) based search and not a substring search. Therefore it will not find arbitrary 3 char string patterns in middle of strings.
read the reply of Sara Tahir in above link...
|
-
Mitesh Modi Commented 10 Months ago through Ask
Data flow
Flat file source-> Derived Column -> Destination
in derived column you have to set like below
Replace c1 with REPLACE(c1,"\"","")
Replace c6 with REPLACE(SUBSTRING(c6,1,LEN(c6) - FINDSTRING(REVERSE(c6),",",1)),"\"","")
...
|
-
Mitesh Modi Liked 10 Months ago through Just Learned
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 ...
|
-
Mitesh Modi Learned 10 Months ago through Just Learned
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 ...
|