|
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[^].
|
|
|
|
|
Fantastic!! Thanks chap.
Jammer
Going where everyone here has gone before! 
My Blog
|
|
|
|
|
No bother mate. Glad to help.
|
|
|
|
|
Hi all,
I am confused in choosing between a View and a table-valued UDF and looking for your suggestions. Here is what I want to do.
Select
Column1, Column2, .. ColumnN
From
Table1
Inner Join Table2 on SomeColumns
Inner Join Table3 on SomeColumns
..
Inner Join TableN on SomeColumns
Where
Condition1 ..... Condition N
Of course, I will be consuming this view/UDF in my queries later.
Please note that I have no specific parameters for this query, nor have I any security requirements. I just want to know which one gives better performance. Ideas
Thanks,
Mehroz
|
|
|
|
|
Good Morning All
u have the Following Query that Display me the records.
select ps.Lis_key as [Celeste],p.Lis_key as [Pro-v],<br />
p.Attrib_code,p.Func_key from dbo.Check_LIS ps<br />
inner join Tshwane_Valuations.sde.Property p <br />
on ps.Lis_key = p.Lis_key<br />
where ps.Lis_key = p.Lis_key And <br />
Substring(p.Attrib_code,5,2)='16'<br />
OR p.Attrib_code = '0009000900'
so i want Delete the records returned by this Query. please Explain how you do it when you give me a code.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Why don't you try this:
delete from dbo.Check_LIS
where Lis_key in(
select ps.Lis_key
from dbo.Check_LIS as ps inner join Tshwane_Valuations.sde.Property as p
on ps.Lis_key = p.Lis_key
where substring (p.Attrib_code, 5, 2) = '16'
or p.Attrib_code = '0009000900'
)
Also you don't need to add ps.Lis_key = p.Lis_key in the where clause since you use inner join on the same fields.
I hope this was helpful.
Best wishes,
Dobromir.
|
|
|
|
|
Thanks man
it was very easy
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hello,
I'd like some help on the following problem - I need to use an alias as a condition in the where clause:
select field1,
field2,
field3,
field1*field2-field3 as some_alias
from table1
where some_alias between 10 and 20
Using an alias like that returns the following error:
Invalid column name 'some_alias'.
Could anyone propose a solution?
|
|
|
|
|
Hi Dobromir,
You can use the alias definition in the where clause. Here is your query modified:
select field1,
field2,
field3,
field1*field2-field3 as some_alias
from table1
where (field1*field2-field3) between 10 and 20
Regards,
Mehroz
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
