HI U CAN ALSO USE THE FOLLOWING CODE.,
IT WILL DISPLAY ALL THE USER TABLES......
select TABLE_NAME from information_sch ema.tables...
Anu139
Last Activity: Dec 7 '06, 07:14 AM
Joined: Nov 2 '06
Location:
-
I got the answer
declare @name varchar(50)
select @name = coalesce( @name,'' )+ col1 from tab_name
select @name 'Name'...Leave a comment:
-
hi all,
i got the answer for this.
declare @name varchar(50)
select @name = coalesce( @name,'' )+ col1 from tab_name
select @name 'Name'...Leave a comment:
-
Please any one try to solve this. its Interesting.
the table is
col1
---------
M
S
S
Q
L
The expected Result is
Name
-----------
MSSQL
I need a single query which solves the above problem. please help me out? -
Hi,
your question is not very clear to me. i have assumed the problem in a following way, and i hope it is correct. If not please get back with a correct problem statement.
if u have any other column in ur table like emp_ID, emp_name.. etc,,, with reference to tat column u can update the salary column of a particular record.
for example:
update tab_name set salary= salary+(0.05*sa lary) where emp_ID=123445
...Leave a comment:
-
hi,
just go through all the commands available in SQL server books on line, which is available with all MS SQL server installation, and try 2 learn urself best.. any way the answer is
INSERT INTO tab_name Values('MSSQL', 134)
if u r inserting varchar values enclose data between two single quotes like 'MSSQL"
if it is Numeric values write as it is like 14, 78.9 etc etc
regards,...Leave a comment:
-
hi,can u please tell me, do u want to delete a column or a row? if u really want to delete a row whose FinancilaPeriod Month value is ThisYearMonthEn d10. u can use the following statement
delete from tblMarketing where FinancilaPeriod Month = 'ThisYearMonthE nd10'
I hope i understood ur problem correctly....Leave a comment:
-
query to find a sum of char values present in different rows
the table is
col1
---------
M
S
S
Q
L
The expected Result is
Name
-----------
MSSQL
I need a single query which solves the above problem. please help me out?
No activity results to display
Leave a comment: