by: Don Crossman |
last post by:
Assume a MYSQL table, foo.
One column, bar datetime.
Two rows:
2004-01-01 08:00:00
2004-02-01 08:00:00
select * from foo where extract(day from bar)=1;
2 rows in set...
|
by: m3rajk |
last post by:
I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and...
|
by: Todd Michels |
last post by:
Hi all,
I am trying to send data from a form and insert it into a MSSQL DB.
When I submit the data I get: Warning: mssql_query()
: message: The name "Todd" is not permitted in
this context....
|
by: clintw |
last post by:
I'm trying to convert a MSSQL select statement to MySQL, but am having difficulty with the following section:
...
INNER JOIN tableA ON tableB.field1 = tableA.field1
INNER JOIN tableC ON...
|
by: exclaim |
last post by:
Apologies if this is not the right forum.
I have an application written originally to work with MySQL which now
has to be extended to work with MSSQL also. I have modified all my
database calls...
|
by: omeek |
last post by:
I'm new to MSSQL (Have used MySQL for a little while) and am completely stuck. I have searched the net for days now and am amazed at how little info is out there for MSSQL.
I am selecting multiple...
|
by: Gosth in the shell |
last post by:
Hi there, i need some help
I got a software to backend is MSSQL 2005, but a provider software
requires an UPDATE on his table with MySQL 5.0.56a backend, so i made
the next:
download and...
|
by: johnyjj2 |
last post by:
Hello!
I've got web application written in MSSQL and I need to run it on server. But on the server I've go MySQL (not MSSQL), PHP, KFWS.
Do I have to install MSSQL and have both MySQL and MSSQL?...
|
by: ssnaik84 |
last post by:
Hi Guys,
Last year I got a chance to work with R&D team, which was working on DB scripts conversion..
Though there is migration tool available, it converts only tables and constraints..
Rest of...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
2
