Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 55
Search took 0.01 seconds.
Search: Posts Made By: Lalit_Pratihari
Forum: SQL Server 2000 July 15th, 2006, 07:27 AM
Replies: 1
Views: 1,440
Posted By Lalit_Pratihari
TimeOut Expired

Hi,

Problem: There are 4 SPs. When I execute the SPs using Connection object in VB6 it runs fine both in local and remote server.

But when I generated a SQL script (hence I have removed the...
Forum: SQL Server 2000 January 12th, 2006, 12:09 PM
Replies: 5
Views: 10,262
Posted By Lalit_Pratihari
Hi, Or alternatively you can use this one: ...

Hi,

Or alternatively you can use this one:

SELECT @VNextID = CASE
WHEN [ID] IS NULL THEN 1
ELSE [ID] + 1
END
FROM InXn
Forum: SQL Server 2000 January 12th, 2006, 11:07 AM
Replies: 1
Views: 2,921
Posted By Lalit_Pratihari
Hi, First, for registering a component into...

Hi,

First, for registering a component into your system you should have administrative rights.

Secondly, If you have SQL server installed in your machine (local) then right click the server on...
Forum: SQL Server 2000 January 12th, 2006, 10:41 AM
Replies: 2
Views: 2,241
Posted By Lalit_Pratihari
Hi, Could you please elaborate your problem...

Hi,

Could you please elaborate your problem a lit bit...

You want to copy the .bak file from client application or you want to write a SP to handle the copy.

Lalit
Forum: SQL Server 2000 January 10th, 2006, 11:47 AM
Replies: 2
Views: 2,845
Posted By Lalit_Pratihari
Hi, I have simulated your problem and here...

Hi,

I have simulated your problem and here is the scenario I have created and hope this will help.

USE NORTHWIND

CREATE TABLE USERS
(USERID INT, USERNAME VARCHAR(20))

CREATE TABLE...
Forum: SQL Server 2000 September 30th, 2004, 08:16 AM
Replies: 2
Views: 1,171
Posted By Lalit_Pratihari
Hi, Alternatively you can link the remote...

Hi,

Alternatively you can link the remote server to your local server.
In SQL server you can link the remote server through:

EXEC sp_addlinkedserver 'SEATTLESales', N'SQL Server'

Thanks,
...
Forum: SQL Server 2000 September 30th, 2004, 08:05 AM
Replies: 3
Views: 1,237
Posted By Lalit_Pratihari
Hi, You will have to use EXEC or EXECUTE...

Hi,

You will have to use EXEC or EXECUTE statements for dynamic table names.

Thanks,

Lalit
Life Means More...;)
Forum: SQL Server 2000 September 30th, 2004, 08:01 AM
Replies: 5
Views: 1,428
Posted By Lalit_Pratihari
Hi, In place of char, varchar is a better...

Hi,

In place of char, varchar is a better option. I mean in that way you need not have to truncate the value everytime.

Thanks,

Lalit
Life Means More...;)
Forum: SQL Server 2000 September 30th, 2004, 07:51 AM
Replies: 15
Views: 3,604
Posted By Lalit_Pratihari
Hi, For AutoIncrement IDENTITY, IDENTITY...

Hi,

For AutoIncrement IDENTITY, IDENTITY SEED is a very good option.

Thanks,

Lalit
Life Means More... ;)
Forum: SQL Server 2000 September 30th, 2004, 07:41 AM
Replies: 3
Views: 1,154
Posted By Lalit_Pratihari
Hi, Alternatively you can also try this out...

Hi,

Alternatively you can also try this out in SQL server:

--To extract the duplicate rows
SELECT COL1, COL2, COUNT(*)
FROM DUP_ROWS
GROUP BY COL1, COL2
HAVING COUNT(*) > 1
Forum: SQL Server 2000 September 30th, 2004, 07:29 AM
Replies: 2
Views: 1,066
Posted By Lalit_Pratihari
Hi, Alternatively, you can give an alias to...

Hi,

Alternatively, you can give an alias to your query and again full outer join to Data table on month.

Thanks,

Lalit
Life Means More...;)
Forum: SQL Server 2000 September 30th, 2004, 07:23 AM
Replies: 6
Views: 1,779
Posted By Lalit_Pratihari
Hi, Yes you can join a table with a function...

Hi,

Yes you can join a table with a function that returns a table.

The only think you will have to take care of is to give a proper alias to the function while joining.

Thanks,

