Question | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Question

1. I have 1 table "EmpTable" having 5 columns,2 indexes and 2 triggers.
I want to add new column to "EmpTable" at 3 position. How I can add the new column?
What is a flexible approch for this?
Table Structure is as follow EmpTable – col1 col2 col3 col4 col5 I want the structure as follow col1 col2 ColNEw col3 col4 col5
2.What is the difference between roles and groups 3. There are two set of user,running on two different set of procedures
How to give a permissions to user on procedures
Ex – Database DB1 having 100 procedures.
user1 uses 50 procedures out of 100 and
user2 uses remaining 50 procedures. 4. Database DB1 having 100 procedures.
Also there are 3 groups Gr1,Gr2 and Gr3
Gr1 have 2 user uses 50 procedures out of 100 and
Gr2 have 5 user uses remaining 50 procedures. But I want to add Gr1 & Gr2 to Gr3 so Gr3 can have the permission to all 100 Procedures.
How I can add Gr1 & Gr2 to Gr3. 5. How cache deadlocking is handle in stored procedures? 6. concept of @@TranCount 7. What is Nested transaction Plz give me some idea for all the above question.

Please don’t ask such many unrelated questions in one single thread! <br />It’s better to start several threads instead.<br />And it is even "more" better to search the site before asking such broad and general questions. [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />As for 1: There is no point in trying to add a column at a specific position. The only way is to use SSMS and that creates a new table behind the scenes. If you really need this position for whatever reason, create a view with the desired positioning and refer to the view.<br /><br />–<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
<<
Plz give me some idea for all the above question.
>> Do Article search in this forum Madhivanan Failing to plan is Planning to fail
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83089 Madhivanan Failing to plan is Planning to fail
quote:Originally posted by Madhivanan http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83089 Madhivanan Failing to plan is Planning to fail
At least there it was in the appropriate forum section posted. —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
As suggested take your time to search through the forums and this site in addition to updated books online for SQL server, it will get you more information on these basic questions you need such information. Don’t get us wrong that we suggest to review another set of publications, it is relevant and required when you need to know such an open based questions. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Check Books Online for most of your answers…. MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Looks like really getting started in sql…<br />Also the headline/topic should be questions instead of <s>question</s>[<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br /><br />Name<br />——— <br />Dilli Grg <br /><br />(1 row(s) affected)<br /></font id="code"></pre id="code">
at what step in a cursor where the query is execute?
Asif
For a better catchup why don’t you start a fresh thread instead of posting in irrelevant post. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Asif Ali</i><br /><br />at what step in a cursor where the query is execute?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Rarely you need Cursor in SQL Server [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Madhivanan</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Asif Ali</i><br /><br />at what step in a cursor where the query is execute?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Rarely you need Cursor in SQL Server [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />There is a good article here on the site by mmarovic about situations where cursors are an alternative.<br /><br />–<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Madhivanan</i><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Asif Ali</i><br /><br />at what step in a cursor where the query is execute?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Rarely you need Cursor in SQL Server [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />There is a good article here on the site by mmarovic about situations where cursors are an alternative.<br /><br />–<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Yes I agree. Thats why I specified the word <b>Rarely</b><br />Most newbies try to do the things using cursors only<br />If they are basically front end programmers, there is high chance that they want row-by-row operation for anything they want to do [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
]]>