Read Only Table
I create a table in sql server 2k5, the script is look like this:CREATE TABLE [dbo].[tb1PmtD]( [PmtDLU] [int] NOT NULL, [PmtDInvLU] [int] NOT NULL, [PmtDAmount] [money] NOT NULL) ON [PRIMARY]GOALTER TABLE [dbo].[tb1PmtD] WITH NOCHECK ADD CONSTRAINT [tb1Pmttb1PmtD] FOREIGN KEY([PmtDLU])REFERENCES...
View Answer
| Sep 9 2008 9:08 PM GMT
| asked by
Ipong
SQL Server 2005, Microsoft Access, File permissions
SQL Script
I am trying to write a sql script that will ask for a date range each time it's run. How do I do this?
View Answer
| Aug 27 2008 2:16 PM GMT
| asked by
Ebethea
Date calculation, SQL scripts
Migrating shell scripts
We have to move more than 250 shell scripts from a unix to a linux environment, and also 100 sql scripts.Could you please give me some steps or a check list to follow to migrate these from unix to linux?
View Answer
| Jul 29 2008 4:35 PM GMT
| asked by
Chunter
Unix, Migration, Scripts
How do i replace a sql tables field value with another value
I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table...
View Answer
| Jul 28 2008 7:18 PM GMT
| asked by
Ilfoprog
SQL, SQL scripts, SQL tables
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it
Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it?Hey i have Zip file which i want to extract using the sql script or using DTS Packages.and also want to run the Batch file from DTS Packge.its possible or not ? and yes then how ?
View Answer
| Jul 17 2008 8:27 AM GMT
| asked by
2174816
DTS packages, DOS Batch, Batch files
Restrict a script to reduce SQL injection attacks
I want to reduce SQL injection attacks. How can I restrict a script to execute one query at a time?
View Answer
| Jul 10 2008 5:58 PM GMT
| asked by
SQL Server Ask the Experts
Scripts, SQL injection, SQL scripts
Insert records between records in a file using RPG code.
Is there a way to insert a record in between records in a file? For example, a file contains 10 records (1 to 10). I want to insert a record in between records 1 and 2, thus record 2 will move to position 3, 3 to 4, and so on and so forth. Can SQL/Insert function be used to do this?
View Answer
| Jun 8 2008 5:00 PM GMT
| asked by
Francissamonte
RPG ILE, RPG, SQL scripts
sql scripts
Hi all,i'm updating a new 'commun management' software n i wanna update the database bcoz i added many extra tables.i did write scripts for all the tables this way:Create...........Drop...........Alter........so our clients would be able to have access to it.but i have been asked to write other...
View Answer
| Jun 5 2008 9:12 AM GMT
| asked by
JARON
Scripts, SQL, SQL scripts
