Viewing 15 posts - 1,591 through 1,605 (of 2,894 total)
...
I humbly submit:
CREATE PROC p_Answer AS RETURN 42;
🙂
It can be few yocto-seconds slower. Can be a great impact if you call it just few septillion times.
Serious performance degradation...
:w00t:
May 10, 2012 at 6:19 am
I wouldn't use "Instead Of" trigger for that. The standard one for "after insert,update,delete" will do as fine with much less coding...
May 10, 2012 at 6:13 am
BEGIN and END just determine the logical block of statements.
It's nothing to do with transactions.
Transactions are controlled by:
BEGIN TRANSACTION
COMMIT TRANSACTION
and
ROLLBACK TRANSACTION
statements (or shorter variations of them - all in the...
May 10, 2012 at 4:27 am
Sorry Cadavre, I need to correct the comments for my code.
SELECT CONVERT(VARCHAR, [Date], 112) AS DateSk --Convert the date to string in ISO format. (On any system it will...
May 10, 2012 at 4:17 am
maheshkrishnas (5/7/2012)
Hi all,I am new to sql server, How to write a trigger which stops the DML operation on a table for particular time...
Can anyone help on this......
What do...
May 10, 2012 at 4:03 am
WayneS (5/9/2012)
Tim Walker. (5/9/2012)
May 10, 2012 at 3:48 am
i am using table variable ,i know for temp its not gonna work.but i dont have any temp table.
Who told you that for temp tables SSMS show plan is not...
May 10, 2012 at 3:06 am
It's not possible to make stored proc to behave as a multiple threads in client/windows application.
It's possible to stop stored proc execution and continue after some delay as advised in...
May 10, 2012 at 2:57 am
Looks fine to me.
I would error handling and transaction control (if it's not managed by the caller application)...
May 10, 2012 at 2:52 am
... whether it's really impossible to get fields from particular record once SQL Server has located it, just because the path used to locate it was through a grouping clause...
Something...
May 9, 2012 at 10:30 am
...SSMS just stops working.
what causes it to stop working.
Any idea?
It depends, for example if you are using Amstrad or Sinclair, just buy a newer PC, something with Pentium inside should...
May 9, 2012 at 10:24 am
Shree-903371 (5/9/2012)
I'm sorry I didn't explain it correctly. I need all products and products with status NA must have onhand greater than zero. Below is what i want to display:ProductStatusOnHand
1230DI20
7689TO20
6758NA10
SELECT...
May 9, 2012 at 10:18 am
That will give you exactly what you asked for...
select CONVERT(VARCHAR, [Date], 112) AS DateSk -- ISO
,[Date]
...
May 9, 2012 at 10:11 am
...
I need to show products whose Status is NA and OnHand is greater than 0. ...
You don't need to use CASE WHEN for what you asked. Just:
SELECT * FROM...
May 9, 2012 at 10:01 am
Actually, there are!
You can use other technologies for text searches eg. Lucene for example.
It's very hard to suggest anything particular without knowing your system architecture details, requirements and your...
May 9, 2012 at 9:57 am
Viewing 15 posts - 1,591 through 1,605 (of 2,894 total)