I guess it does as long as you're not watching it on a laptop via TV card....

DECLARE @stmt NCHAR(1000)

SET @stmt = 'CREATE VIEW....'

EXEC (@stmt)

If you want this on a regular basis, you might want to take a look at sp_executesql in BOL. It has some advantages...

Sourcesafe!

I guess, because it comes with Visual Studio

I use the image data type to store xls, doc, pdf, ppt and I don't know what else.

Front end is some asp application which opens the data in the associated...

Hm,...Black belt is used somewhere else. Still think let the people decide.

Life after computer and databases ?

I think I've heard about it.

SELECT [datecolumn] & " " & [timecolumn] AS MyDate

FROM Tabelle1;

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=94549

More than one way to skin the cat, I guess.

I would create a query in Access that combines both columns into one, switch to SQL Server and import the data...

Curious what there is to come. Database icons

Custom title at 1,000 posts ?

Once again, use the image data type. It's for all kind of binary data.

And take a look at this one.

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part3/c1161.asp

Oh, yes, there it is

Could a moderator please delete the above post?

I feel offended

If this will ever happen you can

CREATE TABLE [dbo].[Test] (

[IntIdentityCol] [int] IDENTITY (2147483647, 1) NOT NULL ,

[ColB] [varchar] (50) NULL

)

GO

Insert Test values('A') -- Ok 2147483647 get

Insert...

I agree with Chris.

Imagine everyone on this forum would have usernames like 5409045121009 

Now being serious, I...