- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 3
- Posts with Downvotes
- 1
- Downvoting Members
- 3
Re:
Hello, I want to change the datatype of a field from Varchar to integer in T-SQL. I tried something like Modify like you use in Oracle. ALTER TABLE tablename MODIFY COLUMNNAME Datatype. But its not working in SQL server.. Any thoughts. |
|
Re:
hi anyone who can help me with this project? <EMAIL SNIPPED> Please see the attachment |
|
Guys i am looking forward to do a project for my final year and i have chosen SUPPLY CHAIN SYSTEM as detailed below i am now looking forward for ideas and suggestions. here is what i am thinking to do. i what to have a web based inventory system that … |
|
I have created a Database with some related tables say Customer and order and they are joined with the CustID i have created the main form and the subform and linked them together. My problem is if i say put in the key where they are joined for the 1st … |
|
Morning I have a question here How do I go about it in Access say if I want to split a line (row) into different lines like these fields? Drug name1 Drug name2 Drug name3 Drug name4 Drug name5 Drug name6 So what I want is to split the Drug … |
|
Re:
Im in over my head and have a small project to complete using MS Access. It involves setting up 3 tables, creating forms, queries and a report. I have a narrative that describes what is needed. I am willing to pay to get this done, but for somebody that is … |
|
I am trying to write a bulk import routine so that i will be able to import text files or csv files to SQL i have tried this and it's giving me the following error message. P: is the drive where the file is in currently. [CODE] USE [XYZABQ] GO … |
|
I have some tables that i have created in SQL Server and i want to write a stored Procedure that will insert data on to one of my tables AND also be able to update say if i select record [CODE] CREATE PROCEDURE Sp_cust_SaveCustomer --ALTER PROCEDURE cust_SaveCustomer (@id int, @ … |
|
I need some help I have managed to get this far (as below), from thatI can put a AAA_NUMBER and be able to get that record details and thats the 1st step that I wanted the 2nd step that I want is say if the DOCID is not available I … |
|
I have made created a databse MSSQL and want to upload it to my web space how do i go about it. |
|
Can anyone help me in this matter i am looking for a code to connect my MS SQL so i need the APPROPRIATE SQL SERVER DATABASE CONNECTOR . i have a download which only works with MySQL ,and i do need help with the MS SQL one Thank you in … |
|
<html> <head> <title></title> </head> <body> <% Function NewConn() Set NewConn= Server.CreateObject("ADODB.Connection") NewConn.ConnectionTimeout=100 NewConn.Open "Provider=sqloledb;Data Source=[192.168.160.1];uid=[sa ];pwd=[topland]" NewConn.CommandTimeout=1200 End Function %> </body> </html> I am trying this functions.inc code then use the include ext and i keep on getting this error message Error Type: Active Server Pages, ASP 0126 (0x80004005) The … |
|
Guys I am starting my final year project in Sept this year and I have been looking around for a project to do so there is this one that I am most likely going to chose [choosing from a list] To be honest I am not a big fan of … |
|
Re:
Hi everybody Can some one help me out?? My problem is I am using two forms in my asp page form1 is used to upload photo, so I used enctype for it and action form1update.asp and a submit button attached when clicking on the submit button it should upload file … |
|
I do need some help I am building up an asp application that will access an SQL server [database] so what I want is for the admin access to add, update and delete in all the tables I have about 13 different tables so my questions is do I have … |
|
Please help !!! I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I … |