|
thanx a lot Steven. osql.exe was just the utility i needed! works great for me!
One thing that comes into my mind now is that, if sql server 2000 provides such a utility, does this mean that there might be a tool or program for the versioning of all the Stored Procedures, or any objects in the database? if you could refer such a tool/program, it would be Heaven on Earth for me!
thanx a lot!
☺«««DTA»»»☺
|
|
|
|
|
Sorry to disappoint, but there is no built in versioning support in SQL Server, at any level. The best you can do is manually include comments at the start of your stored procedures, to indicate change history.
There are some 3rd party tools that do database comparisons, and will be able to tell you when database structures are different. I cannot recommend anything specific though.
my blog
|
|
|
|
|
no disappoint at all!! not after "oslq.exe".
i think i will go for the manual approach, because third party tools usually involve some sort of licensing problems, and versioning in my case has the lowest priority. so i dont think that i'll be spending any money for this purpose!
thanx anyways!
☺«««DTA»»»☺
|
|
|
|
|
Anybody know about a good document to learn and set up replication?
Cheers
Al
|
|
|
|
|
No, as far as I can figure, there are no good ones. I think the reason is that there are so many "ifs and buts", i.e. technique x works, but only if you structure your inserts this way, but if you have a BLOB column then you have to do it another way unless the planets are out of alignment, and then you have to apply the "jupiter" hotfix. Its just too complex to write about in any meaningful way.
Unless you are willing to put many many hours into the learning effort, my best advice is to hire a consultant. As a bonus, you'll have someone to blame when things go wrong.
my blog
|
|
|
|
|
Hi,
As far as SQL Server replication goes, the best bet is http://msdn.microsoft.com/librarydefaul.asp?url=/library/en-us/replsql/replover_694n.asp
You could also learn to implement replication on the internet through the front end e.g using SQL Merge Replication Object for Merge Replication. The URL for the same is at MSDN , a few links below the link given above
|
|
|
|
|
What to do if I like to store an XML-file of size up to 10MB in SQL 2000 Server? What is the “best” solution of that problem. What type of column should I use and can I use the regular “INSERT INTO” SQL statement…
_____________________________
...and justice for all
APe
|
|
|
|
|
Best solution do not inster that into SQL 2000, Save it into the hard disk and just store the path in SQL.
Cheers
Al
|
|
|
|
|
Don't store files in the database if not absolutely required. It will put a large load on the database server and the network. If it is a web app, it can also tie up valuable threads for extended periods and cause delays for users.
If you must do it, store the file in text, ntext, or image field types. To store the file use a TEXTPTR and the UPDATETEXT commands. If you google on these, you will find some examples.
|
|
|
|
|
of course ! i added a textbox in my application and user can input some text in english like : The message you are replying to , then i split the textbox values into the array and search each word and fill in datagrid but the datagrid show me database where it store . for example like this
1. are
2. the
3. to
4. message
5. replying
6. you
|
|
|
|
|
Hello!
I would like some help with the following:
I want to get one (1) result out of two columns. I have for example "user1" and "user2". I would like to have "user1" as the result if "user2" contains the word "flintstone" and I would like to have "user2" as the result if "user1" contains the word "flintstone". I would like either of these to merge into a common name such as "user" or something, that I can use further with ASP.NET DataRepeater. Hope you understand, I have a sketch as well:
SELECT user1 FROM table WHERE user2='flintstone' --\
>-- user
SELECT user2 FROM table WHERE user1='flintstone' --/
Thank you!
|
|
|
|
|
Hi,
I am not clear with ur Query but just try this............
SELECT user1 User FROM table WHERE user2='flintstone'
UNION
SELECT user2 FROM table WHERE user1='flintstone'
I hope this will help u.............:->
Regards,
Ritesh
|
|
|
|
|
:-Dhai,
iam connecting the ado.net through a wizard or server explorer or manually using adapter. it is connecting in the dataset but iam getting error as given below:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
can anyone help me to solve this problem
Even i need a manual source code connectivity of ado.net
Success in Career
|
|
|
|
|
Hi,
Try this code.........
<code> Private Sub PullData()
'DECLARE VARIABLES
Dim ds As New DataSet("DataSetName")
Dim dr As DataRow
Dim myConnection As New SqlClient.SqlConnection("Data Source={Local};database=Northwind;user id=sa;")
Dim myAdapter As New SqlClient.SqlDataAdapter()
Dim myCommand As New SqlClient.SqlCommand(("SELECT LastName, FirstName, Title, BirthDate FROM Employees"), myConnection)
Try
myCommand.CommandType = CommandType.Text
myAdapter.SelectCommand = myCommand
myAdapter.SelectCommand.Connection = myConnection
myAdapter.Fill(ds,"Employee")
Catch ex As Exception
lblMessage.Text = ex.Message
End Try
'Close connection
myConnection.Close()
dataGrid.DataSource = ds.Tables("Employee")
End Sub</code>
I hope this will help u.............:->
Regards,
Ritesh
|
|
|
|
|
Hi for my application I need to connect to a remote SqlServer, I just wanted to know that in the following connection object
string conn =
"Data Source=xxx.xxx.xxx.xxx,1433;" +
"Network Library=DBMSSOCN;" +
"Initial Catalog=ABC;" +
"User ID=ABCUser;" +
"Password=xxxxxxxxxxxx";
can I replace IP Address xxx.xxx.xxx.xxx to URL Name such as www.anysite.com
is it allowed, and if allowed how does conversion from URL to IP address is done.
RuchirDhar Dwivedi
Software Engineer
Windowmaker Software Pvt.Ltd.
Baroda, India.
|
|
|
|
|
Hallo,
I just posted this message in C#-section, but I saw the ADO.NET section and I think its better to post it here... sorry for doubleposting...
I'm a real beginner with C# and I have a silly problem with one DataTable combined with a DataGrid.
Short describing of surround:
I have one DataSet with three DataTables, each shown in DataGrids.
The DataSet is persistent (typed DataSet) as .xsd-file.
DataBase ist MSDE. All three DataTables are filled with the
DataAdapter.(DataSet, DataTable).Fill-Method.
If I execute the fill-Methode for one table twice or more, in my datagrid the records are added. To avoid this behaviour, I want to use the
DataSet.Tables["table"].Clear()-Method
before executing the Fill-Method. With two DataTables it works, but with the third, the DataGrid stays empty after the Fill-Method.
- in the debugger I can see that there are records in the DataTable
- when I click into the DataGrid, an error occurs that I try to translate (German version):
"DataBinding could not find line in list that can be used vor all bindings."
Help would be very appreciated.
Thanks
Vexta
|
|
|
|
|
If i have 2 table, table1 and table2, and joining them in a view, should I first select all fields from table1 and then fields from table2, or I can select in random order from both tables? Is there any performance issue, if selecting in random order? Thanks.
<italic>Work hard, Work effectively and a bit of luck is the key to success.
|
|
|
|
|
|
Hi, I have exported as a script my db from one server and i want to run the script in the other server in order to create the db that i had in my first server Can somebody tell me how to do that?
La Light
|
|
|
|
|
Inside SQL Enterprise select the database.
/All Tasks/Generate SQL Script
Press Show All and you in businees.
Hope this helps
Al
|
|
|
|
|
Hi All,
I need to assign ranks to the people according to their scores (within each exam).
Id ExamCode Total
1 C1 100
1 C2 98
2 C1 100
2 C2 97
3 C1 89
3 C2 99
how can i accomplish this..
Can anyone help me
Thanks in advance,
|
|
|
|
|
Here's a code from MSDN, might help you. Case[^]
USE pubs<br />
GO<br />
SELECT 'Price Category' = <br />
CASE <br />
WHEN price IS NULL THEN 'Not yet priced'<br />
WHEN price < 10 THEN 'Very Reasonable Title'<br />
WHEN price >= 10 and price < 20 THEN 'Coffee Table Title'<br />
ELSE 'Expensive book!'<br />
END,<br />
CAST(title AS varchar(20)) AS 'Shortened Title'<br />
FROM titles<br />
ORDER BY price<br />
GO
<italic>Work hard, Work effectively and a bit of luck is the key to success.
|
|
|
|
|
strsql = " select * from dic where english='" & SearchBox.Text Or TextBox4.Text & "'"
The machine said Input string was not in a correct format.
How can i select database with or operator in asp.net .
Is it possible to select database in sql from more textbox ?
ere ewrewrwe werewrewr
|
|
|
|
|
bibipopopopo wrote:
strsql = " select * from dic where english='" & SearchBox.Text Or TextBox4.Text & "'"
It is certainly possible to build a dynamic SQL query like the one you are referring, but I think you have just got your string formation messed up.
Assuming that SearchBox and TextBox4 are VB textboxes containing some textual criteria, then try:
<br />
strsql = "SELECT * FROM dic WHERE english='" & SearchBox.Text & "' OR '" & TextBox4.Text & "'"<br />
Notice the ' in the string separators.
This would form a valid statement e.g.
SELECT * FROM dic WHERE english='AMERICAN' OR 'CANADIAN'
I Dream of Absolute Zero
|
|
|
|
|