this worked for me

SELECT spr.name AS ProcedureName,SUBSTRING(sd.definition,

CHARINDEX('n:',sd.definition)+2, 45)AS Definition, spa.name AS

ParameterName, st.name AS ParameterType, spa.max_length, spa.is_output

...

i am adding description on SHIFT+CONTROL+M

here is sample

-- =============================================

-- Author:Myname

-- Create date: 18 oct

-- Description:Display city list

-- =============================================

ALTER PROCEDURE procName

@Error INT OUTPUT

AS

BEGIN

--select query

END

I tried like this

select R.rolename,P.canRead,P.canWrite,P.canDelete,M.Id,M.DisplayName from role R,rolesPermissions P,tbl_be_Modules M where M.Id=P.ModuleId and R.roleID=P.roleId

I suggest you to encript and decript on application side.....

here is example how to do in C#

private string EncodePassword(string password)

...

All of you are informed that my requirements have been changed and for ease and clearness i created another post here

Please visit here and help me.i want to close this...

AD7 (1/4/2012)

---

This looks like hierarchical or "tree structured" data.

The following query can be used to extract hierarchical or "tree structured" data.

/** setup data **/

declare @table table (ID int, PID...

WITH tbl_be_modules (parentid)

AS

(

SELECT DISTINCT parentid FROM tbl_be_modules

)

SELECT

T.Id,

STUFF((

...

If sys.columns is table name(as i have single table)...then i do have two ids,one is Id and other is PID(parentID).so what do you mean by object_id?please differentiate PromeryKey Id which...

i know that sys.tables is Mytable name but what is sys.columns C

WHERE C.object_id =...

Ninja's_RGR'us (1/4/2012)

---

Here's a demo with the system tables, adjust to your own needs.

SELECT

T.name,

STUFF((

SELECT

...

@ninja's_RGR'us:

Your suggestion is very complecated for me...let me try @ken McKelvey comment

GSquared (12/21/2011)

---

engrshafiq4 (12/20/2011)

---

Sorry for your confusion.

i am asking SSC Eights!

He correct my code in his above post.and that worked for me.

Let me explain the issue

consider i have a table

CREATE TABLE...

Dev (12/21/2011)

---

Koen Verbeeck (12/21/2011)

---

Tsk tsk tsk, Hall Of Fame, is that the christmas spirit?...

Sorry for your confusion.

i am asking SSC Eights!

He correct my code in his above post.and that worked for me.

Let me explain the issue

consider i have a table

CREATE TABLE [dbo].[Cities](

[CITY] [nvarchar](40)...

@SSC:

Good,this worked fine for me,now the only issue is i need checks now.

For example i want to have first column of integer data and second must not be null and...