hi<br/>can anyone tell me the substitute of the sql query<br/>DESC table_name<br/>in SQl Server query.<br/>i'm trying to access the structure of a table but the query doesn't work for SQL Server 2000

i am fetching problem while uploading JPG FILE in sql ?<br/> i am really getting confused in this matter<br/>plz assit me how to upload & retrieve the JPG FILE from sql server2000<br/>its urgent...<br/>waiting for your early reaply.........

Hi<br/>I want to load data from files into an Oracle DB. I tried to invoke the sqlldr command from a linux machine, but it gave me: command not found. I want to know if anyone has an idea on how to load data from files or what is wrong with the sqlldr command.<br/>islheg

Hi,I have an access database with a single simple table. Jobid Status1 busy2 busy 3 free4 free5 free When a user wants the next job, I SELECT the next lowest free number and UPDATE the status to 'busy'. A job can take a random amount of time to complete...

Hello,I'm working on a project which carrying a large scale of database (over 5 millions records).I'm looking for a way to improve the communication speed with the SQL server in any way that i can find useful.The main slowing reason that i have encounter is the INSERT and UPDATE command th...

I'm using MySQL and i have to make query that carry the total amount for week 1 if the the total amount of week 2 is equal to zero. Ex.Week 1 Week 2 Week 3 Week 4 Week 51900.89 0 0 4500 0Output after the queryWeek1 Week 2 Week 3...

hi there,I'm working on a software that have to be a DBChecker I need to know by a query :<br/>1:if the Key is Identity or not <br/>2:if there's an IndexesKey<br/>3:if there's a triggers<br/>4:if there's a Procedures<br/>Any help plz

I am using SQL server 2000 database and VB6.I have a table(test_1) with 1 identity column TestId. Datatype is smallint.I have some missing Ids in the column and try to find them. I have searched web and found some sample codes. But they use 'Declare @*** int'. I can't use it in vb6. I...

hello guys,<br/>i want survey for new techniques in database in any field

I need to use the sum function, but it is not adding up my decimal places an appears to be rounding the numbers. What can I do? Also, is there a way to set everything to have 2 decimal places. Thanks for your help again.

How can I know by a query if a column is a primary key or not

Hi,Trying to execute a procedure repeatadly using job, but fails to execute.The procedure, I am trying to execute iscreate procedure p1 as begin insert into tab1 values ('ashish'); commit;end;/where tab1 table is defined as create table tab1( a varchar2(100) );and the job I created...

I have a two tables in two different MSAccess database so i want to retrive the data's from both the table by using sql query . but i do not know because the data in two database not one <br/>Can any one help on this<br/>please.<br/> <br/>hussein

hi guys,<br/>i have created a table say t1 with columns c1(int) and c2(varchar). now what if i want to make the column c1 a primary key!!!? the alter commands shows error.

hi,I'm using SQL2005,I need to know,by a query,for each table,for each column,if there's an index and what is its type<br/>Any help plz

HiI need to create a table that one of it's field is string but i need it to be more then 255 size.In access there is a type called Memo is there any way to create the field using this type? if yes can any one give me the right word like (TEXT (255))Here is what i have now:CREATE TABLE TB_2 (Re...

Hello all,I didn't know where to get this answer if in fact there is an answer so I am assuming I have found a good source of knowledge based on the amount of members and quality content, so here goes.Is it possible, in Access, to create a query that allows an end user to add multiple strings...

Since SQL Server Management Studio Express is free, can I just use this as the database for the website(business purpose)? Also, I doubt what's the difference between them and in what situation will adopt SQL 2005 ? <br/>Thank you!

I have been having problems backing up my MySQL (vBulletin) database for a while now, and my host is useless. I'm hoping someone here can help me.This is a vBulletin database (3.6), and all my tables are MyISAM according to MySQL Administrator.I have tried to create a backup using the "Lock All...

Hi,<br/>Can I connect SQL Server with SSL through ADO.Net ? if yes, how?<br/>Thanks in Advance.

I couldn't edit a table. I just see an empty raws and coloums. How to make a new record in the table?

HiI have an Access database and its contain some tables in it with values.I need to change one field that is now define as Text [250] to Memo typeThere are records with values in this tables.I need to do it via VB.Net 2003What is the SQL line and is it going to delete the records data or damage the...

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt...

Hi,I have a problem to solve: with .Net i shoud call an Oracle function that return a table type. I tested my packege directly and it's right: it returns what i want. The c# method returns instead error.Thank for all tips :)The package is like that.Package:CREATE OR REPLACE PACKAGE myPck ASTYPE...

Is there any way you can start a select statement at a certain row but include other rows after that as well? I don't mean using the limit command. What I mean is:You have 10 rows in your table and 2 attributes:id | cursor |1 | 0 |2 | 0 | 3 |...

How can I tell how many records are in a MDB file using visual c++ MFC CDaoRecordset.

Hello everybody<br/>How to read/write 'datetime' type from SQL Server to C#<br/>Thanks

Dear All,<br/>My question is kinda of stupid. I would just like to find out if there is a difference between Transaction Log and a Log File.If there's a difference what is the difference.

