Thank you for the additional information

This poses other questions:

6. Do you want the name of...

amujtaba

May I ask you to elaborate more on what you want, and the scenario that you want it in.

1. Do you apply all updates using only Stored Procedures?

2....

I modified Florian.Reischl's code to

IF (OBJECT_ID('udp_test') IS NOT NULL) DROP PROCEDURE udp_test

GO

CREATE PROCEDURE udp_test

AS

SELECT * FROM sys.procedures WHERE object_id = @@PROCID

SELECT OBJECT_NAME(@@PROCID)...

In addition to Bob Hovious code you might want to read this article by Anthony Zarkin

which includes all the necessary code to create user functions to convert numbers

to words and...

EarthandAllStars

This does not answer your original question, but since you are interested in MS training and certification - this site by MS offers training / certification at a reduced price...

In an effort to further explain what occurs with the SNAPSHOT and READ COMITTED Isolation using Row versioning - the following quotes were taken from

http://technet.microsoft.com/en-us/library/ms345124(SQL.90).aspx. The use of...

Ninja's_RGR'us (3/4/2009)

--------------------------------------------------------------------------------

No offense, but if all that is required is put up a crappy blog with unverified recommendations, I can be an mvp in 7 days with 50$ out of...

Reply removed since it did not answer the question properly ... sorry about that

From Books On Line

A value of NULL indicates that the value is unknown. A value of NULL is different from an empty or zero value. No two null values are...

Select FirstName + ' ' + Last Name as Name from tbl1

Using Enterprise Manager

Select the database

Expand Tables

Right click on the table name

Select All Tasks

...

This I think will give you what you need.

-- this is just to check that the CONVERT statements are returning a DATETIME data type and not a VARCHAR

DECLARE @Time...

Using the Surface Area Configuration.

On the first screen select

Surface Area Configuration for features - it is close to the bottom of the screen.

In the next form - left frame Click...

Might I suggest you read this from Books On Line:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/e123fb74-022e-4a62-9639-b2053a9b4d7e.htm

Is it possible for you to change your columns data type from varchar to nvarchar (unicode character)?

Just a sugestion

/*

This is an example of how to output to Excel.

Note will not output to Excel 2008

Criteria: Spread sheet must exist on...