Viewing 15 posts - 1,126 through 1,140 (of 3,221 total)
Since i don't have any experience in Stored procedure, Can anyone write a stored procedure, which make the output shown in the above image?
Sorry do not see an image...
July 3, 2011 at 2:56 pm
Look up sys.all_columns and sys.all_objects in Books On Line ... you will find your answer there. But may I ask, why do you need to do this?
July 3, 2011 at 7:41 am
I must congratulate you on providing table definitions, which in many cases others requesting assistance do not do. However in your instance, if I execute the script for creating...
July 2, 2011 at 10:36 am
Not sure if I understand your question correctly, but how about testing these:
SELECT Id,Address1,Address2 FROM #Tbladdr WHERE RTRIM(Address1) <> RTRIM(Address2)
SELECT COUNT(*) FROM #Tbladdr WHERE RTRIM(Address1) <> RTRIM(Address2)
SELECT COUNT(*) FROM #Tbladdr...
July 1, 2011 at 9:38 am
Andy Warren (6/29/2011)
Still, it's a bit of fun to tweak Steve for getting the logic backwards. First time in months I do the QOD and I get it wrong (right)!
True...
June 29, 2011 at 8:04 am
The first thing I would suggest is to have your DBA install on your computer the two interfaces to SQL 2000, which are.
1. Query Analyzer - this interface will...
June 29, 2011 at 7:55 am
call.copse (6/29/2011)
Glad I'm not the only one confused!I'm going to have to submit my own question sooon just so we get one with a correct answer :hehe:
Please do submit a...
June 29, 2011 at 5:45 am
So are these incorrect:
http://msdn.microsoft.com/en-us/library/bb934049.aspx
which states:
FILESTREAM data is not encrypted even when TDE is enabled.
And:
http://msdn.microsoft.com/en-us/library/bb933993(SQL.100).aspx
FILESTREAM data is not encrypted even when transparent data encryption is enabled.
June 28, 2011 at 10:34 pm
rickee.blog (6/28/2011)
but i insertec more than 1000 records it give error
: there was a problem reading this document (14)
can sum1 help me
pls...
June 28, 2011 at 6:31 am
Look at using the MERGE statement. For example at
http://technet.microsoft.com/en-us/library/bb510625.aspx
or with some example code at:
http://www.codeproject.com/KB/database/SQL-2008-Merge-Statement.aspx
June 27, 2011 at 11:15 am
Ayie
2. any queries can capture the data, if the auto update statistics is running
Try using sp_autostats for some representative table(s) it will return information on wether aut_stats...
June 27, 2011 at 5:32 am
mohammed moinudheen (6/26/2011)
Great question Ron. You provided an excellent scenario to understand a concept. Thank you.
The scenario is not mine, but rather one from Paul Randal's blog, so it is...
June 26, 2011 at 4:42 am
jkp2311 (6/25/2011)
Hi Jeff,I am so Sorry...
it was my mistake...
i apolozige to you...
And Bitbucket....Thanks to you....
i got it...
I am sure that both myself, LutzM and Jeff Moden are glad that you...
June 25, 2011 at 3:21 pm
You can use Google to find many, many helpful articles for CTE's. Now to start you off:
http://msdn.microsoft.com/en-us/library/ms190766(v=SQL.90).aspx
and
http://www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/
June 25, 2011 at 2:43 pm
Viewing 15 posts - 1,126 through 1,140 (of 3,221 total)