Vista - Simple question

What is the significance of and @ prefix of a string. I see it mostly used
in a SQL statement .

Thanks

"@" has no general significance in a string.

In SQL statements, some data providers use "@" to indicate a
parameter. Using parameters rather than putting the values directly
in the SQL statement has several advantages, including automatic data
type conversion, prevention of SQL injection attacks and the ability
for the backend to calculate the execution plan once for multiple uses
of the statement.

On Thu, 29 May 2008 11:11:40 -0400, "Phil Hunt" <aaa@xxxxxx> wrote:

I understand what you are saying.
But maybe I should give an example right out of a book I am reading.

In C# :
String strConn = @"Data Source=.\SQLExpress;" +
"Initial Catalog=Northwind"

The @ sign is not insdei the string. I cannot find any explanation anywhere
what this means.

TIA

"Jack Jackson" <jjackson@xxxxxx> wrote in message
news:vo0u34hm92ubmss00bcfvvnk8hvnkuqaov@xxxxxx

Now I think about it. It may something to do with the escaple character \

Right ?

"Phil Hunt" <aaa@xxxxxx> wrote in message
news:uPbh%23AdwIHA.5620@xxxxxx

Hi Phil,

That is because if you dont use @, you have to use \\ to express \ inside
a string..

So, if you dont use @,
String strConn = "Data Source=.\\SQLExpress;Initial Catalog=Northwind"

and if you use @,
String strConn = @"Data Source=.\SQLExpress;Initial Catalog=Northwind"

Look at MSDN for more information,

Jigar Mehta

Phil Hunt <aaa@xxxxxx> wrote:It's a verbatim string literal:

http://pobox.com/~skeet/csharp/strings.html

--
Jon Skeet - <skeet@xxxxxx>
Web site: http://www.pobox.com/~skeet
Blog: http://www.msmvps.com/jon.skeet
C# in Depth: http://csharpindepth.com