Viewing 15 posts - 211 through 225 (of 1,131 total)
The problem with the other solutions is the use of the '%' wild card which allows leading or trailing non-desired characters. So convert to a fixed length character type...
SQL = Scarcely Qualifies as a Language
June 8, 2009 at 11:32 am
Perhaps I am missing something, but what is wrong with the system function "isnumeric" ?
CREATE RULE [dbo].[NumericCharsOnly]
AS
ISNUMERIC(@value) = 1
GO
SQL = Scarcely Qualifies as a Language
June 8, 2009 at 11:22 am
From Books OnLine
All Central Management Servers and subordinate servers must be registered by using Windows Authentication.
SQL = Scarcely Qualifies as a Language
June 8, 2009 at 5:47 am
For the materialized view, you indicate that the actual execution plan is using the base tables rather than the materialized view, which indicates that you are using SQL Server Standard...
SQL = Scarcely Qualifies as a Language
June 8, 2009 at 5:41 am
One elegent solution is to use a Recursive Common Table Element:
DECLARE @ns TABLE (n int)
INSERT @ns VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9);
;WITH Numbers AS
(SELECT 1 AS LEVEL
,CAST(n AS VARCHAR(9) ) AS NString
FROM@ns
UNION ALL
SELECTLEVEL...
SQL = Scarcely Qualifies as a Language
June 8, 2009 at 5:07 am
If you are asking if you can have a mapping of an OO Class to a relational table, then the answer is no.
If you are asking if you a table...
SQL = Scarcely Qualifies as a Language
June 7, 2009 at 8:50 am
With the text file having 6 fields (Date ,open , high, low, close, volume) and assuming each field is 8 bytes, this is 48 bytes per record. With 2.5...
SQL = Scarcely Qualifies as a Language
June 6, 2009 at 6:30 am
The index statistics for the IX_City show a high degree of skewness with the top 10 countries having 42% of the total rows and the top 23 having 60% of...
SQL = Scarcely Qualifies as a Language
June 4, 2009 at 7:48 am
Thanks Sam, looking at the statistics right now and will get back to you soon.
Can you advise the frequency of changes (insert,updates and deletes)?
Is this user entered on a one...
SQL = Scarcely Qualifies as a Language
June 4, 2009 at 6:35 am
As there do not appear to be significant dependecies between the Database Engine, Analysis Services, Reporting Services, Integration Services and the new Master Data Management, MS would be better off...
SQL = Scarcely Qualifies as a Language
June 3, 2009 at 7:49 pm
Some additional information is needed to assist you, so please run the below two sets of SQL statements to gather index statistical information and post the output. Note that...
SQL = Scarcely Qualifies as a Language
June 3, 2009 at 7:20 pm
For your table with about 46 million rows, 1.5 million pages and no index on the filter, a sequential scan will be performed and each read will be for 8...
SQL = Scarcely Qualifies as a Language
June 3, 2009 at 1:32 pm
Joe Celko has written 2 article on implimenting FIFO and LIFO with SQL.
http://www.dbazine.com/ofinterest/oi-articles/celko32
http://www.dbazine.com/ofinterest/oi-articles/celko33
SQL = Scarcely Qualifies as a Language
June 3, 2009 at 10:45 am
The age works with exact dates and times without rounding. Take this case:
Backups complete
2009-05-01 20:00:10 ( 10 second after 8 PM)
2009-05-03 20:00:00 ( at exactly 8 PM)
Two days before...
SQL = Scarcely Qualifies as a Language
June 1, 2009 at 7:46 am
"Error Message: Maximum stored procedure, function, trigger, or view
nesting level exceeded (limit 32)."
As each stored procedure or trigger is invoked, the "nest level" is increased by one and SQL Server...
SQL = Scarcely Qualifies as a Language
May 31, 2009 at 5:21 pm
Viewing 15 posts - 211 through 225 (of 1,131 total)