|
Hi there!
Can you help me how to define global variables in MS SQL 2000 or 2005 (@@...) and create a function that auto-start when MS SQL server start. I've searched a lot in google but i still can't found the answer 
Thanks in advance
|
|
|
|
|
I cant say any thing about 2005 but there is no global variable in 2000. Use a status table instead.
Farhan Noor Qureshi
if (this == this) thow this;
|
|
|
|
|
Hi! Thanks to reply 
The global variables that i want to define are something like @@CONNECTIONS, @@FETCH_STATUS (and anything that begins with @@).
Can you help me, please
|
|
|
|
|
Like I said, I am not aware of any user defined global variables in SQL 2k. But I suggest a solution. Say, you have a table with two columns, VarName, VarValue that acts as a list of name-value pair. You could write User defined functions that read-write data for each name-value. Here is an example.
<br />
VarName VarName<br />
-------------------<br />
City London<br />
Country UK<br />
Then you could write UDFs like GetCity(), SetCity(), GetCountry(), SetCountry() etc
Farhan Noor Qureshi
if (this == this) thow this;
-- modified at 13:46 Tuesday 29th November, 2005
|
|
|
|
|
Hi!!
I have a winery name coming from the table, and I concatenated this text string with xxx to see the amount of spaces after the winery name. I did it like this:
SELECT RTRIM(Wnr_Name) + ' xxx' FROM tblWineries;
There are some wineries with spaces after it, and some not. I went to into Enterprise Manager and none of the wines had spaces. How do I remove these sapces? I've tried RTRIM and LTRIM, but none work. Some of the results:
Amani Vineyards xxx
Backsberg Cellars xxx
Beaumont Wines xxx
Can you see that some has extra spaces.
Regards
|
|
|
|
|
ma se wrote: SELECT RTRIM(Wnr_Name) + ' xxx' FROM tblWineries;
There is a space between the first apostrophe and the xxx...That could be why it is not working?
Paul
|
|
|
|
|
There is a reason for a space between the first apostrophe and the xxx. It is there to separate the two strings. If I were to take away the space, then those with the extra space will only have one space, and the rest will look like:
ABC Wineryxxx
So I I put the space in so that it can look like:
ABC Winery xxx
And some wineries have an extra space, which makes the outcome look like:
ABC Winery xxx
|
|
|
|
|
Hmmm, I see why you put a space before the xxx. Are you sure that the "spaces" are not really ASCII character 255 (which is a blank) by some weird reason? You may want to look at the ascii value of the returned wineries to see if this may be the case.
|
|
|
|
|
hello
have a small problem and want help
i have a domain and a webservice application and i want to connect them toghether and i dont found the good statmet to connect them plz help
thanx
tedy
|
|
|
|
|
hello
have a small problem and want help
i have a domain and a webservice application and i want to connect them toghether and i found the good statmet to connect them plz help
thanx
tedy
|
|
|
|
|
7mam wrote: i want to connect them toghether and i found the good statmet to connect them
Your question doesn’t make a whole lot of sense.
Why cant you run your web service on your domain?
ZeePain! wrote: This seems like one of those programs that started small, grew incrementally, building internal pressure, and finally barfed all over its source code sneakers. Or something.
thedailywtf.com[^]
|
|
|
|
|
|
SQL Server 2000 Enterprise does not work on Windows XP* because it is a server product designed for use in large companies. It is designed to run on a Server therefore the installer will not permit you to install it on a non-server product.
*I modified this so the sentence would make sense as the OP decided to delete the original message and the context was lost as a result
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
-- modified at 10:04 Saturday 26th November, 2005
|
|
|
|
|
Given your previous question[^] I am now curious as to where you got Enterprise Edition from. If, only a few hours ago, you were desperate for a free version of SQL Server 2000 did you suddenly win the lottery in order to afford the several thousands of pounds/dollars that Enterprise Edition costs?
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
nice ))).I have it from one years but the problem is because the comuter of witch i shoot install it has windows xp no some of server version so i can't use it.
-- modified at 7:57 Saturday 26th November, 2005
|
|
|
|
|
hi
clous you give me please url of link for downloading of ms sql server 2000 who is free i don't know the exacly additional name of that product.
thank you
|
|
|
|
|
|
But i need sql 2000 not 2005????
|
|
|
|
|
if i download this free version i will can to add my back up from sql2000
???
|
|
|
|
|
You can try it. I'm guessing that it will probably work, but will be a one way operation, i.e. you won't be able to backup the new database and install it on SQL Server 2000
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
thank you but probabry is not enought???
|
|
|
|
|
I think this just represents a different way of working. If I didn't find the documentation that said one way or the other what the situation was then I'd create a little prototype to see what would happen. In otherwords, I'd have downloaded SQL Server 2005 express and attempted to restore a SQL Server 2000 database to it to see if it would work or not.
I guess I take a more proactive approach to getting things done.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
papa1980 wrote: But i need sql 2000 not 2005????
Search for MSDE. The desktop-edition from SQL-Server 2000 is free, but has some restrictions.
'A programmer ist just a tool which converts caffeine into code'
|
|
|
|
|
Hello I want to insert record in access database using ado.net data adapter , not by command object. by suppling query at run time means Writing Query In a text Box .
Please suggest me.
Manoj
-- modified at 1:45 Saturday 26th November, 2005
|
|
|
|
|
tusar123 wrote: I want to insert record in access database using ado.net data adapter , not by command object.
You do know that the DataAdapter will have a property called InsertCommand that it uses to perform this query. This forms a paradox as it is exactly what you are trying to avoid.
tusar123 wrote: suppling query at run time means Writing Query In a text Box
So, you have a text box on your form. The user will be able to type a query into the text box directly say:
INSERT MyTable(KeyColumn, DataColumn1, DataColumn2) VALUES(1, 'abc', 'def') And then you want a data adapter to run this command?
Why? It would be much more efficient to use a OleDbCommand object instead. You are gaining exactly nothing from the overhead of the DataAdaptor in this instance.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
