15% CASH BACK WITH AIRTEL MONEY.

Dear all,

Airtel Money offer 15% cash back on First Transaction on airtel money min  rs. 20 and above. offer is only for New Users.

terms and conditions.

1. code can be used one time at first transaction.
2. minimum recharge value should be rs. 20
3. maximum cash back is rs. 50.
4. valid on airtel money app.


Promo Code : - NEW15

CLICK HERE TO RECHARGE.

ALTER TABLE IN MERGE REPLICATION.

To alter table in merge  replication follow the following steps.

1. first of all you can't alter replication table trough design view.

2.  to alter table run the following command at publisher

alter table table_name add column_name datatype

e.g. alter table abc add xy char(10).


Click Here For More Detail

REPAIR SUSPECT OR CORRUPTED SQL DATABASE IN SIMPLE WAY..

Due to some reason SQL Database to go in a suspect mode. When we connect to the database device going into offline. don't worry follow the following steps to recover your database.

for example your database name is ABC

1. Reset the flag of suspect database
2. Set the database to emergency mode so that it become read only and not accessible to other user.
3. Set the database to Single User Mode.
4. Repair the erros.
5. Set the database to multi user mode so that it can be accessed by other user.

CONSIDER ABC IS USER DATABASE NAME.

first of all execute the following store procedure to reset the flag.

1. exec sp_resetstatus 'ABC'

Then execute the following SQL COMMAND  to set EMERGENCY MODE.

2. ALTER DATABASE ABC SET EMERGENCY\

SQL COMMAND FOR SET SINGLE USER MODE.

3. ALTER DATABASE ABC SET SINGLE_USER WITH ROLLBACK IMMEDIATE

REPAIR THE ERROR WITH FOLLOWING COMMAND.

4. DBCC CHECKDB ('ABC',REPAIR_ALLOW_DATA_LOSS)

SET THE DATABASE TO MULTI USER MODE.

5. ALTER DATABASE ABC SET MULTI_USER.

ABOVE IS THE SIMPLE METHOD TO REPAIR SUSPECT OR CORRUPTED DATABASE.


ANY QUERY THEN MAIL ME.

ERROR STDOLE32.tlb IN EXCEL.

hello friends,

many times you may also face the problem in excel stdole32.tlb when you start the excel. my today's post about that onel

here find the solution of STDOLE32.tlb in excel.


Steps for resolve the problem of STDOLE32.tlb.

1. remove excel from your pc.
2. restart your pc.
3. Open registry (type regedit on run)
4. remove excel manually from following location.
 
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\8.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\9.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\10.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\11.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\EXCEL (RIGHT CLICK AND DELETE THE KEY)

AFTER THAN REMOVE FROM FOLLOWING LOCATION ALSO.

4. ---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\8.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)

---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\9.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\10.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\11.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL (RIGHT CLICK AND DELETE THE KEY)
---- >  HKEY_CURRENT_MACHINE\SOFTWARE\MICROSOFT\OFFICE\EXCEL (RIGHT CLICK AND DELETE THE KEY)

CLOSE REGEDIT.

your problem resolved.

star excel and you find that there is no error about stdole32.tlb.

GET RS. 50 CASH BACK ON VODAFONE POSTPAID

Dear all,

Paytm offer rs. 50 cash back on postpaid recharge of rs. 500 and above. offer is only for vodafone users.

terms and conditions.

1. code can be used upto 5 times.
2. one number can be recharged upto 5 times.
3. offer is valid only for vodafone postpaid users.
4. valid on web and app.


Promo Code : - VODA500

CLICK HERE TO RECHARGE.

Get 22.5% cash back on paytm.

Paytm  gives 22.5% cash back on DTH Recharge if you are never sign in on paytm.

Get rs. 225 cash back on DTH  recharge of rs. 1000 and above.

Read More....

