sql-server-2008

What is the difference between the backtick and the square bracket in SQL statements?

by

I thought there would be another question about this but I was unable to find one. In MySQL with PHP I usually encapsulate my field names with backticks to mask any reserved names or characters. However, one of my colleagues has pointed out that this can also be achieved using square brackets. Excluding the fact that the backticks are not compatible with SQL server (apparently), what is the difference? Which should I use?

SQL Server 2008 R2 to MySQL Migration

by

Is there a GUI tool out there that will allow me to migrate entire SQL Server 2008 R2 databases to MySQL? I have MySQL Workbench installed, but it looks like there isn’t a feature in it like SSIS to copy and paste entire databases from SQL Server. I downloaded the MySQL Migration Toolkit, but it is no longer supported and I get a Java error when running it.

Replace Default Null Values Returned From Left Outer Join

by

I have a Microsoft SQL Server 2008 query that returns data from three tables using a left outer join. Many times, there is no data in the second and third tables and so I get a null which I think is the default for left outer join. Is there a way to replace the default values in the select statement? I have a workaround in that I can select into a table variable but it feels a little dirty.

convert varchar to month year format in sql server or javascript

by

I have a ”varchar” like ‘2020-08’ in ”sql” table. I need to convert it like ‘Aug 2020’ to show it in my web page. select convert(varchar,’2020-08′,107) This does not seem to work. Answers: Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue … Read more

sql runs fast in ssms slow in asp.net

by

I have been having this problem for a couple of weeks now. The problem is that the query takes 4-5 minutes to run on the website and at most 2 or 3 seconds to run in ssms. Also I found that after I make a change to this query like adding the customerId variable it will start running quickly on the web page but by the next day it is slow again. The query in question is this one: