And also dont forget to read skcadvre's post on the same thread, excellent explanations on FOR XML path.. thanks Wayne and skcadavre..

If you want to understand what the code does, read thro this:

http://www.sqlservercentral.com/Forums/FindPost962505.aspx

Wayne Sheffield did an extraordinary job in explaining the code! 🙂

Chandrasekar, you are here for a long time ; why dint you learn to provide your question so effectively so to extract best help from the volunteers?

Please provide your question...

I am able to see lot of things about a column name when i query Information_Schema.Columns

PFA the screenshot of my query

Or you could use Information_Schema views

Like :

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'TABLE'

you cant do it that way.. using dynamic query u can build it..

declare @sql varchar(max)

set @sql = ''

select @sql = 'SELECT ' + dbo.fn_columns() + ' FROM Table'

PRINT...

Remember, QUOTENAME is limited to 128 characters ; any input more than that will produce null.. So if the names should exceed 128 chars, i would forcefully CAST/CONVERT it to...

WayneS (8/31/2010)

---

This query should help you see the differences:

SELECT SYSDATETIME() AS SYSDATETIME

,SYSDATETIMEOFFSET() AS SYSDATETIMEOFFSET

,SYSUTCDATETIME() AS SYSUTCDATETIME

,CURRENT_TIMESTAMP AS...

Like

DataSet myDS = <Source> ;

string TabName = myDS.Tables[1].Name ;

?

Are u having C# code to import the Excel data ?

LOL.. Yeah Wayne! :w00t: :hehe:

Thre will be 2 invisible magic tables inside a trigger, INSERTED and DELETED..

if a value is inserted into the table where the trigger is written upon, a row will...

Without Sub Queries, probably Quatrie's method will siut.. But tel me, isnt that a interview / homework question? IF u learn the answer from us, when will you learn it...

Try this:

CREATE TABLE TempTable ( Col1 NVARCHAR(MAX))

INSERT INTO TempTable ( Col1)

SELECT CAST ( <other language column> AS NVARCHAR)

FROM <Your Table Name>

How about this?

declare @rank int;

set @rank = 2;

; with nums (N) as

(

SELECT 3

UNION ALL SELECT 6

...