Forum Replies Created
Viewing 15 posts - 2,731 through 2,745 (of 5,356 total)
-
RE: Permissions required to create procedures
I looked at roles-SQL Server, predefined. It's not impossible that both statement appear in BOL
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: HELP FOR ADVANCED QUERY
Please post this in the T-SQL forum!
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Permissions required to create procedures
Would this help
Fixed database role Description db_owner Performs the activities of all database roles, as well as other maintenance and configuration... --
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Books Online Updated 1/20/2004
Hey Brian,
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=96194
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Book by the Authors of this Site
Maybe I should explain myself a bit.
Sure, #2 on your list is kind of reference for T-SQL. Most chapters are very interesting, but some are not...
Actually, I'm waiting on Advanced...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Book by the Authors of this Site
It's all relative
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Replace NULL value with 0 in query
Might be worth considering placing a DEFAULT value of 0 on your column, otherwise you'll face the problem you know have.
Another approach might be to use COALESCE() like this
SET NOCOUNT...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: MSDB Recovery Model
In addition to Allens' post this might be interesting http://support.microsoft.com/default.aspx?scid=kb;en-us;257856
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: looking to Convert This PROCEDURE TO Dynamic SQL
Place to whole statement in your string and execute it.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Book by the Authors of this Site
http://www.sqlservercentral.com/bestof/
Meanwhile I have come to the conclusion, that the only book that's entirely worth reading is Inside SQL Server 2000 by Kalen Delaney. But that's just me.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: looking to Convert This PROCEDURE TO Dynamic SQL
Yes, Erland's article has a section on this
http://www.sommarskog.se/dynamic_sql.html#Dyn_DB
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Performance Issue w/ IF Exists
I might be flamed again
, but I think EXISTS will almost always be faster than using COUNT(*).But as Thomas already said, without...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Question About Transactions
It might be helpful to read nested transactions in BOL
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Report
Mabye Jonathan's reply here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=96509 will help you. There is also an example in BOL. Search for pivot table.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: RowGuid or Identity
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=12455
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=17329
Hope these links are of any value for you
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 2,731 through 2,745 (of 5,356 total)