|
john john mackey wrote: Since I am working in a loop and doing multiple INSERT INTO statements, I just increment primary key each time and I get the results I desire.
That's a really, really bad idea. The database doesn't keep records in any particular order in the table, so the key in the last record may not be the actual last key used. You ALWAYS let the database assign the keys and get it from the database when it's assigned. NEVER assume that the (last key you got + 1) is going to be the next key you're able to use.
This concept will also work even worse when the number of clients using the database exceeds 1.
|
|
|
|
|
hi guys
i have some problem regarding sql
i want to print the column names of a table,i know table name i dont know columns.
thanks in advance
regards
|
|
|
|
|
AVI51 wrote: i want to print the column names of a table,i know table name i dont know columns.
Since you posted this in the SQL forum, I am assuming that what you actually want is a way to get the column names out of the database rather than any particular presentation of the column names.
If you are using SQL Server (which you don't say) you can use the views in INFORMATION_SCHEMA
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @tableName
|
|
|
|
|
try this
sp_columns 'TableName'
|
|
|
|
|
you can execute
sp_help <tablename></tablename>
or
1.you can type the table name in query analyzer
2.select the table name and press alt+f1 keys
this works fine for me
hope this helps
|
|
|
|
|
hello guys, whats going on ? I have some questions I'd be very happy to someone helps me out !!!
what is the term "ARC", "super entity", "sub entity" if its possible give an example so I can get it better !!!
Thanx Guys !
Mr.K
|
|
|
|
|
|
I want to write a program to run SQL*PLUS on UNIX operating system. Before I run it, I should setting the system environment variables such as "ORACLE_HOME", "ORACLE_SID" first. But, I met with a question, I don't know from which profile I can get these information? Who can give me some suggestion?
Many thanks.
|
|
|
|
|
I don't understand your usage of the term 'profile' in your question. But the two variables you are trying to set are needed to identify the location of Oracle software, ie. where has Oracle been installed?. Talk to your DBA and find out this location. The second parameter identifies the database that you wish to connect to. There may be many instances of Oracle databases running, so again you will need to confer with your DBA to find out the name of the instance that you wish to connect to.
|
|
|
|
|
Well, may be you misunderstand my meanings. After the DBA installed the oracle software, he set these two variables. I think this information(ORACLE_HOME,ORACLE_SID) might be saved in a profile by the oracle process. And when I want to run the SQL*PLUS, I first read these information from this file, because the login user has changed, and the environment variable might be changed too. But I didn't know whether this file exist or not and its path. Do you have any idea about it?
Many thanks
|
|
|
|
|
Hi,
Can SQL Server 2005 receive emails with INSERT statements?
I am trying to insert data into SQL Server 2005 from a non-windows platform.
It seems that I have two options, either the SQL mail(if it can recevie emails) or the Endpoints feature. Does anyone has worked on similar solutions? Any other way to approach the issue? Please give insights into!!
thanks in advance,
-matt-
|
|
|
|
|
obymathew wrote: Can SQL Server 2005 receive emails with INSERT statements?
No. It can only send mail.
obymathew wrote: I am trying to insert data into SQL Server 2005 from a non-windows platform.
It seems that I have two options, either the SQL mail(if it can recevie emails) or the Endpoints feature. Does anyone has worked on similar solutions? Any other way to approach the issue? Please give insights into!!
Web Services might be another approach. I would, however, be very wary of allowing an external process supply raw SQL Statements. If you can get it to call stored procedures only then it might be a bit more secure.
|
|
|
|
|
Voted down to shoot the messenger?
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Mike Dimmick wrote: Voted down to shoot the messenger?
I dunno. It happens. I no longer really care. I got a spate of ones for a period of days during the summer. I guess I must have upset somebody. I find that I'm growing more intolerant of people who refuse to learn stuff, (as you can probably tell from my blog) and I probably upset one of them.
Curiously, I was talking to our new hire at the office Christmas party about what he thought of our interview process (mainly because I designed a fair few of the questions). He said he was really apprehensive about the technical test and was really worried about it, but when he saw the specification I handed him he suddenly realised it was a piece of piss. (Which it is! It isn't designed to trip anybody up - Everyone in the development team has taken the test, or varients of it as it was being developed). Anyway, the point about the aprehensiveness has been taken on board so next time round we'll be supplying a bit of information to the recruitment agent to give to the candidate to alleviate any fears any future candidates may have about it.
|
|
|
|
|
Microsoft have a JDBC Driver[^] if you're using Java.
Other than that you will have to implement some form of front-end server software - possibly using Web Services, as Colin suggests - to receive and translate queries.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
hi
how to declare and read array in sql server 2000
|
|
|
|
|
There is no inbuilt support for arrays in SQL Server. If your "array" is a comma-delimited string ov values like "va11, val2, val3" etc, you can use the string split functions available in the net.
SG
Cause is effect concealed. Effect is cause revealed.
|
|
|
|
|
I already told you in this post[^].
seems like you have doubt what I was saying.. Okay. If you have doubts or something, you can reply me back in the original post that you posted instead of opening the new thread....
|
|
|
|
|
Hi dears,
How can I change owner of all tables and stored procedures in my database?
I know with executing stored procedure sp_changeobjectowner I can do it , but I don`t want to execute it for each table and sp,
Thx for your help
www.behzadi.net
modified on Wednesday, January 02, 2008 5:20:30 AM
|
|
|
|
|
Do you want to change the owner of the database? You can change using sp_changedbowner
------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates
|
|
|
|
|
Does your database have any data in it? If not, you could always just generate the create script for your database and then change the owners using a global search and replace. There are other ways, but this is the easiest.
|
|
|
|
|
Hi all
Now i need to import access to sqlexpress but i haven't sqlserver 2005 so i have sql2000 but it dont run with sqlexpress.
Some body show for me?
Download tool or programd manager sqlexpress.
|
|
|
|
|
You can download "SQL Server Management Studio Express" or SQL 2005 Express Advanced service. but I'm not sure whether it has the functionality for importing the Access into SQL 2005 directly..
|
|
|
|
|
in my table i want to store the date only , but the problem is when i insert date only it automatically stores it with the time 12.00.00 AM,
how can i store only the date ?
|
|
|
|
|
You can't store the date on it's own as any form of date type. Nor should you need to. If you really want to do this, you could store the date in a varchar field.
|
|
|
|