by: Margo |
last post by:
Hi there
I am fairly new to php & MySQL. I have been trying to set up a query and
limit the result 12 records per page - 2 columns by 6 rows. Each record
contains various fields. I have been...
|
by: Ronald van Raaphorst |
last post by:
Hi all,
Is there a way to find the position of a certain record (id) in a result
set, based on a (autonumber id)?
Example:
My table has 2 fields: id & name, and the contents =
id name
1 ...
|
by: avinash |
last post by:
hi myself avi
i am developing one appliacaion in which i am using vb 6 as front end,
adodb as database library and sql sever 7 as backend.
i want to update one table for which i required data from...
|
by: war_wheelan |
last post by:
I am very new to Transact-SQL programming and don't have a programming
background and was hoping that someone could point me in the right
direction. I have a SELECT statement SELECT FIXID,...
|
by: David |
last post by:
I am using ADO to run some SQL statements in Access.
First, I run query to create a table using SELECT . . . INTO Table A.
Then, I run a query to SELECT . . . FROM Table A to get some data and...
|
by: Peter |
last post by:
Hello all,
I have the following t-sql batch:
create procedure stp_test
(
@p_date1 as datetime = null,
@p_date2 as datetime = null
)
|
by: elliottjeff |
last post by:
I was wondering if there is a way to create a stored procedure that I
can
DECLARE Variables
then set these variables using a select statment -- up to here works.
then use a different statement...
|
by: write2ashokkumar |
last post by:
hi....
i am using mysql 5.0.22 version.
i have the table xxx with 2 lakhs record. if i select all the records...it takes the long time to give the result set. is there any way to fine tune...
|
by: rsrinivasan |
last post by:
Hi all,
When i run below statement, i get some result set. But i want to store the results sets in some temp table. How can i store it?
DBCC SHOWCONTIG ('table_name') WITH TABLERESULTS
...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: 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: 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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|