Viewing 15 posts - 1 through 15 (of 15 total)
GilaMonster (9/18/2008)
SELECT @object_action = object_action ,@object_name = object_name FROM INSERTED
assumes that there is only one row in the inserted table. That may not be the case. What's going to...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
September 18, 2008 at 6:37 am
Hi,
It was a bit hard to look up the problem you are facing, but I assume this answers your question: The error occurs on 'line 1', and all that says...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
September 18, 2008 at 5:11 am
Hi,
You are mentioning a common problem, lots of folks happen to have this problem.
I'm not 100% sure, but the problem seems to be related to connection pool recycling. You can...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
September 18, 2008 at 4:48 am
FYI: This Ctrl+K, Ctrol+C/Ctrl+U key combination is the default combination for (un)commenting code in all modern Microsoft code editors. Although it is not the most attractive combination to use, at...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
September 18, 2008 at 4:38 am
If I get the point right, you want to use a computed column in the select query. In that case, you should use something like (sorry for possible syntax errors,...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
September 18, 2008 at 4:36 am
Hi sugan,
Is your question solved, or do you still need some more explanation? If so, please clarify your question to make it possible for us to give you an answer.
Cheers,...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
August 25, 2008 at 6:12 am
I'm not sure either, but it seems to me that you would like to insert a non-NULL value in the temp table, because a NULL value is not possible (are...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
August 25, 2008 at 5:05 am
Of course, but that will bless you with a serious performance issue when talking about > 500,000 rows (as there are in our table) 😉 . I did not find...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
May 7, 2008 at 1:14 am
sqluser (5/6/2008)
And all the user defined procedure you want to find out by using the following stmts.SELECT * FROM sys.sysobjects
WHERE [name] LIKE '%SP%'
AND xtype LIKE 'P'
Many SQL users do not...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
May 6, 2008 at 11:11 pm
@RBarryYoung: Perfect! I did not know this works until now (we always use a kind of fulltext indexing for this).
The only drawback for this syntax is that...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
May 6, 2008 at 11:07 pm
Indeed, the new TRY..CATCH construct should be used. The main reason for me would also be not to type the @@ERROR check after each command, but it has more advantages,...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
May 6, 2008 at 10:58 pm
Congrats 😀 ! Enjoy it! Did you pass at once?
About braindumps etc. etc.: would those guys know what they are doing in real life, that would not bother me so...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
April 23, 2008 at 3:51 am
The exam fee in The Netherlands (as I heard in all of Europe) is € 140,-. If you buy yourself the Self-paced training kit, there will be a 15% discount...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
April 22, 2008 at 1:29 am
I am going for the SQL Server 2005 certification as well. I see two important reasons for SQL Server 2005 certification:
1. The coming x years SQL Server 2005 will be...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
April 22, 2008 at 1:23 am
As others state: only the NVARCHAR columns already sum up to above the max answer. Therefore, I (wrongly 😉 ) selected the maximum choosable 😉 ...
[font="Courier New"]
------------------------
MCPD Web Developer, MCPD Windows Developer[/font]
Computers are made to solve problems you did not have in the days they didn't exist.
April 9, 2008 at 5:04 am
Viewing 15 posts - 1 through 15 (of 15 total)