1. Code can be used one times.
2. valid for new users.
3. valid for all payment methods.
4. valid only for DTH.
5. valid on web and app.


Promo code:- D2HNEW


D2H RECHARGE HERE !!!

Get upto rs. 625 cash back on DTH Recharge.

Paytm gives upto rs. 625 cash back on DTH Recharge. then why you wait for last date recharge your DTH and enjoy cash back.

Get rs. 125 cash back on recharge of rs. 1000.

Terms and Conditions :

1. code can be used upto 5 times.
2. valid only for DTH.
3. valid for all users.
4. valid on web and app.
5. valid for all payment modes.

Promo Code:- DTH1000


Recharge Here DTH

Get Rs. 40 cash back.

Paytm offer 10% cash back on recharge of rs. 400 and above.

Its means Get rs. 40 cash back on prepaid recharge of rs. 400 and above.

to avail this offer read the terms and conditions.

1. a number can be recharged upto 5 times.
2 offer is valid for all users.
3. offer is not valid for airtel prepaid users.
4. valid on web and app.
5. code can be used upto 5 times per user.


Promo Code:- PREPAID400


Click Here to Avail this Offer.

GET 20 % CASH BACK ON DTH.

Get 20% cash back on min DTH Recharge of rs. 200 and more.

terms and condition as follow:

1. offer is not valid on airtel dth.
2. offer is valid upto 16-oct,.
3. maximum cash back is rs. 100.
4. offer is valid one time per user.


PROMO CODE:- DT20

GET RS. 50 +25 CASH BACK ON FREECHARGE. (NEW USER)

Free charge offer rs. 50+25 cash back offer.

Terms and conditions as follow:

1. Offer is valid only for new user.
2. Rs. 50 cash back on recharge of min rs. 50.
3. Maximum cash back is rs. 50
4. Offer is not valid for airtel user.
5. After completion his/her first transaction on free charge user will get SMS and email with extra rs 25 unique code for next recharge.

offer is valid upto 13 -oct.

PROMO CODE:- PCFC50

RS. 50 CASH BACK ON PAYTM (NEW USER).

Get rs. 50 cash back on recharge of rs. 50 and above. the offer is valid only for new user.

Promo Code :- NEW50.

mobile number and email id should be verified to avail this offer.

Click Here to Grab

GET 100% CASH BACK ON FREECHARGE.

Now you can get 100% cash back with freecharge if you are a new user on freecharge.

Promo Code:- HI50

1. OFFER IS NOT VALID FOR AIRTEL CUSTOMER.
2. MINIMUM RECHARGE AND BILL PAYMENT OF RS. 50.
3. MAXIMUM CASH BACK . RS 50 



Click Here To Get Cash Back

Get 20% cash back with Freecharge.

Freecharge gives 20 % cash back on prepaid , postpaid and dth recharge.

to get 20% cash back follow the following steps.


On Prepaid Recharge : 

1. offer is not valid for airtel customers.
2. minimum recharge amount 150.
3. offer is valid till 15-Oct.
4. Maximum cash back rs. 100.
5. offer is valid for all users.
6. offer is valid on web and app.


Now Promo Code : - PP20


On Post Paid Bill:

1. offer is not valid for airtel customers.
2. minimum recharge amount 400.
3. offer is valid till 15-Oct.
4. Maximum cash back rs. 100.
5. offer is valid for all users.
6. offer is valid on web and app.


Now Promo Code : - PO20

On DTH Recharge

1. offer is not valid for airtel customers.
2. minimum recharge amount 200.
3. offer is valid till 15-Oct.
4. Maximum cash back rs. 100.
5. offer is valid for all users.
6. offer is valid on web and app.


Now Promo Code : - DT20.



Click Here To Recharge Now !!!

Rs. 50 cash back on DTH Recharge of rs. 500

Paytm user can get 50 rs. cash back on dth recharge of rs. 500 and above.

apply promo code : D2H500

