This might help you

http://stackoverflow.com/questions/38549/sql-difference-between-inner-and-outer-join

http://www.databasejournal.com/features/msaccess/article.php/3516561/Implementing-the-Equivalent-of-a-FULL-OUTER-JOIN-in-Microsoft-Access.htm

This might Help You

http://forums.techarena.in/software-development/1122041.htm

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/cb8fed73-c134-46ef-aff8-7d4ea57a1033

The arrangement of the fields going to confuse me...we must have a fields in a series....some fields are coming from xml and some will come from country..really confused...the ID comes...

How it could be like this?

BEGIN

DECLARE @idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @xml

INSERT INTO TESTCITY (

[CITY]

,[COUNTRYID]

,[Keywords]

,[DialCode]

,UserID

)

SELECT CITY,COUNTRYID=(select Id from Country where CountryName=CountryName),Keywords,DialCode, @userid

FROM OPENXML (@idoc,@chk , 1)

WITH ([CITY] [varchar](50)...

dwain.c (4/19/2012)

---

Now i want only one change....

as you can see that in @xml we have CITY which is NVARCHAR so i want to get ID of each in a table...like...

@dwain.c:

That work very Fine...Now i want only one change....

as you can see that in @xml we have CITY which is NVARCHAR so i want to get ID of each in...

anthony.green (2/29/2012)

---

Gianluca Sartori (2/29/2012)

---

GilaMonster (2/29/2012)

---

Gianluca Sartori (2/29/2012)

---

GilaMonster (2/29/2012)

---

The marketing launch event is in a couple of days. Availability of the...

Should i wait to RTM(release to marketing) OR GA(General availability)?and how i will know that it is now available....i am a developer and i have its requirements

in which situation i should use BEGIN TRAN etc...or using COMMIT etc etci know all mentioned points..thanks for those

I am writing sqlserver queries from a long time....can you help me how to write insert/update and delete queries in a good and professional way?

@anthony-2:

if you do not mind i want to elaborate a little bit more.....explain me

what are isolation levels and how they will be treated?

give me a complete example so...

@TheSQLGuru:

But there is issue like when some one is updating middle record?for example max id is 10 but i want to edit id=5 then this query l not...

TheSQLGuru (2/21/2012)

---

Engr Shafiq (2/20/2012)

---

Jeff Moden (11/30/2011)

---

Actually, there's a great way to track it without a trigger if you can add a column as Kingston suggested. The difference is that...

Hi all,

as in this post i am converting my XLS file to xml and pass to store procedure ...till here it is working..i can save all xml data...now issue is...

Jeff Moden (11/30/2011)

---

Actually, there's a great way to track it without a trigger if you can add a column as Kingston suggested. The difference is that you would use...