No announcements
Found 1604658 threads
-
1 Votesdifference between adhoc query & SP
In each case the query plan for the first query is reused for the second query (reuse), and the plan of the first query depends on the parameter value passed ...Answered | 7 Replies | 4803 Views | Created by Kayadhu - Monday, February 4, 2013 6:36 PM | Last reply by davidbaxterbrowne - Tuesday, February 5, 2013 10:25 PM
-
1 Votes
mysql quota blade error
just for knowledge, those two services were runinng, i had to restart them, and then i could create the quota for the mysql service.Answered | 4 Replies | 465 Views | Created by icecore - Tuesday, January 24, 2017 12:08 PM | Last reply by CHEEKATLAPRADEEP-MSFT - Wednesday, March 1, 2017 7:14 PM -
1 Votes
SharePointFoundation and MySql
If you're looking to host the farm's configuration, content, and service application databases in MySQL, no that is not possible.Answered | 2 Replies | 7399 Views | Created by Raj_Kiran2009 - Saturday, March 5, 2011 9:33 AM | Last reply by John Ferringer - Saturday, March 5, 2011 7:17 PM -
0 Votes
SP to Send Email based on Query
How would I get the email to list information from the table such as SerialNumber, if there are more than one that meets the query criteria.Answered | 3 Replies | 4586 Views | Created by Ronald-L - Monday, October 19, 2009 5:57 PM | Last reply by Abdshall - Monday, October 19, 2009 7:57 PM -
1 Votes
MS SQL equivalent of MySQL query
I am using the following query which works in MySQL but doesnt work in MS Access UPDATE ...Answered | 2 Replies | 6939 Views | Created by prakhar.goel - Sunday, July 18, 2010 2:58 PM | Last reply by Sylvain Lafontaine - Sunday, July 25, 2010 3:56 AM -
8 Votes
MySQL Powerpivot Import Fail
I've finally been able to go get a query to at least "start" running, but get a "catastrophic failure" error like the above.Answered | 11 Replies | 18471 Views | Created by imjss - Wednesday, November 16, 2011 3:30 AM | Last reply by MKogler - Tuesday, August 6, 2013 5:29 AM -
1 Votes
VB.Net MySQL Null Exception Error
I did resolve the Null Exception error just now.Answered | 5 Replies | 5748 Views | Created by MrAnderson_ATL - Monday, June 7, 2010 3:25 PM | Last reply by DeborahK - Monday, June 7, 2010 5:44 PM -
0 Votes
Dataset(or datatable) Injection into a MySql Database
, from a job or another sp, if you have a table called specs, use: declare @Specs varchar(2000) --tell it the table name to use set @specs = ...Answered | 10 Replies | 15518 Views | Created by dagofthedofg - Wednesday, April 9, 2008 10:59 AM | Last reply by Chris Robinson- MSFT - Thursday, June 18, 2009 5:56 PM -
0 Votes
i need Update Query from Mssql to Mysql in LINKED Server
If you are using SQL Server 2008 then you could use SSIS to import the data to MySQL.Answered | 1 Replies | 5561 Views | Created by Ramya tirumalaraju - Friday, May 18, 2012 5:41 AM | Last reply by Sankar Reddy - Friday, May 18, 2012 11:38 PM -
0 Votes
VB to MySQL Error
Data Access » MySQL located here: http://forums.asp.net/56.aspx Have a great day!Answered | 1 Replies | 9067 Views | Created by MiCzZz - Sunday, January 25, 2009 3:27 PM | Last reply by Shrikant Maske - Friday, April 3, 2009 8:23 AM -
1 Votes
connection of database(mysql)
You need a query strSQL 2.Answered | 4 Replies | 2762 Views | Created by ckjason - Friday, March 23, 2012 1:28 AM | Last reply by Ellen Ramcke - Friday, March 23, 2012 6:23 PM -
0 Votes
MySQL Host Not Allowed Access
Narayanan Dayalan - Zeetaa Business Solutions ------- Please "Mark As Answer", if my answer works well with ur QueryAnswered | 4 Replies | 9903 Views | Created by dean2580 - Thursday, December 17, 2009 4:26 PM | Last reply by Narayanan Dayalan - Monday, December 21, 2009 5:04 AM -
0 Votes
sqlQuery to Mysql
Well, then you should ask this question in a MySQL forum..Answered | 2 Replies | 2205 Views | Created by BI_Support - Thursday, August 16, 2012 11:07 AM | Last reply by BI_Support - Thursday, August 16, 2012 11:34 AM -
0 Votes
MySQL to MSSQL null date errors
The one for data migration does not allow you to specify the substitution value though, the only options are "Set NULL" (default) and "Error".Answered | 3 Replies | 3454 Views | Created by BobInCT - Sunday, September 3, 2017 1:16 PM | Last reply by Alexander-Ivanov - Monday, September 18, 2017 10:14 PM -
0 Votes
Error creating MySql DB on Azure
The only problem is with MySQL.Answered | 3 Replies | 806 Views | Created by Lasha Amashukeli - Saturday, July 25, 2015 11:46 AM | Last reply by Syed Irfan Hussain - Tuesday, July 28, 2015 8:54 AM -
0 Votes
Difference in terms of speed for SP and Query text.
It may be the case that when SP is called, it finds the execution plan from procedure cache so SQL Server re-use it.Answered | 5 Replies | 973 Views | Created by Lenoj - Wednesday, March 4, 2015 3:15 AM | Last reply by - Thursday, February 4, 2016 1:32 AM -
5 Votes
Connecting to remote Mysql - ODBC
Then for a later reset attempt, pass the user's answers in SP to validate, and if good, change that users Password..interesting..Answered | 6 Replies | 1205 Views | Created by donnyc - Friday, December 18, 2020 2:32 AM | Last reply by donnyc - Friday, December 18, 2020 9:31 PM -
0 Votes
Linked server to MySQL Problem
Isnt it easier to do the operations directly in MySQL using SQL queries?Answered | 5 Replies | 890 Views | Created by mykernel - Sunday, July 1, 2018 12:16 PM | Last reply by Visakh16 - Wednesday, August 1, 2018 4:57 PM -
0 Votes
Differences SQL and MySql
For your question: the SQL (sql language, not the server) query syntax is not so different.Answered | 4 Replies | 2074 Views | Created by DIEGOCTN - Friday, July 26, 2013 2:49 PM | Last reply by pituach - Sunday, July 28, 2013 4:46 AM -
0 Votes
mySQL to JSON
Hi, It is recommended to ask the question on MySQL forum for dedicated support.Answered | 2 Replies | 1781 Views | Created by anr164 - Saturday, April 5, 2014 8:10 AM | Last reply by tracycai - Monday, April 7, 2014 5:46 AM
No announcements
