Request For A Technical Term
Apr 13, 2006
I'm not really sure how to explain this, so please bear with me.
I have a SQL statement, such as:
SELECT TOP (10) FROM chartTracks
This works with SQL Server Express 2005, but when I moved my site over to work with a MSSQL Server 2000, the statement had to be changed in order for it to work:
SELECT TOP 10 FROM chartTracks
I was just wondering if there was a technical term for this, and if possible, the locations of anymore sourecs of information regarding the above?
I'm just writing a report and would like to include this, if possible.
Thanks in advance!
View 2 Replies
ADVERTISEMENT
Apr 18, 2007
Hello,
Although this SP intends to sorround a search text in double quotes, it seems that when called from Management Studio it throws a Syntax Error even before entering the SP.
createproc fts(@t nvarchar(1000)=null) as begin
select @t = '"' + @t + '"'
select @t
select * from dbo.products where CONTAINS(name, @t)
end
GO
exec fts @t = 'my product name'
GO
Msg 7630, Level 15, State 3, Procedure fts, Line 4
Syntax error near 'product' in the full-text search condition 'my product name'.
-------------------------
If I pass the string in double quotes I get a different error:
exec fts @t = '"my product name"'
Go
Msg 7630, Level 15, State 3, Procedure fts, Line 4
Syntax error near 'my' in the full-text search condition '""my product name""'.
Now, if I remove the quotes again and make the original call:
exec fts @t = 'my product name'
GO
-- Then it works fine.
Doing a :
dbcc freeproccache
GO
Shows the same behavior as outlined initially.
View 2 Replies
View Related
Mar 30, 2007
Hi,
SQL Server Data Mining comes with "Term extraction" and "Term Lookup" for phrase detection. Rather than using the GUI tool, how to utilize these two features in coding? Please assist! Thanks!
Mary
View 1 Replies
View Related
Oct 4, 2007
I am designing a ssis package,This is intends to mine text data(Data extracted from websites).
Term lookup/Term extraction has been used as tools for mining.
I have lookup terms defined with me for reference table,but the main problem lie in extracting the nearby text/number/charcters to these lookup terms during mining.
For example :
I found noun "Email" 200 (frequency score) times in my text,Now I want to extract nearby email address(this is also true for PhoneNumber,Address attributes also).so how can I achieve this with SSIS.
If u have some idea/suggestion to carry out this challenge with or without Term Extraction/Term Lookup,plz do write here.
View 1 Replies
View Related
Feb 23, 2008
I get this error message when I try to connect to Reporting Services via the Management Studio.
I can see my machine listed in the Server Name > Browse For More > Local Servers dialogue. But no luck,
Ive tried:
Servername: localhost
Servername: DED1774 (the machine name)
Servername: localhost/reportserver
Servername: DED1774/reportserver
Servername: http://ded1774/reportserver (from the rsreportserver.config file
<UrlRoot>http://ded1774/reportserver</UrlRoot>)
I've Googled the error message and found postings for solutions, but none of these helped. Can anyone suggest some simple steps I can take to try to find the issue and get the connection working?
Thanks
View 3 Replies
View Related
Oct 27, 2005
Unlike the majority of this posts, my question isnt anything technical, what i needed to know is if anyone knows any SQL Server presentation, giving a overview of the application (its history, layers, services,etc) that i can download? I´ve searched on this website and on google but so far didnt had much luck since most presentations i find are very narrowed and dont give the general overview that i needed from SQL Server.
Thanks in advance and sorry about my english since its not my native language ;)
View 7 Replies
View Related
Feb 2, 2006
Hi everyone,
I am making my first steps to SQL..
someone can help me ....
saying to me some place where it could lower papers, technical manuals, etc ... of SQL
I would like knowing the commands and processes that SQL handles,
with the idea of doing my own programs.
Example, simple....
DECLARE @dt datetime
SELECT @dt = 'Jun 13 1995 12:00:00'
SELECT CONVERT(varchar(10),@dt,101)
in this code the commands are seen....
DECLARE
@
CONVERT
Can someone please help me
Thanks
View 3 Replies
View Related
Oct 11, 2007
Hi,
My question concerns the number of connections reporting services opens to generate a report with
several subreports in it.
I have a main report with 3 datasets, all based on different store procs. In the same report i also have
2 subreports who each have 1 dataset, also based on store procs.
When the report is being generated, how much connections does RS opens to the sql server?
Greetz,
Vinnie
View 1 Replies
View Related
Apr 10, 2007
Hi,
I'm a newbe in SQL Server and I have to build "Detailed Technical Design" Document regarding the SQL Server . If anybody knows something or has an example / structure about this document please send me a replay.....
Thank you in advance
View 1 Replies
View Related
Jun 14, 2007
I find difficulty in getting started with the service broker, and didnwt find a simple example.
I understand service broker is used for usynchronous jobs.
For example- I want to have a service that will perform SQL commands.
What are the necesary commands to create the queue,
to add the comand "Update MyTable Set MyField=1" to it,
and to get the command and perform it in another sesion?
View 3 Replies
View Related
Jul 23, 2005
HelloWe have the challenge to introduce for our database applications adynmaic search for the end users. The end users are non-technicalusers.I am looking therefore for possibilities which would allow to build ownquery language with expressions according to the need and skills forthe users.I found one product so far. "EasyAsk - Decision Adviser". does somebodyknow also other tools or frameworks which can be integrated?http://www.easyask.com/product*s/decision-advisor.cfmThe environment is currently MS SQL Servers and C# Webservices.Myvision is to have a framework or library which can be seamlessintegrated into our existing solutions which is currently a smart C#clients. i.e. by using web-service or an C# API.thanks Mark Egloff
View 1 Replies
View Related
May 9, 2004
There are many references in the BOL for the term "ad hoc":
ad hoc query
ad hoc updates
ad hoc monitoring
ad hoc testing
ad hoc view
ad hoc name
...
What are these terms mean? I'm especially interested in the terms ad hoc query and ad hoc updates.
View 1 Replies
View Related
Jan 26, 2008
what use reason of 'weighted-term' ?explain it.
SELECT ID, firstname, lastnameFROM [contain-1]WHERE CONTAINS(firstname, 'ISABOUT(mohsen weight(.8),yaser weight(1.0))')
table [contain-1] information:
ID FIRSTNAME
1 mohsen
2 mohsen
3 yaser
4 mehdi
thanks,mohsen
View 1 Replies
View Related
May 12, 2006
I've just started using the SSIS and i would like to know if it's possible to change or update the dictionary of the term extraction tool. That's important to me because i may have to look for words that don't exist in the defaut english dictionary of the tool.
Thanks.
View 3 Replies
View Related
Aug 14, 2007
hi brother
what is the use of the term lookup please give me the
example
regards
koti
View 3 Replies
View Related
Feb 1, 2006
Hi,
Can you search a column of a database table to find all the rows that have a wor in it?
example: I have a row that contains 'adventure st north', there are other columns in that table that are suppose to be the same but read 'adventure street N.' or 'adventure st. N.' or 'North Adventure st.'
could I search for rows that contain 'adventure' in the column searched (lets call it columnA). I tried:
select * from tbl_test where columnA LIKE 'adventure' and got no results.
what is the way to do this?
Thank-you,
Eric
View 1 Replies
View Related
Aug 25, 2007
Just learning full-text searching in SQL Server 2005 and have questions about the proximity term "near".
1. How near is near? Measured in characters, words, or whatever?
2. How do you know? Is this documented? Can't find it anywhere.
3. Can it be adjusted? at design time? at runtime?
I have used a program called Sonar which has powerful proximity options that allow the user to specify proximity in terms of words at runtime. Would like to be able to do that but can't find much on "near" in the documentation other than it seems to relative, provides for left and right nearness, and allows for chaining of multiple search terms.
View 3 Replies
View Related
Nov 29, 2007
Hello,
when I extract nouns from a text with the Term Extraction Transformation, the destination indeed keeps the correct nouns but they are in a random order.
Is it possible to keep the order of these nouns and maybe already keep double occurrences?
Kind regards, _Rodney_
View 5 Replies
View Related
Sep 15, 2006
Is there a way to perform term extraction on each row in a table, and have the term extraction denote the frequency of the term on a per row basis rather than a per table basis?
Otherwise, is there a way I can take extracted terms and apply a sql function that returns the occurance of that term in each row?
Example: Row 1 = 2 hits, row 3 = 5 hits, etc.
View 4 Replies
View Related
Jul 10, 2007
Hi guys,
I have a field called URL in my table. I want to get the SEARCH TERM from a given URL and create a report based on that information. I'm getting difficulties, because the URL have different format depending up on the search engine
that the users use to browse. Some of the search engines are "google",".excite.com", "search.msn.","search.netscape", "search.lycos", "altavista", "search.yahoo" and many more.
Examples of the URLs from google :
http://www.google.com/search?q=S26+Collet+Chuck&hl=en&client=firefox-a&rls=org.mozilla:en-USfficial&start=30&sa=N -- The search term is S26 Collet Chuck
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2006-02,GGLG:en&q=kt21+kia -- The search term is kt21 kia
http://www.google.com/search?hl=en&q=Slagger+burning+Tables -- The search term is Slagger burning Tables
Does anybody have a sql query or used a CLR functions to get the SEARCH TERM from different search engine (URL).
Thanks in advance.
View 2 Replies
View Related
Aug 14, 2007
THIS IS THE ONE.TXT FILE
Customer called to complain that the ice maker on her fridge has stopped working model XXYY-3
Door to refrigerator is coming off model XX-1
Ice maker is making a funny noise XXYY-3
Handle on fridge falling off model XXZ-1
Freezer is not getting cold enough XX-1
Ice maker grinding sound fredge XXYY-3
Customer asking how to get the ice maker to work model XXYY-3
Customer complaining about dent in side panel model XXZ-1
Dent in model XXZ-1
Customer wants to exchange because of dent in door model XXZ-1
Handle is wiggling model XXZ-1
Customer happy with us. Best fridge yet!
i created the table term_result(term_id varchar2(50)); ( termid ==xxyy-3 like)
now i want to find the no of times repeat the xxyy-3 posted queries
ERROR :
DT_NTXT OR DT_WSTR TYPES ONLY ALLOWS HERE ERROR I AM GETTING SO
Flat File Source-----------> Data Conversion --------->Term Lookup -------->Oledb data source
one.txt DT_stR I choosen error occur here
SO WHAT IS THE DATA TYPE I HAVE TO GIVE FOR THAT MATCHING LOOKUP
REGARDS
KOTI
View 1 Replies
View Related
Jul 25, 2005
Hi all,
I got a problem, i'd like to update my DB in production in terme of
design and data from the DB test. In other words, I added many tables
to my design.
Therefore, i'd have to update the real DB on the server. Is there a way to do so with MSSQL? without doing it manually.
Thanks,
View 5 Replies
View Related
Oct 19, 2007
for example : " server={0};database={1};trusted_connection=true;application name={3}"
The article SqlConnection.ConnectionString Property refer this term,but doesn't specify use.
I want to know whether it will affect sql server and how to find its effect
thanks
View 3 Replies
View Related
Jul 23, 2007
I'd like to get some ideas for the following:
I am writing a quick mini-application that searches for records in a database, which is easy enough. However, if the search term comes up empty, I need to return 10 records before the positon the search term would be in if it existed, and 10 records after. (Obviously the results are ordered on the search term column)
So for example, if I am searching on "Microsoft", and it doesn't exist in my table, I need to return the 10 records that come before Microsoft alphabetically, and then the 10 that come after it.
I have a SP that does this, but it is pretty messy and I'd like to see if anyone else had some ideas that might be better.
Thanks!
View 2 Replies
View Related
Jan 25, 2008
hi, I have a question regarding calling sql table columns dynamically? workflow would go as:1. user enters search term into a textbox2. user checks a checkbox to search by column in sqldb (eg.. firstname or surname) pseudo sql would go like......SELECT +%column1(checkbox1.value)%+ OR +%column2(checkbox2.value)%+ OR +%column3(checkbox3.value)%+WHERE column1 = +%TextBox.Text%+ OR column2 = +%TextBox.Text%+ 3. display results in gridview my sql needs to improve greatly so any code insight(good book or link) would be terrific . thanks
View 10 Replies
View Related
Jun 19, 2008
Hello,
I want to search a column with all the words deliminate by underscore. E.g. User_id, Community_name, author_id and etc.
It seems like freetext only deal with string with blank deliminator. How should I do the rull text search on column like this? Here is the code.declare @var varchar(2000)
set @var = 'id'
select [name], definition,version_code
from dbo.base
where freetext([name],@var)
thx
View 3 Replies
View Related
Feb 11, 2015
Why terms are not being corrected on a partial match? I thought this was the point of term based relation rules.
I am testing in an email address (nvarchar) field?
E.g. trying to correct @@ to @ and .con to .com (just to test)
And everything passes.
If I test with an entire value, the field is corrected.
E.g. 605688878@@qq.com corrects to 605688878@qq.com if I enter those exact values as term based relations.
View 0 Replies
View Related
Nov 14, 2007
Hi, I test the following sql statement, finding that an error ocurs:
Msg 7630, Level 15, State 2, Line 3
Syntax error near '"' in the full-text search condition '"dsg SDRGDG " OR "sdfsdfsdfsdafdsafdsfds'.
DECLARE @searchTerm NVARCHAR(40)
SET @searchTerm = '"dsg SDRGDG " OR "sdfsdfsdfsdafdsafdsfdsafdsafdsafsafdfdsafdf"';
SELECT [JobTitle], [JobDes], [OpenDate], j.[URLRef], c.[CompanyName], c.[URLRef], c.[URLSource]
FROM JobWanted AS j INNER JOIN
Company AS c ON c.CompanyID = j.CompanyID
WHERE CONTAINS((JobTitle, JobDes), @searchTerm)
It seems too lengthy string will cause an error for full-text engine. I find the sdfsdfsdfsdafdsafdsfdsafdsafdsafsafdfdsafdf is truncated as shown in error message.
How to avoid this issue? Could I configre this limination?
Thanks in advance.
Ricky.
View 3 Replies
View Related
Jun 5, 2007
Hi,
I am currently designing a SSIS package to integrate data into a data warehouse fact table. This fact table has about 70 columns among which 17 are foreign keys for dimension tables.
To insert data in that table, I have to make several transformations and lookups. Given the fact that the lookups I have to make are a little complicated, I have about 70 tasks in my Data Flow.
I know it's a lot, but I can't find a way to make it simpler. It seems I really need all these tasks.
Now, the problem is that every new action I try to make on the package takes a lot of time. At design time, everything is very slow. My processor is eavily loaded each time I change a single setting in one of the tasks, and executing the package in debug mode takes for ages. If I take a look at the size of my package file on disk, it's more than 3MB.
Hence my question : Are there any limitations in terms of number of columns or number of tasks that can be processed within a Data Flow ?
If not, then do you have any idea why it's so slow ?
Thanks in advance for any answer.
View 1 Replies
View Related
Feb 1, 2000
Okay, I'm a novice! I installed Back Office with NT opperating system on my home computer. I want to learn SQL 7.0. This is incredible, but I can't launch the program. I've tried everything under Start, Programs, SQL, but nothing listed seems to get me into SQL 7.0. What am I missing? Help is most appreciated!!
View 2 Replies
View Related
Sep 26, 2007
So i have the following stored procedure that inserts data into a table then returns the table ID...
ALTER PROCEDURE [dbo].[spA_FSH_InsertVslLic1]
@RegistrationDateDATETIME,
@MartimeRegNumINT,
@FishingVesselNameVARCHAR(40),
@FishingVesselTypeINT,
@OperationalStatusVARCHAR(50),
@FishingVesselBasePortINT,
@FishingVesselRemarksVARCHAR(100),
@PreviousAuthorisationVARCHAR(50),
@FishingVesselLenghtNUMERIC(18,2),
@FishingVesselWidthNUMERIC(18,2),
@FishingVesselHeightNUMERIC(18,2),
@ConstructionPlaceVARCHAR(50),
@ConstructionCountryVARCHAR(25),
@ConstructionYearDATETIME,
@ConstructionShipyardVARCHAR(50),
@ConstructionHullMaterialVARCHAR(50),
@ConstructionRemarksVARCHAR(100)
AS
BEGIN
BEGIN TRY
--insert values into tb_vessellic_vsl_fsh
INSERT INTO tb_vessellic_vsl_fsh
(
vsl_RegistrationDate,
vsl_MartimeRegNumber,
vsl_FishingVesselName,
vsl_vst_VesselTypeID_fk,
vsl_OperationalStatus,
vsl_prt_BasePortID_fk,
vsl_VesselRemarks,
vsl_PreviousAuthorisation,
vsl_OverallLenght,
vsl_Width,
vsl_Height,
vsl_ConstructionPlace,
vsl_ConstructionCountry,
vsl_ConstructionYear,
vsl_ConstructionShipyard,
vsl_ConstructionHullMaterial,
vsl_ConstructionRemarks
)
VALUES
(
@RegistrationDate,
@MartimeRegNum,
@FishingVesselName,
@FishingVesselType,
@OperationalStatus,
@FishingVesselBasePort,
@FishingVesselRemarks,
@PreviousAuthorisation,
@FishingVesselLenght,
@FishingVesselWidth,
@FishingVesselHeight,
@ConstructionPlace,
@ConstructionCountry,
@ConstructionYear,
@ConstructionShipyard,
@ConstructionHullMaterial,
@ConstructionRemarks
)
DECLARE @ID AS INT
SELECT @ID = @@IDENTITY
PRINT @ID
RETURN @ID
END TRY
BEGIN CATCH
EXECUTE spA_GEN_LogError
END CATCH
END
now in the c# code i am calling the stored procedure through this:
public void InsertVslLic1(DateTime regDate, int martimeRegNo, string vesselName, int vesselCategory, string operativeStatus, int basePort, string vesselRemarks,
string previousAuthorisation, double lenght, double width, double height, string constructionPlace, string country, int constructionYear, string shipyard, string hullMaterial,
string structuralRemarks)
{
try
{
//Open Connection
DBConnection db = new DBConnection();
db.OpenConnection();
//Create SQL string
string _sqlString = ("EXECUTE spA_FSH_InsertVslLic1 @RegistrationDate = '" + regDate
+ "', @MartimeRegNum ='" + martimeRegNo
+ "', @FishingVesselName ='" + vesselName
+ "', @FishingVesselType ='" + vesselCategory
+ "', @OperationalStatus ='" + operativeStatus
+ "', @FishingVesselBasePort ='" + basePort
+ "', @FishingVesselRemarks ='" + vesselRemarks
+ "', @PreviousAuthorisation ='" + previousAuthorisation
+ "', @FishingVesselLenght ='" + lenght
+ "', @FishingVesselWidth ='" + width
+ "', @FishingVesselHeight ='" + height
+ "', @ConstructionPlace ='" + constructionPlace
+ "', @ConstructionCountry ='" + country
+ "', @ConstructionYear ='" + constructionYear
+ "', @ConstructionShipyard ='" + shipyard
+ "', @ConstructionHullMaterial ='" + hullMaterial
+ "', @ConstructionRemarks ='" + structuralRemarks + "'");
//Execute SQL String
db.RunSQLQuery(_sqlString);
}
catch (Exception ex)
{
throw ex;
}
}
RunSQLQuery being:
public int RunSQLQuery(string sqlStatement)
{
if (_sqlConnection.State != ConnectionState.Open)
_sqlConnection.Open();
_sqlCommand = new SqlCommand(sqlStatement,_sqlConnection);
return _sqlCommand.ExecuteNonQuery();
}
Now i am stuck on how i will get the ID from the sp (that is @ID) and return it to my C# code as i need it to update the same row further on :)all i am getting till now is the number of rows 'changed' i.e. 1! any thoughts? thanks
View 6 Replies
View Related
Jul 23, 2005
Hi,I have quite a complicated request to do in sql.I've got on table with 3 fields (id, field1, field2) and I have toprocess a request on each of the records, one by one, and thendetermine if the status is OK for each recordsFor example, I would check if the sum of field1 and field2 is greaterthan 10.What is the best way to do this ? It has to be done in a storedprocedure. I can't return the status for each one of the records, soshould I store it in a temporary table and do a select on it from mytier application (vb.net) ?ThxSam
View 7 Replies
View Related
Jul 23, 2005
Hi,I'm going to explain as clearly as possible:I have two tables:Relationships(relation_id, table1, table2)Relationfields(relation_id, field1, field2)In Relationships, relation_id is the primary keyIn Relationfields, relation_id is the foreign keyI have a front-end interface that allows the user to add records toRelationships and Relationfields as followed:The user selects a table1 and table2 values from listboxes. These arereal table names from sys.objects, so then the user can select fieldsof these tables on which he wants to create a JOIN.Anyway, I can easily insert the table1 and table2 into Relationships(relation_id is an auto-increment). Then I need to get the relation_idof this new Relationship (easy since I know which values I've insertedand table1-table2 associations are unique.Now the PROBLEM :I need to insert into Relationfields all the fields selectioned by theuser for each of the two tables . But the user might have selectedseveral fields from table1 and table2, so I need to pass A LISTPARAMETER to my Stored Procedure as I don't know how many values offield1 and field2 there is going to be.I hope this is clear enough. Is it possible to achieve what I want ?Should I pass an entire concatenated string with values separated bycomma or whatever and then decrypt it in the stored procedure ?Thx
View 7 Replies
View Related
