Question About The @ Symbol

Sep 21, 2007

Hi,

I am a bit confused on the many uses of the @ symbol, such as in assignments and in use by stored procedures.  I am not quite clear on when it needs to be used and when it doesn't, what it means, etc.  Could someone either point me to a good reference, or explain?  (I have read several books on MS Sql server, but somehow missed this.)  I use the symbol, but I don't understand when to use it and when not to, without referencing an example.

Thanks,

View 1 Replies


ADVERTISEMENT

Euro Symbol Appears Like A '?' Instead '€'

Apr 6, 2004

I have SQL Server 2000 SP3 and the default Code Page is:

I have a Table with a column of the type 'text'.
In this column sometimes it's necessary introduce the euro symbol (€). Now, when we write this symbol, after the SQL Server show it with a '?'.

I tried change the column collation to 'Latin1_General_CI_AI', ‘SQL_Latin1_General_CP1_CI_AI’ and ‘SQL_Latin1_General_CP850_CI_AI’ but there is the same problem.

Does any know what the cause off this problem is?

Thanks in advance!

View 2 Replies View Related

Problem With Converting Symbol

Jun 23, 2008

hi..
sql statement
db.query(
INSERT INTO student(name, course, email) "+
"VALUES('" + name +"' , "+
"'" + course+"' , "+
"'" + email+"' ");

this sql statement doesn't content any error but if the sentences that want to insert into table contain symbol ' then it will process error when enter into table. ( data contain symbol ' can't insert into table).

May i know how to solve this problem.
i did refer to my friends they said need include java class, but they not sure what's the class that i need.

So i help i can get the help here.
Thank in advance

View 5 Replies View Related

Concat Symbol % With Result?

Aug 30, 2013

SELECT ROW_NUMBER() OVER (ORDER BY BM.BILL_NUMBER_V) AS [SL_NO],PP.KID_ID_NO_V AS [KID_NO],(PP.FIRSTNAME_V + SPACE(1) + PP.LASTNAME_V)AS [PATIENT_NAME],
CONVERT(VARCHAR(10),PP.UPDATEDDATE_D,101)AS [VISIT_DATE],BM.BILL_NUMBER_V AS [BILL_NUMBER],CONVERT(VARCHAR(10),BM.BILL_DATE_D,101) AS [BILL_DATE],
ROUND(BM.BILL_AMOUNT_M,2) AS [BILL_AMOUNT],ROUND(BM.CONCESSION_AMOUNT_M,2) AS [CONCESSION_AMOUNT],ROUND(BM.TOTAL_AMOUNT_M,2) AS [TOTAL_AMOUNT],

[Code] .....

In the above query i want to concat symbol '%' for output of percentage column. How to do that?

Eg: PERCENTAGE
30.00%
50.00%

View 1 Replies View Related

Euro Symbol, Charset 850 And Unicode

May 8, 2001

Dear experts,

I'm having a problem with the Euro symbol on my SQLServers which all have characterset 850 and Unicode collation 1033. As far as I can see charset 850 does not contain the € symbol, but if I run a query

DECLARE @nstring nchar(12)
SET @nstring = N'€'
SELECT UNICODE(@nstring), NCHAR(UNICODE(@nstring))

Result: 8364 €

So the Unicode character 8364 is the Euro symbol. My question now is how do I have to write a statement so that the € symbol is shown in the output.
I need to use something like the following:
Select 'Costs:'+ € + convert(money, table1.costs)
Result: € 123.00


I tried several options but never get the right output. Is there any way of doing it or do I have to change the characterset.

Markus

View 1 Replies View Related

HAND SYMBOL ON DATABASE BARREL

Oct 27, 1999

We are running SQL Version 7.0.
I recently set up a simple snapshot replication. After restarting enterprise manager a hand symbol showed up under the database barrel as if a share symbol.
Am I correct in assuming the symbol means replication. Is there a source that explains what the various symbols mean?

