sorry for the above go the database and then security and there u can set the deny or grant for alter or view

u have to set the permission for object by using the managaement option and set the permission for other user. let me know if need any things

ex a-zA-Z0-9 the above pateern will accecpt only value in betwwn them for other they will return for presence of special character . plz check it

use this statement select * from sys.triggers which will return all the trggername list

use patindex function to find out the column with special character .

'34523@#$@%^@^' how can i find that above value contain special character in sqlserver 2005

for sqlserver 2005 use unpivot method

sorry for the above reply use this select coumun1,column2 from table1 where column2 is not null union all select coumun1,column3 from table1 where column3 is not null union all select coumun1,column4 from table1 where column4 is not null here for three column u have to write for all column

select column1,convert(varchar(20),isnull(column2,''))+''+convert(varchar(20),isnull(column3'')) as coluumn2 from tablename use the above query and write like above for all the ingredent column . lets me know if any things is needed.

ITS GOOD BUT THE RESULT IS NOT SO DESIREABLE . BECAE WHEN I PASS 5 THEN ITS NOT GINGING THE PROPER RESULT I NEED A DYNAMIC FUNCTION FOR ANY INPUT VALUE EX .FOR 5 1 ,1 TIMES 2 2 ,2 TIMES 3 3 3 ,3 TIMES 4 4 4 4 ,4 TIMES 5 5 5 5 5 ,5 TIMES I NEDD LIKE ABOVE

u should use command builder to save or update which will generate command dynamically insert for new and updated for existance.

select count(*),userid,username from temptable where username ='Bob' and score > 20 group by userid,username union select 0,userid,username from temptable where username ='Bob'and score < 20 group by userid,username

one thing between two table should have delete cascading on master table . then u can use delete from mastertable where id = select top 1 id from (select max(id) as id from master a join detail b on a.id=b.id )as a

select count(*),userid,username from template where username ='Bob'and score > 20 group by userid,username

you should used cross tab report type . it will available when u will add the report in own solution explorer. lets me know if any things is needed.

i think u should try it , its possible in sqlserver . so dont laugh ,but try it.

both

1 2 2 3 3 3 4 4 4 4 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 9 here the 1 printed after 8 spaces 1 times here 2 printed after 7 spaces 2 times . and so on .

how can i select excel data into sqlserver by using the query.

1 2 2 3 3 3 4 4 4 4 5 5 5 5 5 6 6 6 6 6 6 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 9