|
I don't have the data to test with but, I do believe that SUBSTRING works with the TEXT & NTEXT data types.
UPDATE
noteTable
SET
note = SUBSTRING(note,0,10000)
WHERE
DATALENGTH(note) > 10000
|
|
|
|
|
Thanks, that works. - Apparently I didn't look hard enough. I guess I didn't realize that substring existed. I tried substr and when that didn't work, I guess I thought that that function didn't exist.
Thanks again!
Marcus Spitzmiller
You will never hear me say, "I listen to pretty much everything." That is for people who don't care what goes in their ears.
|
|
|
|
|
Hello All,
I am looking to get some guidance and feed back from the community as to the prevalence and usage of the following technologies:
ODBC Descriptor support
OLE DB support
External Linked Server support
Data Link support for Data Transformation Services
Specifically I am hoping to find out when each technology should be used and the types of applications that use them. Additionally, I am wondering if there are alternatives to these technologies and why they may have been used instead.
Any guidance/feed back is appreciated.
Thanks,
---Jay
|
|
|
|
|
I have a stored procedure that can select data from several tables/views. One two of the parameters are DateTime fields. The SQL code is as follows :-
EXEC(N'SELECT * FROM ' + @objectName + ' WHERE DepotId = ' + @DepotId + ' AND [TIME] >= ' + @StartTime + ' AND [TIME] <= ' + @FinishTime + ' AND Intake = ' + @Intake + ';')
I am getting a error regarding the time parameters. I need to know how to format these for the where clause to work.
I have tried enclosing in double-quotes e.g. [TIME] <= "' + @StartTime + '" AND ...
I have also tried enclosiing hashes e.g. [TIME] <= #' + @StartTime + '# AND ...
neither works, please help
Steve Jowett
|
|
|
|
|
I've sorted it. I should have done it like this...
[TIME] <= ''' + @StartTime + ''' AND ...
Steve Jowett
|
|
|
|
|
Hi - As the subject lines suggests - can we do this in SQL 2005?
suppose I have a function_A - does certain calculations.
CREATE another_function_B<br />
(@driver int)<br />
RETURNS int<br />
AS<br />
BEGIN<br />
declare @output as int<br />
-- checks some certain type of conditions and then executes function_A<br />
select @output = dbo.function_A(@driver)<br />
return @output<br />
END
|
|
|
|
|
I don't see why not. Why didn't you just try it and see?
|
|
|
|
|
I did - it didn't get any results, which it should have. that is why decided to post a message.
I tried to debug the 'function' by using print statements but looks like that doesn't work. How could we write some debug statement?
|
|
|
|
|
Verify each item outside the UDF. That way you will see if it actually returns data.
|
|
|
|
|
hi i have one table like table.dbf & i want to link this table to mssql
pls help me for that
Gurudatta B. Shelke
|
|
|
|
|
i have databse designed in sql server 2000
i want to access that database in LAN
plz help me in this matter
abhijit
|
|
|
|
|
abhijitw wrote: i have databse designed in sql server 2000
i want to access that database in LAN
In the Server element in the connection string just specify the name of the machine that the SQL Server is installed.
|
|
|
|
|
yes sir i did the same.But, i got the following mesege:
SQL server does not exit or access denied
plz help me
abhijit
|
|
|
|
|
abhijitw wrote: ut, i got the following mesege:
SQL server does not exit or access denied
(1) Make sure the server name is correct in the connection string, or
(2) Check that the server is running, or
(3) Check any firewall issues
Hope this helps you out 
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
check your sqlserver security . you must be trusted user for sqlserver.
|
|
|
|
|
HI...
I have one TABLE.dbf foxpro file and i want to access this file from MS SQL Server 2000 so that i can update that file. plz help me for the same
Gurudatta B. Shelke
|
|
|
|
|
|
i have tried to use the link servers but i m not able to use it so pls tell me how to use linked server in detail
pls help me for this
Gurudatta B. Shelke
|
|
|
|
|
Hi,
when we create a non clustered index for a table, an index is maintained in the database, but when we create the same on a view , does it get saved anywhere !! , i am also aware that views are not persisted in the DB, so i am a bit confused in this.
|
|
|
|
|
When selecting from a view, you will normally use the indexes on the base tables. In SQL Server (2000/2005) you can create indexes on a view (views are really virtual tables), but there are several caveats on how they are created. See Books Online for more information.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
StringBuilder szMyQuery = new StringBuilder();
szMyQuery.Append("UPDATE [Player Data] SET [Player Data].[Father's Email] = \'");
szMyQuery.Append(txtDadEmail.Text);
szMyQuery.Append("\' WHERE [Player Data].[Player Number] = &");
szMyQuery.Append(int.Parse(lblOutput.ToolTip.ToString()));
szMyQuery.Append("&");
See what is wrong?
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
|
|
|
|
|
ExpertComing wrote: See what is wrong?
You're code is susceptable to a SQL Injection attack.
However, if this is not the problem you are having (and if it isn't now, it will be when the code is in production) you will have to give us more information. For example: What do you mean by "wrong"? Is it a compiler error? Is there a runtime error? What is the error message? What is the intended behaviour? What is the actual behaviour?
|
|
|
|
|
Colin Angus Mackay wrote: code is susceptable to a SQL Injection attack
It is amazing how many code pieces come through these forums that are susceptable to injection attacks...
I wish CPHog could have a keyboard shortcut to your article 
If you try to write that in English, I might be able to understand more than a fraction of it. - Guffa
|
|
|
|
|
For a start, you don't have to escape apostrophes in your query. I agree with Colin that you are wide open and vulnerable to Injection attacks with this type of query (you'd be much better using a stored procedure). Plus, why have you formatted your query like this? Why not use AppendFormat. Why parse an item to an integer? SQL doesn't care what your initial datatype was (or even know it). Are you really using the ToolTip to store the value (is it not in the Tag)?
You could rewrite this as:
szMyQuery.AppendFormat("UPDATE [Player Data] SET [Father's Email] = '{0}'", txtDadEmail.Text);
szMyQuery.AppendFormat(" WHERE [Player Number] = {0}", lblOutput.Tag.ToString());
I wouldn't recommend this code (see Sql Injection Attacks[^] for a much better way to do this).
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks everyone. Works great and I'll read that article.
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
