I have 2 tables: t1 and t2. Each table contains a "city" column. In t1 some city names have additional remark closed between parentheses...
Yes, stuck as i mean it is "not responding" as you said.
And thanks for the answer, i'll try to follow what you write.
I'm not a DBA and i dont know much about it but i'm facing a problem for which i hope to get some aid here.
Our tables are nearly...
I try to operate a backup using the following code:
BACKUP DATABASE fiftyplus
TO DISK = 'Z:'
NAME = 'Full...
These are selected rows i try to delete. As i understand i must empty th log table first. I tried backing up the database but there i failed...
No, we dont have a DBA, I try to make it on my owv
Hi Satya. The table is made of 2500000 records. My delete command should delete about 50000 rows. Now the 1 million $ question: Where do i find that...
I try do delete records from my table but i dont manage to do it because any time i run the code i get an error message saying:
Thanks a lot !
oops.. it should be "status" instead of department...
My table in short looks like:
name status email
aaa vip aaa@aaa
bbb memeber bbb@bbb
There is no value such as 'No vip'. There are 'vip', 'member', 'candidate', 'left' etc...
What i want is: If the parameter is 'vip', to show...
I'd like to display the email addresses of those who are 'vip's or those who are'nt , depends on a variable. My code goes like:
Separate names with a comma.