Viewing 15 posts - 1,576 through 1,590 (of 3,221 total)
da-zero (12/16/2010)
Nice question and an important point, but I have executed the code a 100 times or more and I always get the error.
While executing the T-SQL a mere 40...
December 16, 2010 at 10:54 am
You may want to test this:
SELECT
Owner = USER_NAME(so.UID),
...
December 15, 2010 at 11:16 am
wware (12/13/2010)
December 13, 2010 at 2:50 pm
MidBar (12/8/2010)
Only lesson, i got from this question is to read the comments more carefully (run twice...) and thats why its just another dodge question.
I would certainly hope that...
December 13, 2010 at 2:49 pm
Here is another method - but you will have to test to determine which is most efficient. Look up the modulo operator in Books On Line to understand the...
December 13, 2010 at 2:37 pm
techzone12
Thanks for the feed back.
Now for everyone who wants to help you, the next time you post a question to a forum please provide the table(s) structure,...
December 12, 2010 at 8:17 pm
Rahul The Dba (12/12/2010)
Hi,All my drear readers hope you will be able to learn a trick about varchar and char datatypes in SQL.
Thanks for viewing it.....
I did and thanks for...
December 12, 2010 at 5:05 pm
Here is a GROUP BY solution
CREATE TABLE #T(EmpId INT, EmpName VARCHAR(50),Salary MONEY)
INSERT INTO #T
SELECT 123, 'andy', 10000 UNION ALL
SELECT 111, 'Maddy', 12000 UNION ALL
SELECT 121, 'Raman', 25000 UNION ALL
SELECT 124,...
December 11, 2010 at 10:15 am
Without using sp_ForEachTable you might want to try this code:
DECLARE @Table NVARCHAR(200),@Column NVARCHAR(200),@Sql NVARCHAR(2000)
DECLARE Table_Cursor CURSOR FOR
SELECT so.Name AS 'Table',sc.Name AS 'Column'
FROM...
December 11, 2010 at 9:16 am
If you would provide table definition, some sample data and required result based on the sample data, then some one will be able to assist you with a tested solution.
Click...
December 8, 2010 at 8:02 pm
What you need to do is to develope an overall requirements document specifying what you management expects to use the database for.
a. What data do people...
December 8, 2010 at 7:59 pm
Have you considered importing the data into a "staging table" , then using one or more T-SQL statements to locate the rows where there is data that "violates the constraint(s)"....
December 8, 2010 at 3:42 pm
Carlo Romagnano (12/7/2010)
When I realize that a command or option is deprecated, I stop to waste my time to use it.
My thoughts: It should be an alert to check...
December 7, 2010 at 8:09 am
john.moreno
hmm I tested repeatedly on both 5K and 8K before submitting the question .. always produced the identical answers on all servers...
Are you sure you executed the first 6 lines...
December 6, 2010 at 1:54 pm
You may want to look at the SQL Server Migration Assistant document (pdf) at:
http://download.microsoft.com/.../SQLServer2000MigrationAssistant_Final.pdf
A TechNet search for the SQL Server Migration Assistant
http://technet.microsoft.com/en-us/default.aspx
This article on SSC will explain its installation...
December 5, 2010 at 7:31 am
Viewing 15 posts - 1,576 through 1,590 (of 3,221 total)