I'm creating a stored procedure that pulls some data into a temporary table, which I'll call #temptran02, and further into the stored procedure I'm doing a SELECT which has a WHERE that refere...
I have a stock control system that outputs a basic CSV file with our stock level data. We have a website that is totally separate from this system, but which holds the same stock information -...
I want to modify a column that is a smallint to become a DEC(4,1).
The column already has data in it.
What will happen to that data during modification.
Will it
i) Be converted to a...
Could someone please post the TSL for a simple trigger? For example, one which updates an index when a new record is added to the Customer table. The index could on customer last name, for e...
I have a log table that takes on the following form:
TAX_ID AMT_OWED AMT_PAID MAINT_DATETIME
123-45-6789 $150 $150 7/4/2008
123-45-6789 $100 $200 8/4/2008
123-45-6789 $150 $150 9/...
SELECT logs.*, loc.city + ', ' + loc.state as locationName, e.firstname +', '+ e.lastname as Name
FROM iplogs_delivery, iplogs logs
LEFT OUTER JOIN employeeData e ON logs.i...
Hi,
I am trying to work out the calculation part for the results to be entered into the database and to update the league table.
I have supplied the snippet code for the trigger I have g...
How do you set the default path for the data and log files of a new database?
Thanks
Hello, I am installing in a virtual machine sqlserver 2005 on Windows XP, IT ALREADY INSTALLS WINDOWS INSTALER 3,1 and it leaves east error to me that I attach to you
Below is my syntax, and the columns are index. Is there something I am overlooking. Dealing with millions of records.
left join about 2+ million rows
right join about 480 thousand rows;
...
I'm getting this error msg when try to open the *.dtsx in BIDS or even try to run it from cmd
Error 1 Error loading BatuPadu.dtsx: Failed to decrypt protected XML node "DTS:Password" with e...
I have an existing user for database A named Joe.
What would be the SQL to make Joe the db_datareader and db_datawriter on database A?
Thanks!
I have an ASP application that runs under a particular user identity web_user. In the SQL server database there is new role created web_role, to this role the web_user is a member.
I need t...
Endeavoring to apply Tim Chapman's post on shredding XML via XQUERY in SQL SERVER (http://articles.techrepublic.com.com/5100-10878_11-6140404.html#) to my dataset.
I'm using the IODEF schem...
i have created a database in sql server 2005 with 2 tables.
where do i set the user name and login because i want to connect to it with vb.net?
currently i have no user name or password...
Hi,
We are receiving an insufficient memory error while consuming workload using the sql DTA Engine. The sytem however shows 2gb memory free and it's a 8gb proc box, fast disks etc. I assum...
Creative SQL minds are needed for this one. I have a page that has 3 controls on it. The user can enter data into 1,2 or all 3 of the controls. I have the query written to return desired resul...
I'm having a hard time importing data from an Oracle view into SQL Server 2005. There are only 1 million records and it is taking over 30 to 40 hours for the import. I'm using SSIS and I've ...
Hello,
I'm currently doing an audit of database security and I would like to get a report with who has access to the db on a given machine and what type of access he has. We are also using A...
hi there ,
i have a grid that the user inserts emp work date and Start hour and Ehour For the date that is typed
i need to check every time that the user is going to insert new row if the w...
Please tell me is there any thing logical error in this code.Because whenever I'am trying put new record in textbox.Value of val it is showing 0 only.
dsUserLogin.Tables(DSLogin.TestLoginTa...
Hi Experts,
I have excel files which are uploaded by users and I read those excel files and put them into database tables. Now I have some excel files which has special characters in the c...
A new standalone server needs installing. It requires windows server 2003r2 32 bit, windows SQL server 2005 and IIS 6.0.
The application is a standalone web application using a database backe...
I am trying to make a trigger where in every time a row is inserted into my table called PackageJob
the PackageID and JobID Values come from the insert
the PartsPricingID and PartID come f...
I'm trying to setup database mirroring between "db1" and our server "db1_mirror". It works fine most of the time, but not always.
On our server "db1" we run the following:
ALTER DATABAS...
