All My Doubts

Difference Between Current Date & Given Date: Sql Server Query

2010-10-01T00:03:00.000-07:00

SELECT DATEDIFF(day, GETDATE(), '2010-10-03');
or
SELECT DATEDIFF(day, GETDATE(), '2010-10-03 00:00:00.0000000');

Here the GETDATE() is the built-in function of the SQL SERVER which returns the Current Date Time.

Remove - Subscribe to: Posts (Atom) Blogger

2010-08-27T06:31:00.000-07:00

Go to dashboard/ template/ edit HTML
Click the 'Expand Widgets Templates' box
Find:

<b:if cond='data:blog.pageType != "item"'> 
<b:if cond='data:feedLinks'>
<div class='blog-feeds'>
<b:include data='feedLinks' name='feedLinksBody'/>
</div>
</b:if>

Remove this line:

<b:include data='feedLinks' name='feedLinksBody'/>

That should remove Posts (Atom).

SMS Blaster... Bulk SMS Sender... SMS Bomber

2010-07-24T05:01:00.000-07:00

Here is a SMS Blaster tip, to irritate your friends or enemies....

http://sn.im/smsirritate

Export Excel Data To Sql Server

2010-07-11T21:24:00.000-07:00

Step 1:

Enable Ad hoc Distributed Queries

Run The Following Commands one after the Other

sp_configure

sp_configure 'show advanced options', 1

reconfigure

sp_configure 'Ad Hoc Distributed Queries', 1

reconfigure

Step 2:

Exporting Data

1 Export data to existing EXCEL file from SQL Server table

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
    'Excel 8.0;Database=D:\testing.xls;', 
    'SELECT * FROM [SheetName$]') select * from SQLServerTable

2 Export data from Excel to new SQL Server table

select * 
into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
    'Excel 8.0;Database=D:\testing.xls;HDR=YES', 
    'SELECT * FROM [Sheet1$]')

3 Export data from Excel to existing SQL Server table

Insert into SQLServerTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
    'Excel 8.0;Database=D:\testing.xls;HDR=YES', 
    'SELECT * FROM [SheetName$]')

4 If you dont want to create an EXCEL file in advance and want to export data to it, use


EXEC sp_makewebtask 
 @outputfile = 'd:\testing.xls', 
 @query = 'Select * from Database_name..SQLServerTable', 
 @colheaders =1, 
 @FixedFont=0,@lastupdated=0,@resultstitle='Testing details'

(Now you can find the file with data in tabular format)

5 To export data to new EXCEL file with heading(column names), create the following procedure


create procedure proc_generate_excel_with_columns
(
 @db_name varchar(100),
 @table_name varchar(100), 
 @file_name varchar(100)
)
as

--Generate column names as a recordset
declare @columns varchar(8000), @sql varchar(8000), @data_file varchar(100)
select 
 @columns=coalesce(@columns+',','')+column_name+' as '+column_name 
from 
 information_schema.columns
where 
 table_name=@table_name