View 1 Replies View Related

Reporting Services :: How To Add Percentage Symbol

Jan 19, 2012

We are getting 67.2,62.4,81.9 these are percentages these are rounded values..so in my report I would like to add % symbol for them I have written expression like this

=left(Fields!Sales_Margin_TY____.Value,4) &
"%"

but I was getting 67.1 in place of 67.2 

I dont want to change the figures which is coming from source...

Just I want to add % for those values... how to do that ..

View 11 Replies View Related

Howto Remove Printer Symbol

Aug 10, 2007

I am looking for a way to remove the printer symbol from the report manger because it dows not work on some client machines because they are locked down. For us it is completely sufficient to export to PDF.

Is there a setting or an entry in the web config or something else. A hint would be helpful

Thanks
HANNES

View 3 Replies View Related

Tokenizing Column Data Using Pipe Symbol

Oct 13, 2006

Hey everyone,

 I'm working of a project that has each row of column data stored in this format: AAChieve Initiative - Business Development Consultant|Marketing|4F|210710
 Is there a way I can break this rows apart with TSQL based of the | symbol? Thanks in advance!
 

View 5 Replies View Related

SQL Server 2012 :: SET 1 Symbol Instead Whole String In Varchar Value

Jun 12, 2015

I have such Function:

IF EXISTS (SELECT * FROM sys.objects WHERE name = 'TwoDigitsNumber' AND type = 'FN')
DROP FUNCTION MinimumOFThree;
GO
CREATE FUNCTION TwoDigitsNumber(@a int)
RETURNS nvarchar(20)

[Code] ....

The only first letter 'f', 's', 'e' is inserted in value instead 'first', 'second', 'equal'.

Why ? How can i insert whole string

View 9 Replies View Related

Windows Mobil – SQL- Symbol MC70 Problem

Jun 9, 2006

Have an App using SQL CE 2.0. 
 
If the App is open and the device is powered off and then back on; the following happens when an update of the data base is attempted:
 
 
1. Pocket PC 2003 €“ IPAQ    No problem all is well.
2.  WM 2005 €“ Dell   No problem all is well
3.  WM 2005 €“ Symbol MC70  SQL error 0x80004005.**
 
App is compiled under eVC 4.0
 
** Some results if App is compiled under VS2005
 
Is this:
 a.) My problem ?
 b.) WM 2005 problem ?
 c.) Symbol problem ?
d.) SQLCE 2.0 problem?
 
 Any input would be appreicated
 
Thanks
 
JEK

View 9 Replies View Related

How Do I Format The Data As A Dollar Symbol With 2 Decimals

Oct 4, 2007



Hi,

I want to display data that is 10 as $10.00 or 10.1 as $10.10..

and i tried giving this expression


=IIf(Fields!Nav.Value = "n/a","n/a",(cstr(Format(Fields!Nav.Value,"C2"))))

But when i run the report its giving it as C2 and not $10.00 or whatever it should be.

any help will be appreciated.
Regards
Karen

View 3 Replies View Related

Give The Dollar Or Euro Symbol For Amount Field

Apr 9, 2008

Hai

I have amount field in my table as decimal. I need a query to display the amount with dollar or euro symbol based on country selection. The country also in same table.

For example If country is US then Amount $1200, If country is UK then Amount €1200.

Thanks in advance.

View 10 Replies View Related

Reporting Services 2005 - CSV - ASCII - £(Pound Symbol)

Oct 2, 2006

Hi

We are having problems getting Reporting Services 2005 to export to an ASCII CSV file and correctly produce a £(GBP sign).

I have changed my report server .config file to read:

<Extension Name="CSV1" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-8</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-8</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV2" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-7</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-7</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV3" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - ASCII</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>


And so far so good I get the three options to export to,

If I Export using the ASCII Rendering my pound signs come out as question marks (?) and subsequently loads into Excel as a general data type and is not sum-able.