Lalit...
Forum: SQL Server 2000 September 30th, 2004, 07:16 AM
Replies: 3
Views: 3,612
Posted By Lalit_Pratihari
Hi, You can very well see the length you...

Hi,

You can very well see the length you have defined for the column and the value you are inserting.

You will have to increase the size of your column.

Thanks,

Lalit
Life Means More...;)
Forum: SQL Server 2000 September 30th, 2004, 07:11 AM
Replies: 5
Views: 5,430
Posted By Lalit_Pratihari
Hi Anant, I have worked on ur given example...

Hi Anant,

I have worked on ur given example but it is not working.
Could you please suggest us a better way.


Thanks,

Lalit
Life Means More...;)
Forum: Beginning VB 6 September 30th, 2004, 06:56 AM
Replies: 1
Views: 761
Posted By Lalit_Pratihari
Hi, Why dont you search for the file in the...

Hi,

Why dont you search for the file in the Google search engine. It may help.


Thanks,

Lalit
Life Means More...;)
Forum: Beginning VB 6 September 30th, 2004, 06:55 AM
Replies: 1
Views: 912
Posted By Lalit_Pratihari
Hi, Have you used the same hotkeys...

Hi,

Have you used the same hotkeys combination in any of the buttons on the child form.

Thanks,

Lalit
Life Means More...;)
Forum: VB How-To September 30th, 2004, 06:46 AM
Replies: 1
Views: 1,016
Posted By Lalit_Pratihari
Hi, Just use: Test1.ScrollBars = 3 ...

Hi,

Just use:

Test1.ScrollBars = 3

Thanks,

Lalit
Life Means More...;)
Forum: VB How-To September 30th, 2004, 06:41 AM
Replies: 1
Views: 814
Posted By Lalit_Pratihari
Hi, You can use CAST() or CONVERT() function...

Hi,

You can use CAST() or CONVERT() function of SQL server.


Thanks,

Lalit
Life Means More...;)
Forum: VB How-To September 30th, 2004, 06:37 AM
Replies: 1
Views: 1,528
Posted By Lalit_Pratihari
Hi, No the Alignment property not only...

Hi,

No the Alignment property not only affects the text in column header, it also affects the text in the columns in a ListView.

Just try it out.

Thanks,

Lalit
Life Means More...;)
Forum: VB How-To September 30th, 2004, 06:32 AM
Replies: 3
Views: 1,214
Posted By Lalit_Pratihari
Hi, You can use the MAPI Object to send...

Hi,

You can use the MAPI Object to send mails from VB.

Thanks,

Lalit
Life Means More...;)
Forum: VB How-To September 30th, 2004, 06:29 AM
Replies: 1
Views: 1,573
Posted By Lalit_Pratihari
Hi, Use VBA. Create an excel object,...

Hi,

Use VBA. Create an excel object, navigate through the cells and wrtie them in a text file as comma separated values using FileSystemObject.

Thanks,
Lalit

Life Means More...;)
Forum: VB How-To September 30th, 2004, 06:21 AM
Replies: 2
Views: 7,840
Posted By Lalit_Pratihari
Hi, You can simply use this code: ...

Hi,

You can simply use this code:

Button_Name.Enabled = False

Thanks,

Lalit
Life Means More...;)
Forum: VB How-To September 30th, 2004, 06:19 AM
Replies: 2
Views: 1,124
Posted By Lalit_Pratihari
Hi, You can create a XML file through VB by...

Hi,

You can create a XML file through VB by executing the following script:

Dim Conn as new ADODB.Connection
Dim Rs as new ADODB.Recordset

Set Rs = Conn.Execute("SELECT * FROM TABLE_NAME")...
Forum: VB How-To September 30th, 2004, 06:08 AM
Replies: 2
Views: 1,695
Posted By Lalit_Pratihari
Hi, Yes you can use a MaskEdit Control or if...

Hi,

Yes you can use a MaskEdit Control or if you want to do it in a Textbox only then you can use the MID() function.

Dim HH as String
Dim MM as String
Dim SS as String
Dim MyTime as String...
Forum: VB How-To September 30th, 2004, 06:00 AM
Replies: 2
Views: 949
Posted By Lalit_Pratihari
Hi, You can copy the SQL statements in a...

Hi,

You can copy the SQL statements in a text file and then can execute the SQL statements through VB by using FileSystemObject.

Keep on concatenating the SQL statements in a string and when...
Showing results 1 to 25 of 55

 


All times are GMT -4. The time now is 11:15 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.