Asking for quotation

What is the difference ',"?what is the difference between a question mark and an exclamation mark!

they are different because of different purposes?

:)

the single quote is for strings

the double quote is for table/column names containing special characters|||the double quote is for table/column names containing special characters...though the more common method of handling this is with square brackets: create table tbl1 ([Total All] int)|||...though the more common method of handling this is with square brackets: create table tbl1 ([Total All] int)... though the standard sql method of handling this is with doublequotes: create table tbl1 ("Total All" int)

isn't it nice to know that sql server supports the standard sql method :) :)|||if you called the table TotalAll with no spaces, then you wouldn't have to type so many " and/or [].

also TotalAll seems redundant to me. how about AbsolutelyEverythingTotalAll? :)