What Is The Meaning Of Nchar(0xFEFF)?
Aug 12, 2006When we send a message in service broker we send nchar(0xFEFF) in the start of the xml file.
What is the meaning of nchar(0xFEFF)?
Thank you.
Bishoy
ADVERTISEMENT
Get LangId By Nchar(1)
Apr 14, 2006Is it
possible in SQL 2005 to determine to which language symbol nchar(1) is
referred?
If
languages differ greatly, say, like Russian and English, can one write a function,
which, under the given alphabet, can determine to what language the symbol
belongs?
If the
languages have a similar alphabet, one is faced with the difficulties. For
example, it is needed to distinguish characters of American English from those
of Australian English or of English from those of any other European language
that uses almost the same alphabet. I don€™t know how to solve this problem.
What can you advise?
The final task
is to scan in Internet a great number of Web pages in various languages and to
make up a large dictionary, where each word will be entered in its language
group. It is in principle too important to select words in different languages
that use the same alphabet. Initial data for word selection will enter the
server in NTEXT format.
Yuri,
Do You Know The Its Meaning??
Feb 13, 2007In ado.net (using C#). have a statement such as "sqlCommand cmd=new sqlCommand(sqlStatement,stringConnection,sqlTransaction)". do you know the meaning of this bold parameter ? is it its tasks ? thank very much
View 1 Replies View RelatedWhat Is The Meaning Of This?
Nov 5, 2004I was looking at a Miscrosoft example of a SQL "INSERT INTO".
One example they give isINSERT INTO Northwind.dbo.Shippers (CompanyName, Phone)
VALUES (N'Snowflake Shipping',N'(503)555-7233') What does the "N" stand for (or do) in N'Snowflake Shipping'? Is this really needed? I've looked around some and can't find any discussion about it.
What Is The Meaning Of & ~
Apr 8, 2008Hi,
I cant understand what is the meaning of & ~. I have seen the same in following query. Could any one explain me please.
select p.action & ~convert(int, 0x10000000), N'column' = col_name(p.id, p.colid), p.uid, N'username' = user_name(p.uid),
p.protecttype, o.name, N'owner' = user_name(o.uid), p.id, N'grantor' = user_name(p.grantor)
from #output p, dbo.sysobjects o
where o.id = p.id
order by p.uid, p.id, p.protecttype, p.action
Thanks
-- Krishna
What Is Meaning Of 23,59,59
May 8, 2008set @pDate2= dbo.AsString(@pYear,@pMonth,@pDay2,23,59,59)
explain the above query
Meaning
Jun 12, 2008hey, can anybody help me to understad that code:
SELECT companies.Contact_Company AS am_label1,
ISNULL(Incident_CNT,0) AS NumberOfIncidents
FROM (
SELECT DISTINCT Contact_Company FROM HPD_Help_Desk
) companies LEFT OUTER JOIN (
SELECT COUNT(*) AS Incident_CNT, Contact_Company AS am_label1
FROM HPD_Help_Desk
WHERE Status< 5
AND DATEADD ("s", submit_date, '1/1/1970') >= CAST(CONVERT(char(8),GETDATE(),112) AS datetime)
GROUP BY Contact_Company
) IncidentsByCompany
ON companies.Contact_Company = IncidentsByCompany.Contact_Company
Thank you.
Meaning Of ~xxx~
May 14, 2008Code Snippet<Query>UPDATE OPTIONS SET OptionText = '~DrawerPort~' WHERE...
What is meant by "~" here?
Thanks
Meaning Of !=
Dec 2, 2007
In the following example the line of code
IF RIGHT(@StringArray,1) != @Delimiter
includes " != ". What does it mean?
Thanks, Bill
Full Example:-- Creates a UDF that returns a string array as a table result set
CREATE FUNCTION dbo.udf_ParseArray
( @StringArray varchar(max),
@Delimiter char(1) )
RETURNS @StringArrayTable TABLE (Val varchar(50))
AS
BEGIN
DECLARE @Delimiter_position int
IF RIGHT(@StringArray,1) != @Delimiter
SET @StringArray = @StringArray + @Delimiter
WHILE CHARINDEX(@Delimiter, @StringArray) <> 0
BEGIN
SELECT @Delimiter_position =
CHARINDEX(@Delimiter, @StringArray)
INSERT @StringArrayTable
VALUES (left(@StringArray, @Delimiter_position - 1))
SELECT @StringArray = STUFF(@StringArray, 1,
@Delimiter_position, '')
END
RETURN
END
GO
Meaning Of N
Nov 25, 2007An example for finding the length of a string is:
SELECT LEN (N'She sells seashells by the sea shore')
This returns 37. Without the N, it still returns the same 37. Why is N used?
Thanks.
Bill
Nchar, Varchar,char?
Jan 11, 2008What is the difference between the above data types in SQL? Which datatype should I use if I wanted both numbers and characters?
View 1 Replies View RelatedConversion From Char To Nchar
Apr 16, 2004Hello,
I am trying to convert a single code page MS Server database into a unicode database, using the unicode data types,NCHAR, NVARCHAR, NTEXT. The problem is that in the original database, indexes and constraints have been defined on the tables whose configurations need to be changed. As a result, the ALTER TABLE command fails. Are there any other alternative solutions?
Also, data from the old database needs to be preserved. The objective is to create a unicode database which keeps the old data intact as well as accepts the new data in unicode.
It would be great if you could help!
Thanks,
Sheetal.
Convert From Nchar To Money
May 1, 2008Hi i've a staging table were i have datatypes of nchar.
I'd like to convert these to money datatype
Am trying to do this like this but the data return is not correct there is aslo null and blank rows so i must account for them also.
select cast(IsNumeric((Value2)) as money)
fromtbl_Sales
Nchar To Decimal..which Transformation
May 24, 2007Hi,
I selected the columns which i need in the data source itself and i need 3 columns,one will direclty go to the destination without any change/transformation and about the other two i need to do few lookups.
When i try to do lookup for One column which has the datatype in the source as nchar(3) though the date in the column is a number(like 150,160,170 and so on), my lookup table(a dimension in DW) where i want to get the actual key by looking up with this number doesnt allow me to map to the dimension in the DW, as the Dimension has this column datatype as decimal (3,0)....i tried the datatype conversion to convert the nchar to decimal but it doesnt transform i dont know why...probably i am doing some mistake...Could someone suggest how to deal with this and which transformation to use..?
I'd really appreciate if someone on this forum suggest how to deal with this..?
thanks
ravi
Nothing much that i can do..!!
Conversion From Nchar To Numeric
Jun 20, 2007Hi ,
I have a column in my extract table as nchar(3) and in the destination (the same column with diff name ) it is decimal(3,0) .....i tried to use dataconversion transformation.....i even tried to use cast/convert fn's in the SQL Command (which i use in the "Source Transformation" to get the columns from the extract table).
I tried all the ways i can and still i get the same error..:
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80040E07. An OLE
DB record is available. Source: "Microsoft OLE DB Provider
for SQL Server" Hresult: 0x80040E07 Description: "Error
converting data type nvarchar to numeric.".
Can we actually do it...?? any help would be appreciated.
thanks
ravi
Nothing much that i can do..!!
Cannot Convert From Nchar To Money
May 1, 2008Hi i've a staging table were i have datatypes of nchar.
I'd like to convert these to money datatype
Am trying to do this like this but the data return is not correct there is aslo null and blank rows so i must account for them also.
select cast(IsNumeric((Value2)) as money)
from tbl_Sales
The Meaning Of Set NoCount On And Off?
Jul 12, 2006Any one help me out ?
Thank you very much .!
Meaning Of Identity
Dec 29, 2007Hello All,
Does anyone knows what is the meaning of IDENTITY in following 2 rows.
[UserId] [bigint] IDENTITY (0, 1) NOT NULL ,
AND
[ProductId] [bigint] IDENTITY (1, 1) NOT NULL ,
Thanks in advance
--kneel
What Is The Meaning Of LTRIM(N' ') ?
Sep 7, 2006Actually, I don't know what is the meaning and difference of "N" in thefunction.Thanks.
View 1 Replies View RelatedLooking For The Meaning Of Some Labels
Jun 27, 2006Dear fellows,
LOP_BEGIN_XACT, LOP_COMMIT_XACT,
LOP_INSERT_ROWS
Labels as the ones are easy recognizable when you explore LDFS by mean DBCC or whatever but on the contrary the following ones are tricky to reach the meaning:
LOP_IDENTITY_TYPE
LOP_DELTA_SYSIND
LOP_SET_BITS
Does anyone have any link related with this? I tried hard to search by Goog or something like that but unsuccessfully at all.
Char Nchar Vchar Nvchar !?
Feb 14, 2006Hello
in MS SQL 2000 for text it is possible ti use
char
nchar
varchar
nvarchar
what must be used and for what ?
I want to store normal text with occidental char (accents)
thank you
Nchar Or Char Or Nvarchar Or Varchar???
Apr 19, 2004Hi,
Which of the above data type (alongwith size) should be used for storing things like Customer Name, Company name etc . ???
Also, what really is the benefit of one over the over :confused:
Thanks
Differences In Results Of Nchar() And Unicode() Fu
Apr 3, 2008Hi,
I am working on an application that uses accent characters.
SELECT nchar(256) returns A. But if I do
SELECT Unicode(A) , then it returns 65 i.e. the value for simple 'A' character. I am confused, because I have data in nvarchar fields,
but when I do string comparison then A and A are treated as equal.
Please let me know, what could be the issue.
Thanks
Unicode Is Nvarchar, Ntext, Nchar
Apr 10, 2008When I tried to insert armenian by doing the following
insert into tablex (field1) values (N'testdata')
it does not display in query analyzer or in the database as armenian.
When I copy this to word it does not convert it.
What else am I supposed to do to get that information to redisplay the correct way and I would appreciate any tutorials or samples you can show or direct me to.
Howard
Severe Performance Hit With NCHAR Queries
Nov 22, 2006Hey there :)Sorry if I'm asking a dumb question here, but I'm still quite new to MS SQL,so this problem might appear larger to me than it really is.I'm trying to create a performance test environment for a Ruby on Rails andMongrel setup with an MS SQL Server 2000.The adapter, mssqlclient, uses some kind of "conversion" for unicode, here'sa quote from the homepage:"Automatically translate from proper UTF-16LE nvarchar fields in thedatabase to UTF-8 Ruby Strings you can display in your application"As far as the local DB designer knows, we're not using UTF16-LE nvarcharfields, unless it's something that happens implicitly.Either way, this is how a query from the mssqlclient adapter might look:SELECT TOP 1 * FROM Item WHERE (Item.Itemnumber = N'45783745')Response time the first couple of times was upwards of 20+ seconds, afterthe sql server has "awaken from its slumber", it's roughly 4 seconds.Omitting the "N" from the WHERE clause, response time is in milliseconds (asone would expect, regardless of the fact that there's currently >2.5million items in the table).Any tips on how to resolve this? Is the SQL statement bad, or is it aquestion of configuring SQL Server correctly?Thanks in advance for any help,Daniel Buus :)--http://www.rhesusb.dk
View 2 Replies View RelatedUsing REPLACE With NCHAR In A Stored Procedure
Jul 20, 2005I'm using replace in a stored procedure to eliminate carriage returnsa user might have entered in an Access field.The problem is that even though it seems to strip out the carriagereturn I can't get rid of the "□" character.This is my code:DECLARE @myReturn nvarchar(1)SELECT @myReturn = NCHAR(10)REPLACE(UserAddress,@myReturn,' ') AS myTEXTFor example, the user has entered:123 Oak StreetSuite 101What I get after running the replace is: 123 Oak Street □ Suite101lq
View 2 Replies View RelatedConverting Nchar To Int (or Numeric/decimal)
Jun 20, 2007Hi ,
I have a column in my extract table as nchar(3) and in the destination (the same column with diff name ) it is decimal(3,0) .....i tried to use dataconversion transformation.....i even tried to use cast/convert fn's in the SQL Command (which i use in the "Source Transformation" to get the columns from the extract table).
I tried all the ways i can and still i get the same error..:
[OLE DB Source [1]] Error: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80040E07. An OLE
DB record is available. Source: "Microsoft OLE DB Provider
for SQL Server" Hresult: 0x80040E07 Description: "Error
converting data type nvarchar to numeric.".
Can we actually do it...?? any help would be appreciated.
thanks
ravi
FTS Q - Proximate Meaning Of Phrases
Sep 20, 2005Hi
Is it possible to find records that contain the string "cyber-shot" when the value for search is "cybershot"?? (This is an example and I need a dynamic solution)
Thanks,
Inon.
Datacode Values Meaning
Mar 9, 2008Hi,
Does anyone know the meaning of the datacode different values? I understand that 0 is OK and 1 is not, what is the meaning of the rest? I have an execution with no errors except a datacode=3 in the PackageEnd event. What does it mean?
Thanks,
Liran
Meaning Of Datacode In Sysdtslog90?
Jun 13, 2006The documentation says:
"An integer value that identifies the event associated with the log entry. The value 0 indicates the event provided no identifier."
When I look at the sysdtslog90 table and I filter for 'PackageEnd' events, I see a value of 0, 1 or 3 in the datacode column. Is there any information I can glean from these values, e.g. package success or failure?
Datatypes Nchar/nvarchar Vs Char/varchar
Dec 2, 2005can anybody please explain me why microsoft using nvarchar/nchar instead of varchar/char in northwind database and pubs database. I know if a column holds unicode data you should use nvarchar or nchar but for me all those tables in northwind/pubs are not holding unicode data. but still why microsoft settled for nchar/nvarchar.
View 2 Replies View RelatedHow To Check Whether Nchar Columns Arabic Character Set?
Mar 5, 2008Hi
How can I check whether an nchar column contains Arabic character set? The only allowed values that can go into this column are English and Arabic.
Thanks,
Salman Shehbaz.
What Is The Meaning Of Using Curly Braces In A SQL Query
Dec 14, 2007When you write a sql query, some times there is curly braces within a query in a asp.net application. What is the meaning of that?
select column1, column2, column3
from table1
where column1 = 'somethin'
{LIMITDATE}
order by column3
So what is being used in here {LIMITDATE} and can some one explain this to me? I use C#.