|
Table_A contains no data. All it contains is a surrogate key, a key to look up nothing.
If you really need the list of values that you expect in Table_A, then a select distinct(Table_A_Id) from Table_B will serve its purpose.
If you want to constrain the column in Table_B to a set of values, then use a constaint.
|
|
|
|
|
hi
Please Explain in Detail on what you want to achieve.
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
|
|
|
|
|
Hi, Vuyiswa Maseko,
thanks for your reply. I described the coveted structure in my reply to Paul. Any help will be greatly appreciated.
Thanks much,
Michal
|
|
|
|
|
In SQL Server 2005,
If not caring about normalization, NEWID() will autogenerate a uniqueidentifier
INSERT INTO [GSTDB].[dbo].[TableName]
([Field1])
VALUES
(NEWID())
GoodLuck!!
|
|
|
|
|
Hello Friends,
I want to get the information of the record(s) where SmallImage(Field Name) must be unique. For this i'm using the following query. Is it right or not if not plz make it correct
Select * From Gallery1 Where SmallImage in (Select Distinct SmallImage From Gallery1 Where Active=1)
|
|
|
|
|
hi Friend
try this
select * from Gallery1 where SmallImage = "whatever" And
Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)
Remember you have to Assign a value in the First select statement.Think of it this was. you want to select all the records in a table called "Gallery1" where Value is equals to "that", and from the above Query display the records Distinctively.
hope it helps
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
|
|
|
|
|
Sorry Friend,
The code you sent is not working properly
Select * From Gallery1 Where SmallImage='~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' and SmallImage in
(Select Distinct SmallImage From Gallery1 Where Active=1)
The code is given above only giving the records that include the SmallImage='~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg'
|
|
|
|
|
hi Friend, here is your Mistake. i have sent you the Query that looks like this
select * from Gallery1 where SmallImage = '~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' And
Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)
And you sent me that give you a Problem now ,that looks like this
Select * From Gallery1 Where SmallImage='~/Gallery/Bhaiji in USA/Small/IMG_0028.jpg' and SmallImage in
(Select Distinct SmallImage From Gallery1 Where Active=1)
if you can look at the Above Queries, they dont look the same. the First Query is what i recommended and the second query, its yours and you did not use the "Exists" and you used SmallImage again, and SQL does not know what to do with it, its like an used variable but declared.
try the first one and tell me what you get
Hope it helps
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
|
|
|
|
|
Sorry Friend again i got same result............
It's bringing the records Where SmallImage-"....given below...."
Select * From Gallery1 where SmallImage = '~/Gallery/Bhaji in Lodhi Garden/Small/5.JPG' And Exists (Select Distinct(SmallImage) From Gallery1 Where Active=1)
|
|
|
|
|
My requirement is to read data from Oracle using BizTalk (XML) and write to SQL Server.
Looking for recommendations.
Thanks.
The Phantom.
|
|
|
|
|
|
Do a google search first.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Ph@ntom wrote: My requirement is to read data from Oracle using BizTalk (XML) and write to SQL Server.
Why? You can do this by reading the data from SQL Server using SSIS (SQL Server Integration Services) which is perfectly capable of transforming data from other database sources.
|
|
|
|
|
Hi,
I am using Sql Server Reporting Services in my asp.net web application. I am displaying the reports in reportviewr.
Whenever there is some data its ok. But When The Stored Procedure or query didn't produce any result the report viewer appears and take usual place(i.e width and height).
My requirement is that if the stored procedure or query returns data then the report viewer will be visible along with data. Else the report viewer should Hide and display Record Not Found.
Issue:
--------
As the .rdl file is directly related to stored procedure or query we r not fetching any datatable into the page.
Any Suugesstions or Solutins heartly Accepted....
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Sangram
(A battle with self)
Life is simple, we are the ones makes the living difficult
|
|
|
|
|
Data bound controls in SSRS have a NoRows property which allows a message to be defined which will only be displayed when the data source that the control is bound to does not return any data.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I need to store a time such as 5:00 PM in a table column in SQL SERVER Express 2005. I do not need to store any data about the date. I know that I could store this as text, but I know I should store it in a datetime data type. Should I create a user defined type just for time?
When I first was writing the database I found an article in a forum where users were saying that when they needed to store a time with no date they were using a text field. Then I posted a message in the VB.NET forum and I was told that it would be a big mistake to store a time in a text field.
What should I do?
|
|
|
|
|
AAGTHosting wrote: Should I create a user defined type just for time?
Probably the best route to go. If you have any comparing/manipulation of the data, it will be easier to work with a UDT, rather than a text field.
OT: One of my favorite books is Pro SQL Server 2005 Database Design and Optimization[^] by Louis Davidson. He does a pretty good job with UDTs. Examples in both C# and VB.NET. Though it is for SQL Server 2005, most of the material still works with SQL Server 2005 Express.
"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon
|
|
|
|
|
Hello,
I am looking for a reference book that covers T-SQL for MS-SQL 2005. I have found several that cover SQL Server, but almost nothing about stored procedures. I want a book that covers advanced programming along with some of the performance topics, and advance query and calculations.
Thanks,
Leo T. Smith
|
|
|
|
|
A quick search on Amazon yielded several relevent titles[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
|
Thanks, I'll check it out.
Leo T. Smith
Program/Analyst Supervisor
|
|
|
|
|
Thanks, a couple of these looks like what I need. I went and checked them out locally and actually found one.
Leo T. Smith
Program/Analyst Supervisor
|
|
|
|
|
This is a very subjective beginner question... Suppose I have two different applications that access the same database, and I want them both to use the most recent data... how should I do it? Should I clear and refill my whole dataset every time I access data? Should I use remoting between the two applications in order to notify each other of what row to reload (this seems complicated!)? By the way I work in disconnected mode with Typed datasets.
I'd appreciate if you gave me some pointers.
Thank you!
|
|
|
|
|
Applications informing each other about changes to data doesn't sound like a good idea. You haven't stated what database system or programming languages you are using. If you are using, SQL Server 2005 and .NET, Query Notification[^] may be of interest to you.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
