Viewing 15 posts - 166 through 180 (of 2,894 total)
Sorry Carol, but summing CustomerId with OrderId looks to me as summing Prices with House Numbers.
So, I have three possible answers:
1. http://www.sqlservercentral.com/articles/Best+Practices/61537/
2. 42
3. wait for someone who will understand...
February 12, 2014 at 10:22 am
You cannot use column name as predicate in Full-text searches.
Predicate must be 'freetext_string'
Which means, you should build it from your "table of predicates", then use in CONTAIN.
It is...
February 12, 2014 at 10:06 am
GilaMonster (2/12/2014)
Eugene Elutin (2/12/2014)
GilaMonster (2/12/2014)
Eugene Elutin (2/12/2014)
...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't...
February 12, 2014 at 9:16 am
GilaMonster (2/12/2014)
Eugene Elutin (2/12/2014)
...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through...
February 12, 2014 at 9:08 am
That is not a small topic.
The best place to start from would be MS BoL:
http://technet.microsoft.com/en-us/library/ms142571.aspx
Try and play. When you will have some specific questions, I'm sure you will find...
February 12, 2014 at 9:05 am
...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through procedural or application...
February 12, 2014 at 8:56 am
Scalar functions of this sort are not very good performers...
Any way looks like OP has quite a specific rules, not just take non-alpha characters away. He also wants to take...
February 12, 2014 at 8:41 am
MyDoggieJessie (2/12/2014)
@String varchar(50),
@Delimiter varchar(5),
@Side int
)...
February 12, 2014 at 8:17 am
if you have wild card at front of pattern - the search cannot be optimised much, as full scan will be performed regardless of existing index, if any
If you have...
February 12, 2014 at 8:12 am
I wonder what have you tried to search for?
Google search returns a banch of topics. One is here leading to sample:
http://stackoverflow.com/questions/1673265/how-to-write-number-to-word-function-in-sql-server
I'm sure you will also find something searching SQLServerCentral itself.
February 12, 2014 at 7:10 am
Is it possible to write a function to convert a numbers to words based on language?
...
Yes, it is possible. However, you will make your...
February 12, 2014 at 6:57 am
Not very clear what you really want. The best what you can do is to read the article from the link at the bottom of my signature, it should help...
February 12, 2014 at 6:48 am
ananda.murugesan (2/12/2014)
I am checking with profiler, this paricualr Query tooks duration 30 sec for completion at every execution, and CPU is 0 seconds..
How many records your query returns? It may...
February 12, 2014 at 6:26 am
You are trying to TRIM the value in the column which doesn't exist!
You or someone else was not very accurate while changing table definition and added space to the name...
February 12, 2014 at 6:24 am
Looks like you have a space at front of the Cost, so yuor full column name is [ Cost]. Rename it to remove the space
February 12, 2014 at 5:53 am
Viewing 15 posts - 166 through 180 (of 2,894 total)