Ребят, подскажите посредством php отправляю ооочень длинный запрос к ms sql . Вопрос, как быть с кавычками? обЪединять точкой?

А в чем собственно загвоздка та, можно пример ?
Я все запросы к базе пишу в двойных кавычках, и ни каких трудностей не испытываю.

$sql = "SELECT * FROM `$table` WHERE id IN (". implode(',', $all) .") AND name = '". $value['name'] ."' ";

Kusss

SELECT  
  isnull(PDSCards00.FOLDER1,isnull(PDSCards01.FOLDER1,' '))+'-'+isnull(PDSCards00.FOLDER2,isnull(PDSCards01.FOLDER2,' '))+'-'+isnull(PDSCards00.FOLDER3,isnull(PDSCards01.FOLDER3,' ')) AS "DEP",
  sum(DiscParts."SUM") AS "DISCSUM",                                                                                                                   
  (CASE WHEN (ROW_NUMBER() OVER (PARTITION BY PrintChecks00."CHECKNUM",DishDiscounts00."HOLDER",CURRENCIES.NAME ORDER BY PrintChecks00."CHECKNUM")=1) THEN 1 
 ELSE 0
 END)  AS "CHECKCOUNT", 
  Discounts00."NAME" AS "DISCOUNT",                                                                                                  
 
...

  Restaurants00."NAME" AS "RESTAURANTNAME",
  (CASE WHEN (ROW_NUMBER() OVER (PARTITION BY Discounts00."NAME",                                   
         DishDiscounts00."CARDCODE",                                                                              
         GlobalShifts00."SHIFTNUM",                                                                                                             
         GlobalShifts00."SHIFTDATE",                                                                                                           
         CashGroups00."NAME",
         Restaurants00."NAME" ORDER BY DishDiscounts00."CARDCODE")=1) THEN 1 
 ELSE 0
 END) AS "DISCOUNTVISIT"
FROM DISCPARTS                                                                                                                                         
LEFT JOIN PayBindings PayBindings00                                                                                                                    
  ON (PayBindings00.Visit = DiscParts.Visit) AND (PayBindings00.MidServer = DiscParts.MidServer) AND (PayBindings00.UNI = DiscParts.BindingUNI)     
LEFT JOIN CurrLines CurrLines00                                                                                                                        
  ON (CurrLines00.Visit = PayBindings00.Visit) AND (CurrLines00.MidServer = PayBindings00.MidServer) AND (CurrLines00.UNI = PayBindings00.CurrUNI)     

....

  ON (PaymentsExtra00.Visit = CurrLines00.Visit) AND (PaymentsExtra00.MidServer = CurrLines00.MidServer) AND (PaymentsExtra00.PayUNI = CurrLines00.PayUNIForOwnerInfo)
LEFT JOIN PDSCards PDSCards00
  ON (PDSCards00.AccountIdent = PaymentsExtra00.AccountIdent) AND (PDSCards00.MInterface = PaymentsExtra00.AddByInterface)
LEFT JOIN PDSCards PDSCards01
  ON (PDSCards01.AccountIdent = DishDiscounts00.AccountIdent) AND (PDSCards01.MInterface = DishDiscounts00.MINTERFACE)
     AND PDSCards01.CARDCODE=DishDiscounts00.CARDCODE
LEFT JOIN CURRENCIES 
  ON  CURRENCIES.SIFR=CurrLines00.SIFR 
WHERE                                                                                                                                                  
  ((PrintChecks00.State = 6) OR (PrintChecks00.State = 7))                                                                                                                                                                                              
group by
  isnull(PDSCards00.FOLDER1,isnull(PDSCards01.FOLDER1,' '))+'-'+isnull(PDSCards00.FOLDER2,isnull(PDSCards01.FOLDER2,' '))+'-'+isnull(PDSCards00.FOLDER3,isnull(PDSCards01.FOLDER3,' ')),
  DishDiscounts00."HOLDER", 

.....

  CURRENCIES.NAME		 

запрос . там уже есть кавычки и те и те