Does anyone know what does the "@" meant?? Does it meant suppressing the error output?
Code:
sqlConnection sqlConnection = new SqlConnection(@"Integrated Security=SSPI; Data Source=(local)SQLEXPRESS");
Dear Experts, what exactly the defragmentation in sql server? what is the use
Vinod
Even you learn 1%, Learn it with 100% confidence.
Hi,I have a gridview on a page, which should select data from a database. I want it to select the data row if it finds its UserName in the UserName column, but there will be many usernames in the username column, seperated by commas.Here is the select statement that I have at the moment, which doesnt return any data atall:SELECT [message], [senddate], [subject], [messageid], [sendername], [recievername] FROM [Messages] WHERE ([recievername] LIKE '% ' + @recievername + ' %')@recievername = Profile("UserName") which is the vwd wizards way of saying the current user. A Username column has data like this:bezzer , bezlan , beezer , beezler with a space between commas and a space at the start and the end.Thanks if someone can help!Jon
View 2 Replies View Related