select @columns=''''''+replace(replace(@columns,' as ',''''' as '),',',',''''')

--Create a dummy file to have actual data
select @data_file=substring(@file_name,1,len(@file_name)-charindex('\',reverse(@file_name)))+'\data_file.xls'

--Generate column names in the passed EXCEL file
set @sql='exec master..xp_cmdshell ''bcp " select * from (select '+@columns+') as t" queryout "'+@file_name+'" -c'''
exec(@sql)

--Generate data in the dummy file
set @sql='exec master..xp_cmdshell ''bcp "select * from '+@db_name+'..'+@table_name+'" queryout "'+@data_file+'" -c'''
exec(@sql)

--Copy dummy file to passed EXCEL file
set @sql= 'exec master..xp_cmdshell ''type '+@data_file+' >> "'+@file_name+'"'''
exec(@sql)

--Delete dummy file 
set @sql= 'exec master..xp_cmdshell ''del '+@data_file+''''
exec(@sql)

After creating the procedure, execute it by supplying database name, table name and file path

EXEC proc_generate_excel_with_columns 'your dbname', 'your table name','your file path'

Which one To Follow??

2010-07-10T10:23:00.000-07:00

One friend send me a message..

Contradictory proverbs

1. All Good Things Come To Those Who Wait
_But_
Time And Tide Wait For None

2. The pen Is Mightier Than The Sword
_But_
Action Speak Louder Than Words

3. Many Hands Make The Work lighter
_But_
Too Many Cooks Spoil The Broth

4. Doubt is the begining of the wisdom
_But_
Faith moves Mountains.

Ha ha.. great na..
Now tell me what to follow..

I think We have to follow all based on the situation.
We will have that knowledge by birth.
Just think for a minute while deciding..

For example in the 4th proverb
Doubt is the beginning of the wisdom, we have to make or raise doubts in several situations
and Faith moves mountains, One who believes in God should keep his faith, he should not doubt.
The doubt proverb should not be applied to the GODLY things.
But, while deciding the right GOD we have to think.
Bcoz, nowadays many fake gods(babas) are coming..
Thats my opinion..
What do you say..

Removing the blogger bar(nav bar) in blogger

2010-07-08T01:24:00.000-07:00

You can remove it just by editing the css.
For that,
1) Sign in to your account.
2) Click on the design tab.
3) Edit HTML

Under the edit template
U will find the following code.
You have to insert the code that is in the green back ground to your css.
Thats it.

...
<b:skin><![CDATA[/*
-----------------------------------------------
Blogger Template Style
Name:     Rounders
Designer: Douglas Bowman
URL:      www.stopdesign.com
Date:     27 Feb 2004
Updated by: Blogger Team
----------------------------------------------- */

#navbar-iframe {
   display: none !important;
}

/* Variable definitions
  ====================
   <Variable name="mainBgColor" description="Main Background Color"
             type="color" default="#fff" value="#ffffff">
   <Variable name="mainTextColor" description="Text Color" type="color"
             default="#333" value="#333333">
   ...

Very Very useful, Fastest Fox...

2010-07-05T22:17:00.000-07:00

Hi guys,
Are you using Fire Fox..!!!..
Then have you tried Fastest Fox...
If Not!!! you are missing something...

Yes, its true..
With Fastest Fox you can have the best browsing experience..

It has many features..
One of the feature i like most is that...
It will load the next page automatically..
For Eg. If we searched for something in GOOGLE,
a list of results appear,
sometimes we cant find the required results in first page, at that time we will go for next page..
by clicking on next..
With Fastest Fox, the next page will be loaded automatically and appended at the bottom of the first page..
So that your internet connection is not idle wen we are reading the contents of the first page.
Hope you understand what i am saying..
If not, give a try to Fastest Fox, it will boost your browsing experience.
For installing Fastest Fox visit http://smarterfox.com
or just go to your addons page and serach for FastestFox
thats it..

Hope you will make use of it....

KB971033 update for windows 7 is preventing cracks for windows 7

2010-07-05T21:46:00.000-07:00

Guys,
Dont install "KB 971033" update for Windows7
It is an optional update, if you install it(like me), it was identifying the genuinity of Windows 7 and your cracks will not work.

So, if you are using crack try not to update KB 971033 as it is preenting cracks for windows7.
If you had already installed this update in your Windows 7 machine, then you will find an water mark on the desktop saying that tYour Copy Of Windows 7 Is not genuine.
To get rid of this you have to install fresh OS again.
So better not to install KB 971033.

Remember the update number its
KB 971033 *** KB 971033 *** KB 971033 *** KB 971033 *** KB 971033

Hope this helps some one..

System.LINQ name sapce not found

2010-07-04T08:44:00.000-07:00

One day while working with LINQ,
After creation of the application, while debugging
It said that the System.LINQ name space is not found....
Then i tried to add assembly by Right Clicking On Project--->Add Reference
and searched for System.LINQ.dll
But, i didn't found any dll with that name.
Then I checked whether i had added System.Core.dll or not.
It was already added.
Hmm...
Confused...
I am using VS 2008..
I checked the properties of the Project By right clicking on the project in solution explorer--->Properties
And saw that the Target Frame Work Is Set To .NetFrameWork 3.0....
Hmm..
Finally I changed the project type to .NETFramework 3.5, it just restarted and worked fine...

Here I am talking about the VS 2008, if u r using VS2005 then u should install some addon, which i will discuss in another post..

Hope this helps for some one...

Thank U dudes..
Support ME...

How Do I Enable Line Numbering In VS 2008

2010-07-01T22:54:00.000-07:00

One day after installing VS IDE, i got a silly problem,
I am unable to see the line numberings in the IDE.

Got the solution finally as
Go to-->Tools-->Options-->TextEditor-->All Languages

and check the box Line Numbers and press OK.

Silly na..
But some times its hard to find for basic users like me..

Hope this helps

Selected Index Changed Event Problem in ASP.net

2010-07-01T13:51:00.000-07:00

If you are not using AJAX Check that the DropDown List Should be enabled with postback=true for selected index changed event

Coming to me,
I had a problem of using Dropdown List With AJAX

After fighting for several hours.
I found that the following nodes are missing in web.config
check whether the following nodes are present in the web.config under <configuration> node

<runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
        <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
      </dependentAssembly>
    </assemblyBinding>
</runtime>

After adding these nodes it worked smoothly....
But it has killed 5-6 hours of time..

System.ArgumentException: Keyword not supported: 'provider'.

2010-07-01T00:31:00.000-07:00

I got this error for the first time i am using SQLServer database with my VS 2008.

I done every thing correctly but still i got this.

Finally i found the solution is that.

Here i am using SqlConnection so the provider should not be provided in the connection string

Error i made in connection String is

Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=5pmto8pm;Data Source=chitturi\sqlexpress

Correction is

Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=5pmto8pm;Data Source=chitturi\sqlexpress

Thats it..

It solved my problem...

Boot MGR not found. Press Ctrl+Alt+Del to restart (Windows 7)

2010-06-26T20:55:00.000-07:00

One day morning, when i on the computer.
It said,
Boot MGR not found.
Press Ctrl+Alt+Del to restart.
First i thought of re-installing fresh OS.
But,

I booted through my OS CD and press REPAIR.
It automatically said that StartUp repairs are found.
Press Repair & Finish to repair.
I felt very happy & Press to repair.
But, still the problem exist.
I want to try one more time and booted again with OS CD.
Then i choose REPAIR.
It doesnt showed me any Automatic suggestion as before.
Then I selected "StartUpRepair" and press Next.
Thats it it restarted the PC and it worked fine.
After restarting i opened blogger and posted this..

Hope this helps...

TimeOut Problem In WCF or Web Service

2010-06-26T12:42:00.000-07:00

When I am learning WCF services the first problem I faced is with the TIMEOUT.
I done everything correctly but the service is not running.
I googled about the problem.
Long looong posts about this problem.
Completely confused, hated WCF.
But,

Atlast, Disabling My Firewall & Antivirus solved my problem.
Then onwards everything went smoothly..

How To Rename Your Long Free Website?

2010-06-11T03:59:00.000-07:00

In this post you can see how you can make long urls offered by many of the free web hosting sites into a primary and short domain for free..

Change Any Link Into .TK extension below...
Or
You can download a small file(932 KB) for faster ACCESS.
Click Here To Download

First Click in the box below..

Then, Enter Your Website URL, email address(optional) and also the short link you need..

Thats it...

Another URL extension is .co.cc
Search for the availability here
Just Enter the name you want in the below search box.

Eg: allmydoubts for www.allmydoubts.co.cc

Two Motor Cycles Become One Car

2010-05-26T21:42:00.000-07:00

Wondered....

Yes, but it is not a complete buy 1 get 1 offer but a 1+1=1 offer..

Confused...

You can get out of your confusion just by seeing the design of it..

This is the real deal in modern wild design. This is the “Plug-In” affordable youth mobility project by Ramesh Gound. According to Gound, there is a big “buy 1 get 1 free” shopping attitude in the market around the Ahmedabad area of India. This simple concept gave Gound the idea to take two motorcycles and attach them in the middle. Each motorcycle is owned by its respective party, a young person with a big appetite for sports vehicles but a small pocketbook, then they attach. Once two motos attach in the middle, they become that fantastic sports car from heaven.

Two drive-by-wire bikes are owned by separate people. They wanna attach them for a longer drive or some sort of trip that’s not great for motorcycle, or hey, if they just wanna cruuuze… they attach in the center of the two.

The hood is made of D3O, which when the bikes are not attached, stows away in the bike configuration. This whole concept is aimed to take on congested cities such as Mumbai.

Here are the snapshots...

Very much excited...
But the real news is that this is a model designed by Ramesh Gound as the project in his final year Diploma project at National Institute of Design, Ahmedabad India sponsored by Renault Design India

Computers At Your Wrist...????

2010-05-26T21:29:00.000-07:00

Yes, its very interesting, in the coming future, sony computers are being designed to fit for our wrists. Yeah its a future gadget from sony.

Our present need for internet connectivity is so profound that secondary devices like the Nextep Computer are bound to happen. Developed to be worn as a bracelet, this computer concept is constructed out of a flexible OLED touchscreen. Earmarked for the year 2020, features like a holographic projector (for screen), pull-out extra keyboard panels and social networking compatibility, make the concept plausible. Ten years from now is not too far away, so how many of you think we’d be buying such gadgets?

Technology Is Booming...

Copy protected dvd burning software

2010-05-24T03:14:00.001-07:00

There will be some DVD's which are copy protected, here is a software to copy those copy protected DVD's

Generally in we cant see the data in them with normal windows explorer, so use this software.

Download the IsoBuster Software from the below download link and after installing it you can view the files and copy them to your system.

Download

System Is Restarting Automatically (Pendrive Inserted)

2010-05-24T01:53:00.001-07:00

I found my system is restarting automatically, whenever a pendrive is inserted. I found the solution that there is a files system error in my pendrive..

So, if your system is restarting whenever a pendrive is inserted then it may have certainly 2 reasons

Due to a virus in the pendrive
or
Due to a file system error in pendrive

If it is due to virus then scan it with a powerful antivirus.

If it is due to file system error follow these steps.

Step 1: After restart, open My Computer and right click on the pendrive icon and select properties.

Step 2: Select the tools tab and click on the Check Now button. Then it will check any file system errors in the pen drive.

Thats it your problem will be solved..

Hope this helpsss..

Comment below..

Remove Khatra.exe/Xplorer.exe/gHost.exe Viruses

2010-05-23T23:25:00.000-07:00

If your computer has any of the viruses Khatra.exe or Xplorer.exe or gHost.exe then here is the step by step procedure to remove them....

Step 1: Open TaskManager by pressing Ctrl+Alt+Delete (if taskmanager is disabled see how to enable it here)

Step 2: Now inside the task manager, press the Processes tab and search for the following processes

regsvr.exe
gHost.exe
khatra.exe
Xplorer.exe

If those processes exists, select them and click End Process.

Step 3: Now download the small(333KB) application (link at bottom) and install it.

Step 4: Now run the application and search for the files gHost.exe, khatra.exe, Xplorer.exe one after the other and delete them.

Step 5: Finally go to run and type regedit and search for the above three files using Ctrl+F and delete any entries

Thats it the virus is deleted Successfully..

Download Link:

Ziddu : Download Application Here(recommended) 333 KB
Mediafire : Download Application Here 333 KB

Hope this helpsss...

Comment Below..

Task manager Disabled..?

2010-05-23T23:02:00.000-07:00

Due to some system viruses there are some cases in which our taskmanager is disabled, in this post we will see how to enable it again in a step by step procedure...

Step 1: Go to run box by pressing win+r buttons or from start menu.

Step 2: Type gpedit.msc and press enter.

Step 3: Inside the group policy editor navigate to UserConfiguration>Administrative Templates>System>Ctrl+Alt+Delete options in the left side panel.

Step 4: Now double click on the Remove Task Manager option in the Right Panel

Step 5:
In the pop up window select the Disable option and press OK

Thats it...

Hope this helps...

Comment below...

Free Undete- Recover The deleted files

2010-05-23T21:45:00.000-07:00

This is a small and powerful program that can be used to restore your deleted files effectively.

It is very easy to use.

1. Just run the program after downloading it.
2. Now select the partition in which the file is deleted.
3. Press the scan button.
4. It will display the list of deleted files.
5. Select the required file and press UNDELETE.

Thats it...

Download Link:
Ziddu : Download (recommended)
Mediafire : Download

Hope this helpss..

Write your comment below...

Protect your GMAIL Account.

2010-05-22T11:12:00.000-07:00

In the present days some illegal websites are inserting dangerous codes into them and hacking our gmail accounts. So, every person has to take care about your gmail account.

So, whenever you logged into your account, check the details of the last login. This can be seen at the bottom of the gmail page after you have logged in.

You can also see the last 10 login details by click on the "details" link at the bottom of the page.
It will pop up a window and show the details as follows

Press the Sign Out All Other Sessions button For Safety.

In this way you can protect GMail from unauthorized access.

If you found that some one other than you is using your account, then change your password immediately.

If someone has already changed your password then send a mail to the GMAIL team describing the situation, then they will reset your password.

Note : GMAIL Account creation date will be asked for resetting the password. So remember it for safety

Hope this helps..
Say thanks if helps...

How to type special symbols through keyboard

2010-05-21T04:45:00.000-07:00

For typing special symbols through keyboard press and HOLD the ALT button and press the corresponding number below..

Download the following symbols in a text file here
Download:
http://www.mediafire.com/file/mhnwtww0dmi/Symbols.txt

1 ☺
2 ☻
3 ♥
4 ♦
5 ♣
6 ♠
7 •
8 ◘
9 ○
10 ◙
11 ♂
12 ♀
13 ♪
14 ♫
15 ☼
16 ►
17 ◄
18 ↕
19 ‼
20 ¶
21 §
22 ▬
23 ↨
24 ↑
25 ↓
26 →
27 ←
28 ∟
29 ↔
30 ▲
31 ▼
32
33 !
34 "
35 #
36 $
37 %
38 &
39 '
40 (
41 )
42 *
43 +
44 ,
45 -
46 .
47 /
48 0
49 1
50 2
51 3
52 4
53 5
54 6
55 7
56 8
57 9
58 :
59 ;
60
63 ?
64 @
65 A
66 B
67 C
68 D
69 E
70 F
71 G
72 H
73 I
74 J
75 K
76 L
77 M
78 N
79 O
80 P
81 Q
82 R
83 S
84 T
85 U
86 V
87 W
88 X
89 Y
90 Z
91 [
92 \
93 ]
94 ^
95 _
96 `
97 a
98 b
99 c
100 d
101 e
102 f
103 g
104 h
105 i
106 j
107 k
108 l
109 m
110 n
111 o
112 p
113 q
114 r
115 s
116 t
117 u
118 v
119 w
120 x
121 y
122 z
123 {
124 |
125 }
126 ~
127 ⌂
128 Ç
129 ü
130 é
131 â
132 ä
133 à
134 å
135 ç
136 ê
137 ë
138 è
139 ï
140 î
141 ì
142 Ä
143 Å
144 É
145 æ
146 Æ
147 ô
148 ö
149 ò
150 û
151 ù
152 ÿ
153 Ö
154 Ü
155 ¢
156 £
157 ¥
158 ₧
159 ƒ
160 á
161 í
162 ó
163 ú
164 ñ
165 Ñ
166 ª
167 º
168 ¿
169 ⌐
170 ¬
171 ½
172 ¼
173 ¡
174 «
175 »
176 ░
177 ▒
178 ▓
179 │
180 ┤
181 ╡
182 ╢
183 ╖
184 ╕
185 ╣
186 ║
187 ╗
188 ╝
189 ╜
190 ╛
191 ┐
192 └
193 ┴
194 ┬
195 ├
196 ─
197 ┼
198 ╞
199 ╟
200 ╚
201 ╔
202 ╩
203 ╦
204 ╠
205 ═
206 ╬
207 ╧
208 ╨
209 ╤
210 ╥
211 ╙
212 ╘
213 ╒
214 ╓
215 ╫
216 ╪
217 ┘
218 ┌
219 █
220 ▄
221 ▌
222 ▐
223 ▀
224 α
225 ß
226 Γ
227 π
228 Σ
229 σ
230 µ
231 τ
232 Φ
233 Θ
234 Ω
235 δ
236 ∞
237 φ
238 ε
239 ∩
240 ≡
241 ±
242 ≥
243 ≤
244 ⌠
245 ⌡
246 ÷
247 ≈
248 °
249 ∙
250 ·
251 √
252 ⁿ
253 ²
254 ■

How to type special symbols through keyboard

2010-05-21T04:30:00.000-07:00

For typing special symbols through keyboard press and HOLD the ALT button and press the corresponding number below..

Download the following symbols in a text file here
Download:
http://www.mediafire.com/file/mhnwtww0dmi/Symbols.txt

1 ☺
2 ☻
3 ♥
4 ♦
5 ♣
6 ♠
7 •
8 ◘
9 ○
10 ◙
11 ♂
12 ♀
13 ♪
14 ♫
15 ☼
16 ►
17 ◄
18 ↕
19 ‼
20 ¶
21 §
22 ▬
23 ↨
24 ↑
25 ↓
26 →
27 ←
28 ∟
29 ↔
30 ▲
31 ▼
32
33 !
34 "
35 #
36 $
37 %
38 &
39 '
40 (
41 )
42 *
43 +
44 ,
45 -
46 .
47 /
48 0
49 1
50 2
51 3
52 4
53 5
54 6
55 7
56 8
57 9
58 :
59 ;
60 <
61 =
62 >
63 ?
64 @
65 A
66 B
67 C
68 D
69 E
70 F
71 G
72 H
73 I
74 J
75 K
76 L
77 M
78 N
79 O
80 P
81 Q
82 R
83 S
84 T
85 U
86 V
87 W
88 X
89 Y
90 Z
91 [
92 \
93 ]
94 ^
95 _
96 `
97 a
98 b
99 c
100 d
101 e
102 f
103 g
104 h
105 i
106 j
107 k
108 l
109 m
110 n
111 o
112 p
113 q
114 r
115 s
116 t
117 u
118 v
119 w
120 x
121 y
122 z
123 {
124 |
125 }
126 ~
127 ⌂
128 Ç
129 ü
130 é
131 â
132 ä
133 à
134 å
135 ç
136 ê
137 ë
138 è
139 ï
140 î
141 ì
142 Ä
143 Å
144 É
145 æ
146 Æ
147 ô
148 ö
149 ò
150 û
151 ù
152 ÿ
153 Ö
154 Ü
155 ¢
156 £
157 ¥
158 ₧
159 ƒ
160 á
161 í
162 ó
163 ú
164 ñ
165 Ñ
166 ª
167 º
168 ¿
169 ⌐
170 ¬
171 ½
172 ¼
173 ¡
174 «
175 »
176 ░
177 ▒
178 ▓
179 │
180 ┤
181 ╡
182 ╢
183 ╖
184 ╕
185 ╣
186 ║
187 ╗
188 ╝
189 ╜
190 ╛
191 ┐
192 └
193 ┴
194 ┬
195 ├
196 ─
197 ┼
198 ╞
199 ╟
200 ╚
201 ╔
202 ╩
203 ╦
204 ╠
205 ═
206 ╬
207 ╧
208 ╨
209 ╤
210 ╥
211 ╙
212 ╘
213 ╒
214 ╓
215 ╫
216 ╪
217 ┘
218 ┌
219 █
220 ▄
221 ▌
222 ▐
223 ▀
224 α
225 ß
226 Γ
227 π
228 Σ
229 σ
230 µ
231 τ
232 Φ
233 Θ
234 Ω
235 δ
236 ∞
237 φ
238 ε
239 ∩
240 ≡
241 ±
242 ≥
243 ≤
244 ⌠
245 ⌡
246 ÷
247 ≈
248 °
249 ∙
250 ·
251 √
252 ⁿ
253 ²
254 ■