|
My prefix sp is not to indicate that it's a stored procedure, but one of my system procedures. See my post above.[^] The third one down.
|
|
|
|
|
hi,
i'm using VS 2005 And SqlServer Express 2005,
i've build a nice app that conects to an sql server and reads info displays
changes the data and so on
the problem that i'm facing is how to tell App2 and App3 that App1 has made
cahanges in the database, i've tried a Thread that pulls Data and Checks if a change had been made
but it's hell, is there any other way
i Heared of Trigger Proc that can be placed in the server will that report to my App's about Changes
I'm Confused from all the Knowledge in the Subject of ADO.Net
THANKS in Advance
Have Fun
Never forget it
|
|
|
|
|
You are talking about Notification, check BOL although I'm not sure if it works on Express. Try googling for SQL 2005 query notification.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
THANKS,
it's not working in Express
Any Other IDEAS
Does A Thread that will pull info and will pporivde an Equal Method ti Compare The Dataset
is A Good IDEA ?
Have Fun
Never forget it
|
|
|
|
|
You could put a column on the database with the last changed datetime and check that in apps2 and 3 (on a timer maybe, keep last changed date between polls), but remember that sql server is only accurate to a third of a millisecond so if you are doing rapid inserts you could get multiple records per millisecond.
Hope this helps
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Sound Nice
i've got around and created a Thread that will
Fill a "Fake" DataSet and then some Checks to see what has Changed
The Thread will Fill the fake Dataset every 500 mili
because changes made by the user usualy take a lot more
it works nice and the importent thing is that only 10 users MAX will
work with the UI so it works great
THANKS anyway
Have Fun
Never forget it
|
|
|
|
|
Hi,
Please refresh my memory...
What the difference is between using & or + to join fields with text.
SELECT FirstName + ' ' + LastName AS FullName FROM table
or
SELECT FirstName & ' ' & LastName AS FullName FROM table
thanks,
Ron
|
|
|
|
|
myNameIsRon wrote: SELECT FirstName + ' ' + LastName AS FullName FROM table
This works
myNameIsRon wrote: SELECT FirstName & ' ' & LastName AS FullName FROM table
This doesn't, you get Invalid operator for data type. Operator equals boolean AND, type equals varchar.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hmmm,
Both will work for me. I'm using a MS Access db with OleDbCommand (C#)
Ron
|
|
|
|
|
Both do not work on SQL Server. Access has its own brand of SQL and does a lot of wierd stuff.
|
|
|
|
|
My mistake, I assumed you were using SQL Server - or maybe yours for not specifying
Anyway, as Micheal has said, Access has its own rules!
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Thanks guys,
I didn't realize it was specific to Access SQL.
I did some testing, and here it is. If your field is NULL, and you're using '+', the join is ignored.
SELECT ID_Field + ' - ' & NameField FROM table
ID_Field not null: 3433 - Bob Smith
ID_Field null: Bob Smith
SELECT ID_Field & ' - ' & NameField FROM table
ID_Field not null: 3433 - Bob Smith
ID_Field null: - Bob Smith
Ron
|
|
|
|
|
+ return NULL if any one of the field contains NULL value.
Otherwise both more or less returns same results.
Regards
SG
|
|
|
|
|
hi all,
can some one help me to protect my database with a strong password like we protected our db in ms access.
thanks.
rmshah
Developer
|
|
|
|
|
You can't. SQL Server does not work like that. Take a look at authentication in BOL.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
i think you can protect your database by right clicking on register server then change sa password,now when someone trying to open database it pop up
for password window.
Ghazanfar Ali
Programmar (MSTS,MCPD)
|
|
|
|
|
I have been writing some small personel programs using VB.NET 2005 express and SQL 2003 for storage. I recently purchased a new computer with windows Vista. I copied my VB programs to my new computer but when I tried to copy my SQL databases nothing worked. I got every error message conceivable. I tried just plain copying to a CD, I tried exporting to a CD using SQL and even exporting to an ACCESS database. Nothing worked. Any Ideas??
Thanks.
Peter B.
|
|
|
|
|
Can't you detach the DB and copy the MDF's over?
|
|
|
|
|
I haven't tried that yet. I will and let you know. Thnks.
|
|
|
|
|
do simple job, take backup of your database and create a new db on your new pc with the same name and restore the file you have taken by backup.
rmshah
Developer
|
|
|
|
|
I did recreate a new database in ACCESS and was finally able to copy my tables of data from SQL to it. Thanks for the advice.
|
|
|
|
|
Hi all,
I am trying to bulk insert a Csv file from an FTP site to a table in SQL2005.Can any one advice me on how to do it using SQl server integration services.(SSIS package)
I havent used this before ,however i have seen an FTP task on the tool box.
Your views are much appreciated.
Thank you
|
|
|
|
|
Please don't cross post. It's rude. Read the forum rules.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi All,
I've just started looking at LINQ and it seems cool 'n all but for getting data into a DataSet / DataTable I seem to have defaulted back to plain old .NET DataAdaptors and issuing normal "SELECT * FROM ... " commands.
I was doing this:
DataContext dc = new DataContext(conn);
Table<TableName> tablename = dc.GetTable<TableName>();
I read some online samples (that were referencing System.Query which I can't find!) and they were creating plain .NET tables (i need this for databinding to in a UI) by using .ToDataTable(); which seems to be a really handy command that doesn't appear in my intellisense.
What's the easiest route from a LINQ Table<TableName> to a plain old .NET DataTable ?
Jammer
Going where everyone here has gone before!
My Blog
|
|
|
|
|
Funnily enough, I answered this same question in a Blog a while back. You can find the answer here[^].
|
|
|
|