Viewing 15 posts - 901 through 915 (of 3,221 total)
Glad to be of assistance. Thanks for your reply
October 27, 2011 at 12:33 pm
As promised on 10/24 finally found some free time. Now this code is not the fastest, and more than likely could be improved, but it does what I think...
October 27, 2011 at 12:25 pm
Assuming that your question is a serious need for assistance. Try this code
CREATE TABLE Atable(Id INT IDENTITY(1,1),EmailAdd VARCHAR(100))
INSERT INTO Atable
SELECT 'myaddress.gamail.com'
GO 10 --Add 10 records
--Check that EmailAdd column...
October 27, 2011 at 10:30 am
I strongly suggest that you read this item by Jeff Moden
Why doesn’t ISNUMERIC work correctly? (SQL Spackle)
By Jeff Moden, 2010/12/01
http://www.sqlservercentral.com/articles/IsNumeric/71512/
Jeff lists numerous reasons, with examples, of why ISNUMERIC "fails"...
October 27, 2011 at 9:43 am
scott mcnitt (10/27/2011)
October 27, 2011 at 8:43 am
Blew that one as did someone before me.
Learned a lot by reading your references - thanks for those.
October 26, 2011 at 9:15 pm
I hope you have a job(s) to periodically back up your DB and log files.
If so.
1. Who is going to check those jobs and modify the backup path...
October 26, 2011 at 7:45 pm
1. Did you use table variables in your post only to illustrate the data and these are NOT used in your actually code? (Yes used in my production...
October 25, 2011 at 5:57 pm
Using BOL (Books On Line) for a reference. Think about using a single column whose data type is varbinary.
October 25, 2011 at 12:52 pm
Read this article by Jeff Moden, and its sample T-SQL .. it may be the answer to your question
October 25, 2011 at 11:51 am
Your request is rather vague, but I think you might want to look at this posting.
If my assumption is incorrect come on back with a more definitive question.
October 25, 2011 at 11:04 am
Rather surprised that as of this posting only 44 percent of those answering had answered correctly.
October 25, 2011 at 7:01 am
Getting close to midnight for me, and my brain is getting tired. But and it is a big but, you can retrieve all the column names for a table...
October 24, 2011 at 9:43 pm
A lot of reading of the T-SQL but a GOOD question ...
October 24, 2011 at 8:52 pm
Is this what you require?
CREATE TABLE #T(
[NationalIDNumber] [nvarchar](15) NULL,
[ContactID] [int] NULL,
[ManagerID] [int] NULL)
INSERT INTO #T
SELECT 'GOT',NULL,NULL UNION ALL
SELECT NULL,1,NULL UNION ALL
SELECT NULL,NULL,2 UNION ALL
SELECT NULL,NULL,NULL
SELECT COUNT(*) AS 'All rows',COUNT(ContactID) as...
October 24, 2011 at 7:29 pm
Viewing 15 posts - 901 through 915 (of 3,221 total)