Is this what you want?

SELECT LEFT(CONVERT(VARCHAR(19), CAST('20050802' AS DATETIME), 120), 10)

SELECT i.*

FROM sysindexkeys ik

INNER JOIN sysindexes i ON ik.indid = i.indid AND ik.[id] = i.[id]

INNER JOIN syscolumns c ON ik.colid = c.colid AND ik.[id] = c.[id]

WHERE ik.[id] = OBJECT_ID(@table_name)

AND c.[name]...

Is there any way to change UDP port 1434 in sql server?

No, 1434 is always the port used by the listener.

I read in few threads that we can avoid using...

I have noticed that there is such a thing as sqlnativeClientConfiguration --> aliases

I hope that this is my baby?

Well, you do not have to configure aliases. Just start SSMS and...

Yes, SQL Server Management Studio can be used to connect to SQL Server instances (7, 2000 or 2005) both on the local machine or remote machines. What version of SQL...

I just tested creating a user-defined type in model that I called 'testtype'. I then created a new database, and in it a table where I used the type, like...

COLLATE is used to specify that a character string or column (of some character type) should use a specific collation.

Timestamp is a (bad) synonym for rowversion. You should use rowversion...

Here is the relevant text from BOL:

You do not have to specify the EXECUTE keyword when executing stored procedures if the statement is the first one in a batch.

Since the...

The second query is missing the exec keyword. But I assume you already knew that, since that is the only differemce between them. I do not know how to answer...

If it is specifically an interview regarding a job that requires both SQL Server and Oracle knowledge I would have asked a little about cursors. Have the person describe how...

A DSN is nothing more than a configuration file (or other medium) that holds the info normally in a connection string. So having multiple users connection 'through a DSN' is...

I can't say anything about that figure, or give any other general figure, but I can give a warning though. In 6.5, fixed-length fields that was set to NULL only...

I am also never (as far as I have noticed) able to vote on those external articles. First I thought it was some bug with Firefox, but I have the...

No, it is not possible to stop logins that are members of the server role sysadmin from anything really. As you noticed, sysadmins have every permission there is and it...

Yes, complete DDL and some sample data would be nice. In any case having a clustered index based on 6 columns, including 3 varchars, is never a good idea, even...