Viewing 15 posts - 2,596 through 2,610 (of 3,221 total)
Thank you for the additional information
amujtaba
2) Other procs might be calling this update proc for the table
This poses other questions:
6. Do you want the name of...
March 6, 2009 at 8:10 pm
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....
March 6, 2009 at 9:44 am
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)...
March 5, 2009 at 4:56 pm
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...
March 5, 2009 at 2:37 pm
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...
March 5, 2009 at 1:01 pm
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...
March 5, 2009 at 12:01 pm
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...
March 4, 2009 at 4:15 pm
Reply removed since it did not answer the question properly ... sorry about that
March 4, 2009 at 10:07 am
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...
March 4, 2009 at 10:01 am
Select FirstName + ' ' + Last Name as Name from tbl1
March 4, 2009 at 9:20 am
Using Enterprise Manager
Select the database
Expand Tables
Right click on the table name
Select All Tasks
...
March 4, 2009 at 8:42 am
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...
March 4, 2009 at 8:22 am
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...
March 3, 2009 at 11:50 am
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)?
March 3, 2009 at 9:00 am
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...
February 28, 2009 at 7:54 am
Viewing 15 posts - 2,596 through 2,610 (of 3,221 total)