minaalamshahi
سه شنبه 12 شهریور 1392, 00:43 صبح
سلام
مشکل کد من چیه وقتی میزارمش روی هاست ریال رو علامت سوال میزنه
امکان تغییر collation رو ندارم
SELECT tblGroupBook.G_Title, tblUser.U_Name, tblUser.U_Family, tblUser.U_Email, tblUser.U_Mobile, tblUser.U_Code, tblUser.U_PostalCode, tblUser.U_Comment,
tblUser.U_Accept, tblUser.U_Type, tblUser.U_Status, tblUser.U_MinPricePeyment, tblUser.U_CommisionPercent, tblBook.*, tblType.T_Name,
tblLanguage.L_Name, (CASE B_Accept WHEN ''TRUE'' THEN N''تاييد'' ELSE N''عدم تاييد'' END) AS STATEAccept,(CASE B_Hide WHEN ''TRUE'' THEN N''مخفي'' ELSE N''نمايش'' END) AS STATEHide,(CASE b_price WHEN ''0'' THEN N''رایگان'' ELSE (REPLACE(CONVERT(varchar(20), (CAST(b_price AS money)), 1), ''.00'', '''') +''ریال'') END) AS Price
,dbo.MiladiTOShamsi(B_UploadDate) AS datePersian ,(CAST(DATEPART(hour, B_UploadDate) as varchar(2)) + '':''+CAST(DATEPART(minute, B_UploadDate) as varchar(2))+'':'' + CAST(DATEPART(second, B_UploadDate) as varchar(2)) ) AS [HourMinuteSecond]
INTO mytbl
FROM tblBook INNER JOIN
tblGroupBook ON tblBook.G_Id = tblGroupBook.G_Id INNER JOIN
tblUser ON tblBook.U_Id = tblUser.U_Id INNER JOIN
tblType ON tblBook.T_Id = tblType.T_Id INNER JOIN
tblLanguage ON tblBook.L_Id = tblLanguage.L_Id
WHERE (1 = 1)
مشکل کد من چیه وقتی میزارمش روی هاست ریال رو علامت سوال میزنه
امکان تغییر collation رو ندارم
SELECT tblGroupBook.G_Title, tblUser.U_Name, tblUser.U_Family, tblUser.U_Email, tblUser.U_Mobile, tblUser.U_Code, tblUser.U_PostalCode, tblUser.U_Comment,
tblUser.U_Accept, tblUser.U_Type, tblUser.U_Status, tblUser.U_MinPricePeyment, tblUser.U_CommisionPercent, tblBook.*, tblType.T_Name,
tblLanguage.L_Name, (CASE B_Accept WHEN ''TRUE'' THEN N''تاييد'' ELSE N''عدم تاييد'' END) AS STATEAccept,(CASE B_Hide WHEN ''TRUE'' THEN N''مخفي'' ELSE N''نمايش'' END) AS STATEHide,(CASE b_price WHEN ''0'' THEN N''رایگان'' ELSE (REPLACE(CONVERT(varchar(20), (CAST(b_price AS money)), 1), ''.00'', '''') +''ریال'') END) AS Price
,dbo.MiladiTOShamsi(B_UploadDate) AS datePersian ,(CAST(DATEPART(hour, B_UploadDate) as varchar(2)) + '':''+CAST(DATEPART(minute, B_UploadDate) as varchar(2))+'':'' + CAST(DATEPART(second, B_UploadDate) as varchar(2)) ) AS [HourMinuteSecond]
INTO mytbl
FROM tblBook INNER JOIN
tblGroupBook ON tblBook.G_Id = tblGroupBook.G_Id INNER JOIN
tblUser ON tblBook.U_Id = tblUser.U_Id INNER JOIN
tblType ON tblBook.T_Id = tblType.T_Id INNER JOIN
tblLanguage ON tblBook.L_Id = tblLanguage.L_Id
WHERE (1 = 1)