What's the best way, pretty simple requirement really...
I have a list of postcode like so:
BR
CR
DA1
DA2
DA5
DA6
DA7
DA8
DA14
A matched postcode is "BR1", "BR", "DA1", "D...
I am getting following error from VB application.
Error #-2147217871
(Source: )
(SQL STATE: HYT00)
(NATIVE ERROR : 0)
It works fine for some time again shows error under that quer...
I need to pass in a list of things to be used in an in clause into a procedure. Since you can't pass things in as an array, i'm thinking of using a comma delimited string as a parameter, and ...
May I know is there any method to rename a table and add columns into that particular table by using one sql statement?
Hello,
I have a probleme with SQL query...
I have for example this query result :
1 2 A A22
1 2 A A23
But i need to have this result :
1 2 A A22, A23
H...
Hi,
I have setup two identical cubes (both with different Data sources) using the Analysis Manager.
Is there a way that I can integrate these two cubes to display the results in one cube...
Hi there,
I have a tab delimited data file supplied to me that has some of the columns with data surrounded by quotes e.g. "United Kingdom". The quotes are obviously there as a text quailif...
I used the ParmsToList function outlined here:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21644852.html
My database has only one user, dbo, who owns everything...
Does anyone know why this query:
UPDATE problem
SET email = 'NBAkey@taylorcorp.com;Maintenance2@taylorcorp.com;adamrackis@hotmail.com;'
WHERE problem = 'Maintenance'
raises this except...
Hi,
Please kindly assist how can we create the sql query to generate the output.
basically we have to group by hourly and display the static value in Time column.
Thanks.
t...
I am having some troubel understanding the difference between logons and users in 2005 and how they are used. I know only logins from SQL 2000. Furthermore, while in Integration Services I'm...
Hi,
I am extracting data from a SQL Server 2000 table using a DTS package to a flatfile (Transform Data Task). The extract is very simple with no transformations. The field that I am extracti...
SS2000
When using OPENROWSET to query another SQL Server, is there a way the user can be authenticated using something similar to SSPI (as in .NET connection strings)? Since we use Windows...
Hi
I am using SQL Server 2005 and have a table very much like this one:
Table A
---------
Keyfield Value
--------------------------
1 This
1 ...
ntext
Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters.
but in the Access linked table, it's only allowing 255 characters.
How do I create a ver...
Hi experts,
I have MS SQL database files: Contacts.mdb and Contacts.mdf
How do I open or read them ??? thanks.
I am trying to drop the BUILTIN\Administrators login.
I can do this from a db utility which I downloaded but I am struggling to find the right code to do this in my own app at runtime.
I h...
The simplest things are always the hardest, right?
Why can't I create two foreign keys from one table to the same primary of another?
Memberships.id(P)----(F)Map_Membership_Network.fk_pm...
What function can I use in MS SQL to replace my SQL call as follows:
SELECT INET_ATON('68.149.52.148');
which converts an IP address to an integer, and vice versa:
SELECT INET_ATON('7...
Sql Server 2000
Is there a way to tell when a SP was last executed ? How about when a view was accessed ?
Thanks,
JK
I have a string the database I am using which contains dates in the format 12/01/2006 06:40, i.e. dd/mm/yyyy hh:mm
I want to convert this to a date type, showing the date only in the format...
Current in the database there are a number of different queries to make up one query. Can someone please tell me how I can join all the select statements to get just one procedure instead of ...
I installed Sql Server SP4, and I get this message whenever I try to save changes for a view on the
sql server.
Error Message:
An invalid parameter or option was specified for procedure
...
Hello, I have a MySQL database that is connected to a web page. I user's enter information into a textarea control. The information goes right into my sql table field. How can i set my (dat...
I notice that there are two files for an sql database - one is MDF and one is LDF. What are these two files? and if I want to move the data to another pc with its own SQL Server do I need to m...
