Estuardo

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.

Hi, this is my first post. I have a website [URL=http://www.psychopanic.com]www.psychopanic.com[/URL] and theres an IP address that I want banned from accessing my site (203.213.0.10). Does anyone here know how to make a MsSQL script that can ban ip addresses? my webhosting Plesk control panel only lets me use MsSQL. …

[TEX] hi every one i have problem in database if i want to create 7 tables by DAO liberary the name of the tables are : vn,itm,ctm,vst,sal,vnd & tin i have created tables as : Set db = CreateDatabase("WORKS.MDB", dbLangGeneral) db.Execute "CREATE TABLE vn(vn_nm text (30),vn_add text (100),vn_bo text (30),vn_tel …

Hi Friends, I have the following query, i am using the column alias by this way, select work_Code as "Work Code",work_nature as "Work Nature" from sb_cm_work_nature it works fine and i get this output. Work Code Work Nature 1 External 2 DE-Sales 3 DE-Miscellaneous 4 DE-Equipments &Transport But my requirement …

i have a very simple access DB and im tryin to update the records but the update never works. im using asp.net/vb.net and i've include the execute in a try/catch block and it always prints the sql string (the catch). here is my code, perhaps i have an error that …

I have heard about Access Data Project .Can anybody tell me what is it and when it is used?

Hi All, I am new to working with Access and would like help to stop a security pop up on users when starting Access. It does not happen on all my users but as I plane to rollout Access via citrix I feel this pop up could cause problems. I …

I have a table containing the fields: DeliveriesID // SupplierID // Date // ProductID // QTY // costprice // totalprice I need to make this table 1NF. I know I should make related tables but I'm not sure what fields go with which.

Current app runs a stored procedure which runs 16 nested procedures and takes from 3 to 10 min depending on how must data needs download from the as400. The problem is that there are some other web apps on the web serverr that use old com objects that have memory …

Hello there, we are converting our applications from a sybase server over to MS SQL Server 2000 and have run across a query that is acceptable in sybase but not ms sql. It is giving us a table name correlation error that we can't figuire out. In sybase the sql …

Hello, I have two questions, first some background info: We are running SQL 2000 on a Windows 2003 server for out aircraft parts database software. There are 7 workstations (windows 2000 and XP) that run the parts database. 4 of those workstations run really fast, the database calls are near …

HI 1. I have a typical problem.We have a 2003 server which is a user authentication server.I have a sql server 7.0 on NT platform.I am logging in to the 2003 server from my XP workstation. 2. I am authenticated to 2003 server & simultaniously to NT server which has …