thanks Gazareth =)

sorry

error codes have the following

Would you look at

Msg 102, Level 15, State 1, Line 8

Incorrect syntax near ')'.

error and

max(avg_sal) --> invalid column name

select *

from personel

where maas = (select max(avg_sal)

...

thanks a lot =)

thanks..Only the highest average salary(maas) = (800).. I want to show

eg.

Sicil ad soyad adres ...

I have my table here.((quote))

and I just want to show what salary(maas) = 800

maas(salary) = 800 ==> max avarege salary(maas)

--------------

I need a code but it really does not work like...

i find script 😎

Use test

GO

sp_rename 'PK1', 'PK2', 'OBJECT'

GO

thanks...i just started to sql

I do not know how to.

and

I tried these codes:

USE test

GO

EXEC sp_rename N'tablo1.PK1', N'PK2', N'a1';

GO

but gives an error message

Msg 15249, Level 11, State 1, Procedure sp_rename, Line...

thank you very much.

renaming table name success 🙂

but

--i dont renaming a column

Use test

GO

sp_rename 'tablo4','d1','d11'

GO

just started to sql

Can you write code

thanks.

thanks

sorry deleted now

thanks a lot

yes:-)thanks you very much.

How to delete the filegroup

ALTER DATABASE test

REMOVE FILEGROUP testgrup3

GO

DONT DELETE:exclamationmark:

It gives this error 🙁

Msg 102, Level 15, State 1, Line 199

Incorrect syntax near 'MODIFY'.

thank you very much 🙂

i write this scripts.and i got these files (test3.ndf and test4.ndf) (testgrup2) FILEGROUP

and i want to connect these files (test3.ndf-test4.ndf) to testgrup2 FILEGROUP.

thanks 🙂