|
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
|
|
|
|
|
goldoche wrote: I want them both to use the most recent data
You can never have the most recent data. As soon as you have retrieved it, it is potentially out of date. That said, you then have to decide how out-of-date you are willing to allow the data to be. You'll have to have some way of dealing with concurrency violation, that is, where another user has modified the data since it was read. One approach, that used by the DataSet's update feature by default (IIRC), is to compare all the field values against the values that were retrieved and if different, to fail the update.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
i have written a trigger as followed:
<br />
-- ================================================<br />
-- Template generated from Template Explorer using:<br />
-- Create Trigger (New Menu).SQL<br />
--<br />
-- Use the Specify Values for Template Parameters <br />
-- command (Ctrl-Shift-M) to fill in the parameter <br />
-- values below.<br />
--<br />
-- See additional Create Trigger templates for more<br />
-- examples of different Trigger statements.<br />
--<br />
-- This block of comments will not be included in<br />
-- the definition of the function.<br />
-- ================================================<br />
SET ANSI_NULLS ON<br />
GO<br />
SET QUOTED_IDENTIFIER ON<br />
GO<br />
-- =============================================<br />
-- Author: <Author,,Name><br />
-- Create date: <Create Date,,><br />
-- Description: <Description,,><br />
-- =============================================<br />
CREATE TRIGGER tr_stagingEmployer_Update<br />
ON Employer<br />
AFTER UPDATE<br />
AS<br />
-- SET NOCOUNT ON added to prevent extra result sets from<br />
-- interfering with SELECT statements.<br />
SET NOCOUNT ON;<br />
<br />
INSERT INTO stagingEmployer<br />
SELECT<br />
*, 'U' as [Action]<br />
FROM<br />
Inserted<br />
GO
BUT i get error stating:
<br />
Msg 311, Level 16, State 1, Procedure tr_stagingEmployer_Update, Line 14<br />
Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.<br />
what is wrong with this query?
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
From a Microsoft article on the subject:
SQL Server 2005 does not allow for text, ntext, or image column references in the inserted and deleted tables for AFTER triggers. However, these data types are included for backward compatibility purposes only. The preferred storage for large data is to use the varchar(max), nvarchar(max), and varbinary(max) data types. Both AFTER and INSTEAD OF triggers support varchar(max), nvarchar(max), and varbinary(max) data in the inserted and deleted tables
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