Above mention promo code can be used five times per user.

Valid for all users.

Valid only for DTH Recharge.

valid for all users.

valid on Web and App.

if you are new user then you can get 100 rs cash back on dth recharge of rs. 500 and above.

promo code : DTHNEW.

VALID ONLY FOR ONE TIME.
VALID ONLY FOR NEW USER.
VALID ONLY FOR DTH RECHARGE.
VALID ON WEB AND APP.
VALID FOR ALL PAYMENT METHOD..


Recharge Now !

HOW TO PASS TABLE NAME IN SQL

Find the procedure to pass table as parameter and execute in sql.


declare @tblnm nvarchar(max)             --- declare parameter for select query
declare @tab nvarchar(max)                   -- pass table name
declare @para1 nvarchar(max)              -- pass parameter for where condition.


set @tblnm='select * from ' +@tab    + ' where col_1 ' + @para1    ----- set the query in parameter

exec sp_executesql @tblnm                    ----execute sql within store procedure.

ENJOY PAYTM END OF MONTH OFFER.

find the latest paytm offer for recharges and payment.

paytm give cash back with his end on month offer.

1. Promo code:-  EOM100.
GET RS 15 CASH BACK ON RECHARGE AND BILL PAYMENT OF RS. 100 AND ABVOE.
Terms and condition for used above promo code as follow:
1. number can be recharged five times.
2. code can be used upto five times.
3. Offer is not valid for airtel prepaid recharge.
4. offer is valid for all users.
5. offer is valid on app as well as on web.
6. limited period offer.
2. Promo code:- EOM400.
Get rs. 50 cash back on recharge and bill payment of rs. 400 and above.
terms & Conditions.
1. number can be recharged upto 5 times.
2. code can be used upto 5 times.
3. offer is not valid for airtel prepaid recharge.
4. offer is valid for all users.
5. offer is valid on app as well as on web.

click here for recharge !!

NEW CASH BACK OFFER FOR AIRTEL POSTPAID USER.

New paytm offer for airtel postpaid user only.

get rs. 40 cash back on rs. 400 or more on airtel postpaid recharge.

Promo code :- AIRTEL400.

TERMS AND CONDITIONS :

1. code can be used upto 5 times.
2. one number can be recharge for 5 times.
3. only for airtel postpaid users.
4. applicable on web and app.
5. minimum recharge amount 400.


so recharge with paytm and enjoy cash back.

Click here to Recharge !!!!

CASH BACK (up to 200) OFFER FOR AIRTEL PREPAID USER (

Good News only for airtel prepaid user. paytm offer 4% cash back for airtel prepaid users on recharge of rs. 30 or more.

promo code:- AIRTEL4

Terms and conditions as follow:

1. code can be used 5 times by one user id.
2. one number can be recharged 5 times.
3. cash back rs. 200 maximun.
4. valid on web as well as on app.
5.  offer is valid only for airtel prepaid users.

So recharge with paytm and enjoy cash back.

Click Here to Recharge !!!

Celebrate Ganesh Chaturthi with paytm. (15% cash back)

celebrate your Ganesh Chaturthi this time with paytm.

Paytm offer 15% cash back on recharge / bill payment of rs. 100 or more.

promo code :-  GANPATI

Terms and conditions as follow:

above mention code can be used five time per user.

number can be recharge up to five times.

Note:- airtel prepaid recharge is not applicable on this promo code.

www.paytm.com

Join and Earn Online.

Hello Everyone,

sorry for not posting any new post for you.

today i have post for you my friends,

Now you can earn money online. This is best PTC Website and secure for earning money just watching ads and need not to invest.

you need to just spent 15 to 20 minutes on the site and click on adds to earned. in a day you can earn from 8 to 10 cent and even 2 doller in a day through grid. so friends join the site and start earning today.



Click to Join Now !!!!


Invest to join : -      0 $
Minimum payout :- 2 $