Viewing 15 posts - 1,771 through 1,785 (of 2,007 total)
Kindly let me know how do i
1.Code the stored procedure
2.pass the required variables for the SP
So that,
I may get the recordset something like this : (Order by too)
Sorry Girish...
November 9, 2011 at 12:31 am
Julian Milano-440574 (11/8/2011)
November 9, 2011 at 12:23 am
Right Click on the database >> Tasks >> Generate Scripts >> on the select objects select "users" >> script to new query window.
This should assist you in generating a script...
November 9, 2011 at 12:12 am
in this query,every select has order column,mens if i do order by 1,5,it will dislay result of a select stm who has 1 as order then 2 and so on
where...
November 8, 2011 at 11:47 pm
strSELECT -- SELECT columns
strFROM -- From Table(s) with JOIN
strWHERE -- Filters
strGROUP_BY -- if Any
strHAVING -- if Any
strORDER_BY -- If Any
strSQL= strSELECT + strFROM + strWHERE + strGROUP_BY + strHAVING +...
November 8, 2011 at 11:33 pm
Is there a reason why referencing another server in my domain won't work using "FROM [servername].[dbname].[owner].[tablename]"?
Two reasons:
1) Because you are not connected to another Server. Even if you have...
November 8, 2011 at 11:26 pm
With me, you wouldn't get to face to face, nor phone screening, nor even an e-mail.
Only 1 chance for the first impression!
I am sorry, I disappointed you. :unsure:
November 8, 2011 at 8:45 am
Just a ps, you're signature seems a little needy (like an sos).
I didn't get it (SOS).
That would turn me off as an employer.
I will say "It would be...
November 8, 2011 at 8:24 am
Waste hurts because that's what you're doing and against what you want.
I don't waste time not working because in a single click I can contact EVERY recruiter / job HR...
November 8, 2011 at 7:59 am
Processing a SELECT Statement
The basic steps that SQL Server uses to process a single SELECT statement include the following:
1. The parser scans the SELECT statement and breaks it into...
November 8, 2011 at 7:44 am
How long do you plan to waste before finding what you want?
First, I will never say it waste... I would rather say invest. Waste hurts.:crying:
I've never been jobless more than...
November 8, 2011 at 7:22 am
Thanks Gail but the part that I didn't find was parser. I corrected my understanding on compilation immediately when I found compilation articles.
Thanks again!
November 8, 2011 at 7:14 am
I'm not saying you're spamming. I'm saying that bots that collect e-mails will start sending YOU spam.
I don't have any option except to accept this spam.
Have you started a thread...
November 8, 2011 at 7:08 am
Viewing 15 posts - 1,771 through 1,785 (of 2,007 total)