how to make the tables are empty?
how to make the tables are empty?
in the database:
dbo._refpricepolicyofitem
dbo._refscrapofpackageitem
dbo._refshopgoods
dbo._refpackageitem
BECAUSE ANY INSERT-VALUES THAT I HAVE A media.pk2
NOTE: When you put the command to erase the lines and columns makes erased, but when I open them again filled with other lines appear ..:grr:
If you tell me how to put them to zero would appreciate it.
Thanks before hand.
Re: how to make the tables are empty?
what db u use !! Staticc DB !!
Re: how to make the tables are empty?
DB PERFECTION PVP
I truncate the vacuum with but when you open them again appears again what was in that dbo.
and besides I need to insert the primary command if you have not found any export tables of q put media.pk2 could say?
http://www.image-share.com/upload/1411/75.jpg
It achieves these tables empty but I can not insert the lines because I have the main command .. I want to add what I found in the perfection media.pk2 of new
Re: how to make the tables are empty?
Try to replace in sql code "RefPackageItem" to "_RefPackageItem"
Re: how to make the tables are empty?
I had not fixed by now if I served, I added the lines but not all lines of 2000 only 200 thousand, has no idea how I can do to add them all insert attempt?
excuse my English
Re: how to make the tables are empty?
can you upload all sql code?
Re: how to make the tables are empty?
not only load 200 lines
and there are actually over 200.
I notice it only loads the sql as 200 lines could do not have limits? use the sql 2008
when I go to edit says:
Edit top 200 Rows , know how to set to have no limit?
Re: how to make the tables are empty?
Tools >>>> Options >>>> Select " SQL Server Object Explorer
and in right window u will find
Value for Select Top <n> Audit records corr "200" Change 200 to 1000000
and
value for Edit Top <n> Rows command "200" Change to 1000000
value for select top <N> Rows command "200" Change to 1000000
Re: how to make the tables are empty?
hello man
add this line for code
USE [SRO_VT_SHARD]