Viewing 15 posts - 196 through 210 (of 254 total)
Dpends on what level you are at. There's sqlzoo.net for basic sql syntax. There's also w3schools.com. Best of all there's the Books On Line.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 10, 2005 at 9:53 am
insert into @t values ('a2')
insert into @t...
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 10, 2005 at 9:41 am
the order you have is pretty much right. You'd install all the SQL Serve and its components and its SP's first and then install RS followed by RS SP's.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 6, 2005 at 11:19 am
INSERT INTO @t1 ( contactid, fullname) VALUES (1, 'name1')
INSERT INTO @t1 ( contactid, fullname) VALUES (2, 'name2')
INSERT INTO @t1 ( contactid, fullname)...
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 6, 2005 at 10:10 am
you can use the SQL Profiler. or even the sp_monitor ...
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 6, 2005 at 10:01 am
and what result are you expecting back ?
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 6, 2005 at 9:59 am
can you post some sample data to give us an idea...
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 6, 2005 at 9:28 am
Is there any email for contacting you ?
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 4, 2005 at 3:53 pm
Usually when you want to concatenate columns you can do
SELECT
col1 + col2 + col3 AS OneColumn
FROM
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 3, 2005 at 9:43 pm
'ID, BI_number_BTC, European_product_number_new, Product_name_Supplier, Product_Name_german,
Product_name_english, Area_of_Application,...
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 3, 2005 at 9:22 am
SELECT
MAX(LEN([Name]))
FROM
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 2, 2005 at 8:58 pm
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
May 2, 2005 at 2:04 pm
you can use a User Defined Function to return a varchar value since stored procs only return INT type values.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
April 29, 2005 at 4:13 pm
I sent over an email. Please check it out.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
April 28, 2005 at 7:42 pm
Sounds good..Is there any email that you can be reached at ?
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
April 27, 2005 at 6:51 pm
Viewing 15 posts - 196 through 210 (of 254 total)