Viewing 15 posts - 6,331 through 6,345 (of 7,631 total)
Himm, it only happens on assignments:
declare @sqlfilter varchar(33)
select @SqlFilter = 'a' + 'd' + + 'b'
Acts like the extra "+" is not there.
But
select 'a' + 'd' + + 'b'
Gives...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 11, 2008 at 6:10 am
karthikeyan (7/11/2008)
There are lots of things that Rollback cannot undo.
can you tell me what are all those ?
No. I can give you some examples though:
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 11, 2008 at 5:49 am
Thanks for the feedback.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 11, 2008 at 5:43 am
Missing: sample data for the tables (in the form of INSERT statements that can be cut, paste, and run in SSMS to load the tables).
still not seeing it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 11, 2008 at 5:27 am
The way to sort out in your mind how CASE works VS. how IF works is this:
IF is a flow-control statement
however
CASE is a function.
Yes, it does not...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 11, 2008 at 5:16 am
Denis (4/13/2007)
BEGIN TRAN trialEXEC sp_executesql @sqlstring
ROLLBACK TRAN trial
I would not recommend this. As a previous post noted: this is extremely dangerous. There are...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 10:24 pm
Union combines multiple result sets into one result set. It does not combine multiple records into single records.
There are other methods to combine multiple records into single records, the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 10:09 pm
Service Broker tip: make sure your procedures are ending their conversations (both sides)!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 9:56 pm
Though I've never done it myself, I seem to recall reading that Notification Services was created specifically to do this sort of thing with Reporting Services.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 9:31 pm
I think this is simpler and more efficient:
ALTER PROCEDURE [dbo].[ProductType_ValidateStartDate](
@ProductTypeID INT,
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 9:20 pm
Use this function:
ALTER function [dbo].[fnSplit1](
@parameter varchar(Max) -- the string to split
...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 8:50 pm
You can set up client aliases under the configuration manager.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 8:18 pm
try this:
select *
from sys.tables t
Where NOT EXISTS( select * from sys.foreign_keys
Where t.object_id IN (Parent_object_id, Referenced_object_id) )
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 8:12 pm
What does "transfered to another school" entail, in database terms?
The SOP way to allow someone to perform operations on data without giving them direct access to the data is through...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 7:03 pm
Vivien Xing (7/10/2008)
rbarryyoung (7/8/2008)
Alter Proc spLogin_OwnedObjects ( @login as SYSNAME ) As
/*
Display all objects in all DBs owned by the Login.
2008-07-06 RBarryYoung Created.
Test:
spLogin_OwnedObjects 'sa'
*/
declare @sql varchar(MAX), @DB_Objects varchar(512)
Select...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
July 10, 2008 at 3:54 pm
Viewing 15 posts - 6,331 through 6,345 (of 7,631 total)