Hello dev-archivesI write in C# and use SQL Server. Table in databse has fieldof type 'datetime'. How I can to write (save) into this field NULL value (date does not exists) and vise versa to read NULL valueand put it to DateTime object. Is the last supports NULL date values ?Great Thanks...

Hi, I'm using access tables to store my data. to retrive data I use jet odbc engine in c++. I want to insert a large amuont of records (about 20 mega records) to my database in the fasts way i can. if i use sql syntax (insert into table ()...) it's takes for ages (about 500 records per sec...

In an Oracle stored procedure. . . Which of these would execute faster? Or does it even matter?UPDATE worklog wrklogSET flag = 'N',WHERE ((wrklog.id = 'A123456') AND (wrklog.flag = 'Y')); or. . .p_id IN VARCHAR2FLAG_N CONSTANT VARCHAR2(1) := &#...

hi guys,<br/>cd you just help me to export and import data from sqlserver2000 to msaccess.

Hi, i have a problem with a sql query in MsAccess. I have the following tables: Person, Function and a link table PersonFunction. Each Person can have more than one function, but it is enough to have only one function in the result.I want to select all persons and their functionname in a result. The...

hi,<br/>can anyone tell me the query for getting the structure of a table in sqlserver2000,pls.

Guys, I have a dbf file and i cant open it to dbase IV or dbase V and also i cant import it to Access. I need to open this file for a little period of time and use it to visual basic 6.0<br/>See attached file...<br/>Thanks a lot guys...

I want to take snapshot by using sql query. I have to take snap shot based on some criteria. e.g. consider there is a table having column salary. i want to take the snapshot of table which contain only those rows whose salary is greater than 20000.Can any body tell me how can i take snapshot in mysq...

I have 2 tables A and B, both get a field of name.I would like to know how to show all the name from both a and b.e.g.A has names : John, Ken, MayB has names : Paul, Nau, RaulI want to have the result like Name---JohnKenMayPaulNauRaulI don't want to make it as two separate field (e.g. select a....

I have a small DB which has an OLE Object field for an image of the person. I have it where when you browse to each persons file, their image shows.What I want to add is a File Dialog control that the user can use to update an image or add an image to new files. I would like to get the browse folder...

I'm using a query to calculate enrollment statistics for the college I'm working at. These are used to determine how much funding we get from the goverment. I'm trying to do this in one query so I can copy and past this into a report. If it's not possible, I'll have to wr...

Hi, I am using ODBC to connect my VC++.NET application to connect to SQL server. I can connect any server in the LAN using server name. Is it possible to connect remote server over internet using IP address? Currently I am using connection string like connStr = "Driver={SQL Server};Server=server_nam...

This may be really easy, but I'm not a database developer.(Access97 file accessed via VC++ app using CDatabase/CRecordset classes. I'm just using the SQL statement in a generic CRecordset.Open() function.)I have 2 tables:Session table with fields: ID (the key and unique)System (text and va...

Hello, I have small problem regarding making structure backup for mysql table.so far i was able to reproduce accurate backup using information found in DESC <table name>, the result just like mysql admin backup - however, i cannot get the "ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8...

Hello,SQL Server 2005, VS 2005I have a checked list box. The user will select a combination of staff members from the checked list box. This will display these staff members and their tasks that they have to do. Also I have a additional 4 check boxes on the form, where the user can select the prorit...

I was unsuccesful finding a thread on this topic to my surprise so I am sorry if I am doubling up.I am using sql server 2000 to extract data from a software package.This package contains 2 columns in the table. Postal Address and Actual Address.I want to use the postal address, but if it is null I t...

hey gurus, this is a sql server question i need to run this query through vb.netselect arp.status,arp.[nature of claim],arp.[dol],mb.[Amount (Excl)] from [table 1] arp join [table 2] mb on arp.arn = mb.[our ref] where arp.[nature of claim] = 'accident' and arp.region = '%central%'...

I'm currently converting an app that uses an Access db to use SQL Server Express 2005 instead. The app used DAO connections to connect to the Access db, I'm using ADO 2.5 to connect to SQL Server.Access gives a bunch of neat properties for each column in a datase, but SQL Server Express 20...

Hi,Currently I need to change a column format for a table from decimal(18,0) to decimal(18,2) .But the the table is in replication for 3 branches which run at midnight.This means that I have 4 table need to alter eventually.Can anyone give me suggestion and idea on doing this?Does I need to write a...

hi,<br/>I want to get the data stored on server (IBM AS/400) machine. I have windows platform and i am using VC++ also i have iSeries Access ODBC driver. Still i am not able to get the data stored in raw/text form on IBM AS/400 machine.<br/>Would some body pleaseee help me, its very urgent.

Hi there,I was wondering if anyone could tell me how, in MS Access, you can save a report into a file containing the data contained in a list box on a form.In order to send the same information to the printer you use the DoCmd.OpenReport command, but all I want to know is how to change the destinati...

i want to add new fields to a existing table in other databaseusing fields from a table in the current databaseand copy all properties of the fileds like (display control, row source, limit to list, ...)this is my code : Dim db As Database, db2 As Database, tb As TableDef, tb2 As TableDef, t As Int...