I have an excel spreadsheet that I want to import select columns into my database table. the wiz didn't offer that option.
any easy code options?
Thanks
newbie
sir,
l want to display resultset in jframe.i get output last record in the database displayed.
Lam intrested to place next button,back button in the frame.when i was click in the back button previosly viewed record is displayed and vice-versa.i don't know it will be possible.plz help me
used is c# sql vs 08 sql server 2005 express
whenever and where ever an sql select statement is used, its always like
select * from tablename
or count statement
is alsi like
select count something from table name
for selecting or doing anything on the tables,
i would like to know which tables exits in my the database i am connected to!
so like
select alltablenames from database_name.
please guide.
I have a web service that I just coded up that drops an image (png) into my SQL Server 2008 database as a varbinary.
Is there a easy tool out there that can let me see that image?
I could code up a client, but I would rather just use a tool if one exists.
Is there a way to find out how much space (on disk) a row in my database takes up?
I would love to see it for SQL Server CE, but failing that SQL Server 2008 works (I am storing about the same data in both).
The reason I ask is that I have a Image column in my SQL Server CE db (it is a varbinary[max] in the SQL 2008 db) and I need to know now many rows I can store before I max out the memory on my device.
I read some tutorials on how to read data from a database.properties file- which basically stored key-value pairs.
What i want to know is, in which folder should I place this file? Is it in the root (ie "src") or within a package... And how do I access this file, if it is placed in "src"- my code will be within a package (and the package's directory will be under src)- so how do I access the properties file, which is in "src", from a class within a package?
This execution it is giving me an error!
Any hints of what am I missing?
declare @dbname varchar(500)
set @dbname='master'
Exec ('
Use ' + @dbname + '
go
create PROCEDURE [dbo].[krijo_database] @dbname nvarchar(2000), @Direktoria varchar(4000)
AS
BEGIN
declare @stringu nvarchar(100)
set @stringu =
''CREATE DATABASE '' + @dbname
exec (@stringu)
End
')
So I'm using the datepicker plugin to make an availability calendar. Here is my javascript:
http://pastebin.com/H7D9PcAg
When dpSetSelected() is called it is also calling dateSelected() which triggers the AJAX call to my PHP script. I need a way to only update the database if the date is clicked on and not pre-loaded. When I pre-load the dates they are sent to the PHP page and subsequently removed.
I am using ListView/DataPager.
For performance reasons I page my results at database, using ROW_NUMBER(SQl2005).
At my C# code just comes one page at time. How can I say to DataPager that I have more rows that really are at my List?
My application is a non-relational database application with a tcl interface to retrieve data. I would like to add SQL programming interface to my application.
Is there any library that converts SQL/PLSQL statements to API calls? It should also support stored procedures.
SQLite(Embedded) has 'virtual table' mechanism that suits my requirement but it lacks stored procedure feature.
-Gopala
How can I call Access's Compact and Repair Database utility from within C++? I'm already using ADO and ADOX, so a solution using either of those would be handy.
If userA deleted OrderA while userB is modifying OrderA, then userB saves OrderA then there is no order in the database to be updated. My problem is there is no error! The SqlDataAdapter.Update succeeds and returns a "1" indicating a record was modified when this is not true. Does anybody know how this is supposed to work, thanks.
I have a SQL Server Express database that has a query that should return about 230 thousand rows.
Problem is the query returns about 5 more rows each time you run the query.
What would cause something like this?
I ran 'DBCC CHECKDB' but that did not change the behavior. Any ideas.
thanks
Hi, i would like to create a Rails controller that download a serie of jpg files from the web and directly write them into database as binary
(I am not trying to do an upload form)
Any clue on the way to do that ?
Thank you
I would like to create an application from a database schema using seam-gen, unfortunatly informix isn't supported out of the box.
Where can I add another db?
Transactional Replication on SQL Server 2005 Enterprise x64 (SP3).
I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I prevent this?
Hi all,
Somebody knows how to change the user account and authentication method sharepoint uses to connect to its content database?
It is now setup to connect using Windows Integrated Authentication but I want to change that to a local user account.
Is it even possible to do this?
Thanks in advance
I would like to get a list of well-known buildings(museums, castles etc..) within X meters radius of the current coordinate. I would like to query them in PHP.
Do you know any such database that can be queried?
I'm looking for a way to get all rows as insert statements from one specific table within a database using pg_dump in postgres.
eg I have table A and all rows in table a I need as INSERT STATEMENTS, it should also dump those staements to a file
Is this possible?
This line:
used_emails = [row.email for row
in db.execute(select([halo4.c.email], halo4.c.email!=''))]
Returns:
['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']
I use this to find a match:
if recipient in used_emails:
If it finds a match I need to pull another field (halo4.c.code) from the database in the same row. Any suggestions on how to do this?
I want to create a Rails (2.1 and 2.2) model with ActiveRecord validations, but without a database table. What is the most widely used approach? I've found some plugins that claim to offer this functionality, but many of them don't appear to be widely used or maintained. What does the community recommend I do? Right now I am leaning toward coming up with my own solution based on this blog post.
I am using SQLite to store school classes. I want to fill in a Spinner with the classes that get stored in the database. How would I grab all the classes in the DB and load them into a spinner?
Hi, i would like to create a Rails controller that download a serie of jpg files from the web and directly write them into database as binary
(I am not trying to do an upload form)
Any clue on the way to do that ?
Thank you
Edit :
Here is some code I already wrote using attachment-fu gem :
http = Net::HTTP.new('awebsite', 443)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_NONE
http.start() { |http|
req = Net::HTTP::Get.new("image.jpg")
req.basic_auth login, password
response = http.request(req)
attachment = Attachment.new(:uploaded_data => response.body)
attachement.save
}
And I get an "undefined method `content_type' for #" error