Viewing 15 posts - 706 through 720 (of 1,124 total)
I don't think there is a function or option to enable/disable usage of noise words in SQL. The problem could the noise words file, which contains the noise words...
January 12, 2009 at 5:25 am
You have to form the SQL like...
SELECT [EmailAddress], [MonthlyAmount], [NullableProperty]
FROM TableProperties T
PIVOT( MAX( PropertyValue ) FOR PropertyName IN( [EmailAddress], [MonthlyAmount], [NullableProperty] ) ) P
January 12, 2009 at 5:12 am
I don't think that the row-limit size holds for large objects (such as max, text, image etc.), as this was one of the new features in SQL 2K5.
Here is a...
January 12, 2009 at 4:59 am
Mikael,
I am no expert:), but I liked to put my own thoughts on this.
Instead of reading the file row-by-row and forming the dynamic sql for every 1000 lines, what you...
January 12, 2009 at 4:36 am
ns.sharath (1/8/2009)
For that i will have to load the rows in Excel into a table.I was asking if you can get the count directly using the Excel?
No, you don't have...
January 9, 2009 at 12:09 am
1. You have to create a variable "TotalRows" (i.e. name doesn't matter) of Integer data type and an Execute SQL Task.
2. Set the connection property, SQLSourceType as "Direct...
January 8, 2009 at 5:43 am
You could write something like....
Dim oConn As ADODB.Connection
Dim szSQL As String
Dim rs AS New ADODB.Recordset
Set oConn = New ADODB.Connection
On Error GoTo ERRfnCheckDatabaseEX
oConn.Open "Provider=SQLOLEDB.1;" & _
...
January 7, 2009 at 6:44 am
The best possible ways that i could handle this is...
1. Convert the value to 14 digit before inserting data to the table. By doing this, I just avoided the...
January 7, 2009 at 5:14 am
Put parenthesis around the function call...
January 7, 2009 at 3:26 am
The "definition" column has line breaks already but you can't be able to view those in grid mode in SSMS, change it to text mode ([CTRL]+T ) ....
Edit:
Gail, you've got...
January 7, 2009 at 3:04 am
Are there any gaps between the start and end times for a v? If yes then what would be the expected result?
Based on the sample data & the required...
January 7, 2009 at 2:57 am
Are there any triggers defined on that table?
January 7, 2009 at 2:49 am
Check sys.parameters (for parameters) & sys.sql_modules (for code)
January 7, 2009 at 2:46 am
Viewing 15 posts - 706 through 720 (of 1,124 total)