Is there a Profiler equivalent for MySql?
Something cool that is in version 5.0.37 of the community server is MySQL’s new profiler. This may give you what info you are looking for.
sql-server
Get everything after and before certain character in SQL Server
If you want to get this out of your table using SQL, take a look at the following functions that will help you: SUBSTRING and CHARINDEX. You can use those to trim your entries. A possible query will look like this (where col is the name of the column that contains your image directories: Bit of an ugly beast. It … Read more
To add server using sp_addlinkedserver
I got it. It worked fine Thank you for your help:
SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
One option is to put the subquery in a LEFT JOIN: Perhaps a better option would be to use SUM with CASE: SQL Fiddle Demo with both
I want to use CASE statement to update some records in sql server 2005
Add a WHERE clause
Temporary table in SQL server causing ‘ There is already an object named’ error
You are dropping it, then creating it, then trying to create it again by using SELECT INTO. Change to: In MS SQL Server you can create a table without a CREATE TABLE statement by using SELECT INTO
Conditional JOIN Statement SQL Server
I think what you are asking for will work by joining the Initial table to both Option_A and Option_B using LEFT JOIN, which will produce something like this: Example code: Once you have done this, you ‘ignore’ the set of NULLS. The additional trick here is in the SELECT line, where you need to decide … Read more
How to execute a stored procedure within C# program
I want to execute this stored procedure from a C# program. I have written the following stored procedure in a SqlServer query window and saved it as stored1: EDITED: This displays the exception Cannot find the stored procedure dbo.test. Do I need to provide the path? If yes, in which location should the stored procedures … Read more
Error converting data type varchar
OK. I finally created a view that works: Thanks to AdaTheDev and CodeByMoonlight. I used your two answers to get to this. (Thanks to the other repliers too of course) Now when I do joins with other bigint cols or do something like ‘SELECT * FROM MyView where mycol=1’ it returns the correct result with … Read more
How to write a foreach in SQL Server?
You seem to want to use a CURSOR. Though most of the times it’s best to use a set based solution, there are some times where a CURSOR is the best solution. Without knowing more about your real problem, we can’t help you more than that: