You are kidding, aren't you?

Please read this: The flip side

Have a look to BOL for CONVERT/CAST

Way too less information for any other answer.

Search this site for "Tally table". You will find a great article by Jeff Moden which shows a solution exactly for this requirement without any cursors. 😉

In SQL Server you can handle this with ROW_NUMBER function:

INSERT INTO emp_tab (

ID,

value

...

:crying:

😉

Grant Fritchey (6/25/2009)

---

Florian Reischl (6/25/2009)

---

GilaMonster (6/25/2009)

---

There's a GilaMonster@gmail, a GilaMonster at DeviantArt[/url] and someone with GilaMonster as xbox gaming tag, that I know of. None are me. It's an uncommon...

Glad we could help! 🙂

GilaMonster (6/25/2009)

---

There's a GilaMonster@gmail, a GilaMonster at DeviantArt[/url] and someone with GilaMonster as xbox gaming tag, that I know of. None are me. It's an uncommon nickname, but not unique...

@Gail

Somebody has stolen your name. There is another "GilaMonster" on Twitter. Apparently it's not you if your second name isn't "Tim" with a Dutch homepage...

sai,

I gave you a solution. If it doesn't work or you have any questions about let me know.

...and not to hurt...

Hi

Take the XML from the MSDN sample page and save it to disk.

With XmlDocument this would work to create a DataTable:

//...

Little trick for this font problems. Hold CTRL key down and use...

I'm not sure what you are looking for.

* You can use "USE" to change database by T-SQL

* You can use your mouse to change database by select another in databases...

@jayasree-2.lingala

Please use the "Reply" button to reply to solutions supplied by people here. If you edit your previous post we (I) don't get a mail notification that new information are...

Check sysdatabases