Hi,
I am going to change the order of a tables columns in database 'A' and re-apply the contraints so it is the same as database 'B'.
i get the current order from 'A' with
desc table_...
Hello,
I am trying to implement the following Trigger into a table in SQL Server 2005
http://jamesewelch.wordpress.com/2007/09/04/tracking-database-record-changes-at-the-field-level/
I...
I've got two queries that I want to combine into one:
SELECT LogDay, Visits FROM vwNumVisitsByDay WHERE LogYear = 2007 AND LogMonth = 2 ORDER BY LogDay
SELECT LogDay, Pages FROM vwNumPages...
I have a query with an "is not null" criteria but some of the results have null values for that field.
I have exported the results as a text file and evaluated the results and those fields ...
Hi,
I have a table T1 with fields A,B,C,D,E,F
A is a bigint PK created by an identity starting at 1
Some records have identical vaules in C,D,E
In these situations i wish to remove all b...
New to this web site. This is pretty sweet. Anyways, I searched solutions without success, thus you are reading my question. Hopefully simple. Is there a way to define a field as autonumbe...
I need to run a query that joins two tables from two different databases.
Hello Experts, could someone please tell me how to find a trigger definition in sql server 2000. I am aware of how to find the trigger by running a select statement against sysobjects, but I ...
Can anyone help me in writing a SQL query which takes values from the list box and inserts into a database table.The only complication in this is
The number of items in the listbox may not ...
Per the question, how would I do this in regards to the script below? Thanks in advance.
I have a mySql database and would like to know how to use a select statement to define a variable and then use that variable in a follow-on statement. I am trying to do this in the stored pro...
hI,
I have the following line of code in a VB6 project
SQLStmt = " INSERT INTO Recipes_West_Table " & _
"Values( " & Form1.Text1.Text & " , " Form1.txtVal1.Text & "," & Label2.Caption...
I'm trying to filter a DataGridView using a filter based on the text entered into a Text Box. The SQL Server Query looks like
SELECT *
FROM <TableName>
WHERE (<Tabl...
Dear experts,
I am using the following statement to update the table QIASA.TARGETS_TBL:
UPDATE QIASA.TARGETS_TBL
SET TARGETS_VALUE = '0.01'
WHERE TARGETSDATE = '20071231'
AND KPI = 'A...
I have the following query that connects dattbl_Case with dattbl_Policy
dattbl_Policy sometimes has more then one row. When this occurs I need my query to merge both of the POL_NUM column r...
Hello,
MS Access
I have built a query part of which formats the date to its corresponding week number. The week number is a string and I need to convert it to an integer value in order t...
Hi,
I have a script which is intented to load an image from an Images table in a database. In the table there is a datetime column 'LastImpression' which holds the date and time of the last...
This issue seems to litter the net but I can't find an answer to my simple situation:
Using DAO in Access (ADO not referenced)
APscan is a simple table with an integer field Attempt
...
I have an MS Access tabe in which all of the data types are text (this is necessary and cannot be changed). My issue is that I believe, because of the fact that all table data is text, I need...
I have a Stored Procedure I'm trying to use to add records from an ASP.Net 2.0/VB webform into a SQL Server 2000 database.
This seems to be working (no errors so far):
cmdTest.Para...
I would like to use the DatePart function to indicate which quarter a date resides within a given fiscal year. As a default, the function does this calculation on a calendar year. Assuming ...
I am executing a script that loops into my table, and I get this after around 10 minutes of waiting!
--------------------------------------------------------------
Server: Msg 9002, Level ...
I have the following fields in an Access Database called "Logs":
RecordID, Zip, DonorIDDate
I have this query to count, group, and display Unique records (Between 2 dates):
"SELECT Logs...
Hi,
I am using MSSQL 2000
In MS SQL I have to substring the middle integer from the string
For Example
If String is AS-00200-1
I want result as 200
If String is AS-00200-1
...
I am using the following query to create a temp table based off a query. However, I keep getitng an error message that I can't seem to resolve. Can anyone advise?
Here is the query:
CR...
