I have Windows 2003 Server configured to be VPN server. I succeed connecting from Windows 2000 as client, but I get 721 error when trying to connect from Windows XP.
Please help, thank you
Your query is slower than previous.
I already find a better solution:
delete from sterg_daniel
where exists (select s1.id from sterg_daniel s1
where s1.tip1=sterg_daniel.tip1 and s1.tip2=sterg_daniel.tip2 and s1.id<sterg_daniel.id
)
id tip1 tip2 valoare
15 1 1 23,5
17 1 1 24,5
18 1 1 25
13 2 1 26
14 1 2 27
I have to delete from this table, all the rows that have the same value on (tip1 and tip2), leaving one row. All this with only one delete.
In the example, after the delete query, rows with 17, 18 will...
The SQL Server user is always the same, I made a user php for php connection, so I have to get down to connection ID. I have my own management of users from php, when someone logs into the system I want to store the connection ID and use the same connection, so I can record every change.
The...
How can I find, with Transact SQL, or something else, the connection id, if this exists, or something unique of the connection.
I want to connect from PHP using mssql_pconnect, and to record with triggers, each modiffication that connection has made to the table.
The xml contains
<entity en="apple" de="apfel">
I want to generate a html, by XSL.
The page URI is:
http://entities.xml?lang=de
I want the html tu contain apfel, this is the target.
I already solved the problem using ActiveXObject. I want it to solve this generating-time...
How do I obtain a request uri parameter in XSL?
In my XML I want to have different attributes for a few languages.
Example: <entity en="apple" de="apfel">
The example uri is: http://entities.xml?lang=de
I want the xsl to display apfel
I need a program to recover the dial-up password, under Windows 2000. The "save password" is checked, and I can connect, but I want to reinstall the os and I will lose the password.
if I want all the attributes of one table stored as generic attributes in other table.
Exp:
[clients]
id int
type tinyint
index_type tinyint
index numeric(19, 4)
I want a generic approach for attributes storing.
if type=
0 people I need only one index column...
JamesLean, for answer 2)
if I also have a table
[service_attributes]
cod_service int
type_attribute tinyint
cod_attribute int
and type_attribute: 0 for numeric, 1 for nvarchar
How do I join the tables in one query?
I need a table in wich to store attributes of different types
The table should look like this
[attributes]
cod int
value numeric(19,4) or nvarchar(30)
How to solve the attributes problem?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.