If I Export using UTF-8 Rendering my pound signs come out as a weird character followed by a pound sign, again opened in excel loads as a General data type and is not summable.

If I export using UNICODE rendering, by file sizes are doublesd as you would expect, and then when you open in excel it is all bunched up in column 1, both un-acceptable.

Interestingly enough If I take the UTF-8 file I have and convert it to ASCII using Ultraedit, notepad or wordpad, everything works fine, the £ is correctly encoded, Excel loads it OK and it is summable, result, but I can not use get my end users to perform this "kludge" for an export.

Any help would be appreciated

Thanks

Tim

View 5 Replies View Related

How To Import Text File(no Space, No Symbol, No Column) Into Mssql

Dec 24, 2005

 the text file format use the length of character to define the field

for example,
0001130130HAUT BAGES AVEROUS 03

9 chars <0001130130> is a field
1 char <H> is a field
20 chars <AUT BAGES AVEROUS 03> is a field

one record by one record store in db
no space, no symbol, no line break between each record
----------------------------------------------------------

I try bcp method, but some error happens. Please give me suggestions. thx

I run the following code in query analyzer.

BULK INSERT Chain.dbo.POLL59
FROM 'D:POLL59.DWN'
WITH (FORMATFILE = 'D:cp.fmt')

?????
it shows the error

Server: Msg 4839, Level 16, State 1, Line 1
Cannot perform bulk insert. Invalid collation name for source column 4 in format file 'D:cp.fmt'.

***
For your information
data file
000000011301220051222000192000000000011301320051222000030000000000019067420051222000000001<there are many space >

bcp.fmt file <I use tab to separate and use ascii>
8.0
4
1    SQLCHAR    0    4    ""    1    PLUEVT    ""
2    SQLCHAR    0    9    ""    2    PLUSKU    ""
3    SQLCHAR    0    8    ""    3    PLUFRD    ""
4    SQLCHAR    0    9    ""    4    PLUPRC    ""

!!!!
I try to edit collation name in Chinese_Taiwan_Stroke_CI_AS or others, but the error also happens.

View 6 Replies View Related

SQL Server 2014 :: How To Split Phone Number Based On Symbol Dynamically

Jul 16, 2015

I would like to know how to split the phone number into two columns based on - symbol Dynamically.

for example

Phone Number
123-12323
1234-1222

so output should be

code number
123 12323
1234 1222

View 1 Replies View Related

Programatically Control Show/hide Parameters (chevron Symbol Function)

Jan 4, 2008

I'd like the state of the function bars to stay at whatever it was as the user moves from one report to the next rather than opening to full each time a new report is opened. Can this be done through a setting or programatically at teh report level? Is there a <default_toolbars_OpenState> tag or something?

Thanks in advance.

View 4 Replies View Related

Power Pivot :: Currency Symbol Dynamically Based On Column In Data-source?

Oct 15, 2015

Is it possible to include a currency symbol in an amount-field in PowerPivot/Pivottable based on a Currency column in a table? Something as the same as with SSAS MD. And I don't want fixed values in my code.

View 3 Replies View Related

How To Use A Table With Table Name Starting @ Symbol In Dataset

Jun 2, 2007



Hi ,



I have a database with a table name called @budget_tot.



When I run a query in report designer --dataset, it throws an error thinking this is a variable rather

than a table.



Same query works without error in SQL 2005 query window.



example Query;

Select T1.U_Budget From [@budet_tot] T1



Sonny

View 3 Replies View Related

Add Symbol To Column Values And Convert Column Values To Western Number System

Feb 12, 2014

I want to add $ symbol to column values and convert the column values to western number system

Column values
Dollar
4255
25454
467834

Expected Output:
$ 4,255
$ 25,454
$ 467,834

My Query:
select ID, MAX(Date) Date, SUM(Cost) Dollars, MAX(Funded) Funding from Application

COST is the int datatype and needs to be changed.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved