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 500
Search took 0.03 seconds.
Search: Posts Made By: sal
Forum: SQL Server 2005 December 29th, 2006, 12:46 PM
Replies: 5
Views: 2,432
Posted By sal
If you have data on your table, you must give it...

If you have data on your table, you must give it a starting value and an increment value. For instance if you have numbers up to 1000 and you want to increment by 1 you do this:

Identity (1000,1)...
Forum: Access VBA August 11th, 2005, 12:20 PM
Replies: 3
Views: 4,097
Posted By sal
First. Change your field name and remove the...

First. Change your field name and remove the asterisk. It is not good practice.

you can do a:

SELECT [ID*] from Table1




Sal
Forum: XML August 11th, 2005, 10:25 AM
Replies: 1
Views: 827
Posted By sal
Standard Implementation of Embeded relations

I have a peculiar implementation request for an XML file, which contains a relational model, which wich will be created by concatenating strings with SQL and writing the string to a file that will be...
Forum: C# May 19th, 2005, 11:54 AM
Replies: 1
Views: 2,325
Posted By sal
Return ASCII values for a given string

Wuw can i do a loop on a string to return the ASCII values of the string

"This is a Test"

as the ASCII values? 84, 104, 104, etc.

I am trying to move the following SQL Server function to c#....
Forum: SQL Server 2000 October 12th, 2004, 12:16 PM
Replies: 2
Views: 739
Posted By sal
If this is a Access Data Project, you may get...

If this is a Access Data Project, you may get away with creating a pivot table form. The form will do the case for you.

Just make sure to index the tables properly or you will degrade server...
Forum: SQL Server 2000 October 12th, 2004, 12:10 PM
Replies: 1
Views: 925
Posted By sal
There is no time data type in MSDE or SQL Server....

There is no time data type in MSDE or SQL Server.

Try this to get only the time:

select convert(varchar(8),getdate(), 108)

look up convert in books on line.
Forum: Access October 11th, 2004, 10:32 AM
Replies: 2
Views: 1,343
Posted By sal
If this is a shared database, your set -up of...

If this is a shared database, your set -up of security should have created a new .mdw file in a network folder. Use that network folder's .mdw file. You are using the one in your PC, which is not the...
Forum: ASP.NET 1.0 and 1.1 Basics October 5th, 2004, 09:16 AM
Replies: 23
Views: 5,749
Posted By sal
http://www.microsoft.com/downloads/details.aspx?Fa...

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en



Sal
Forum: Classic ASP Components October 5th, 2004, 09:11 AM
Replies: 1
Views: 1,260
Posted By sal
View this links on how to create a user in...

View this links on how to create a user in command line

http://www.is-it-true.org/nt/atips/atips34.shtml
http://windows.about.com/library/tips/bltip238.htm

also look at xp_cmdshell in books on...
Forum: ASP.NET 1.x and 2.0 Application Design October 4th, 2004, 01:13 PM
Replies: 3
Views: 1,957
Posted By sal
My database table for keeping users and passwords...

My database table for keeping users and passwords is SQL Servers sysxlogins table from the Master database. You mean that this table can be used in forms authentication? I am not sure if I want to...
Forum: Pro VB Databases October 4th, 2004, 11:07 AM
Replies: 1
Views: 989
Posted By sal
Try looking into MSDE the free version of SQL...

Try looking into MSDE the free version of SQL Server, or better yet, try SQL Server 2005 Express. This have the full blown power of SQL Server, but MSDE has a limitation on concurrent connections....
Forum: SQL Server 2000 September 30th, 2004, 04:49 PM
Replies: 6
Views: 9,458
Posted By sal
try ...

try

[DA-T-BACIM01].my_database_test.dbo.employee

some people do not remember to name things properly. This will also give you problems when trying to use windows authentication.

By the way,...
Forum: ASP.NET 1.x and 2.0 Application Design September 30th, 2004, 10:27 AM
Replies: 3
Views: 1,957
Posted By sal
Secure SQL Server authentication

I need to create an ASP.NET front end for an existing SQL Server Database. The Database has 200+ SQL Server User names in it. Each user name is assigned to any of the 9 SQL Server Roles. All ASP.NET...
Forum: SQL Server 2000 September 30th, 2004, 09:37 AM
Replies: 3
Views: 1,611
Posted By sal
Also, change your uid to something other than the...

Also, change your uid to something other than the sa. Keep this to an account that does not have many rights to the SQL Server database.



Sal
Forum: SQL Server 2000 September 30th, 2004, 09:32 AM
Replies: 5
Views: 963
Posted By sal
Are you using a DSN to connect? Has the sa...

Are you using a DSN to connect? Has the sa password changed? Which type of authentication are you using with the ASP.NET project?

Please do not use the sa password for anything. Not even testing....
Forum: SQL Server 2000 September 30th, 2004, 09:26 AM
Replies: 17
Views: 7,978
Posted By sal
A database can never shrink to a size less than...

A database can never shrink to a size less than the initial size. if your database initial size was 1 GB, but you only have 1 MB of data, every time your database shrinks it will return to 1 GB. So...
Forum: Access VBA September 23rd, 2004, 03:52 PM
Replies: 2
Views: 2,760
Posted By sal
If yuo are in a form, whether the form is in...

If yuo are in a form, whether the form is in Datasheet view or continuous, you click on the field that you would like to format, on the main menu go to format/conditional formatting.
It is the same...
Forum: Access VBA September 22nd, 2004, 02:19 PM
Replies: 3
Views: 1,430
Posted By sal
Access automatically does all of the compact and...

Access automatically does all of the compact and repair. It just makes sure that any ampty space is removed. Almost like defragging your hard drive.



Sal
Forum: Access September 22nd, 2004, 12:54 PM
Replies: 4
Views: 1,681
Posted By sal
Try using adisconnected ADO recordset instead of...

Try using adisconnected ADO recordset instead of the array. Once you cmplete doing whatever you do eith the array, you can get a connection to the database and move the records to the table, which...
Forum: Access VBA September 17th, 2004, 09:54 AM
Replies: 5
Views: 962
Posted By sal
If you move your front end and back end from one...

If you move your front end and back end from one folder to another and the links do not work, delete the links from the front ent a d link them again to the back end.



Sal
Forum: SQL Server 2000 September 17th, 2004, 09:07 AM
Replies: 1
Views: 2,721
Posted By sal
One method is not safer than the other just based...

One method is not safer than the other just based on OS or Database server security. It all depends on your security settings for both SQL Server and OS. I would keep my images on a network drive...
Forum: SQL Server 2000 September 16th, 2004, 10:29 AM
Replies: 19
Views: 3,855
Posted By sal
For the most part it is a fast way to get a...

For the most part it is a fast way to get a report populated in an Access ADP, but you are right. I do not use that method. ADO is a better alternative. This was an issue with user rights and not...
Forum: SQL Server ASP September 13th, 2004, 10:26 AM
Replies: 6
Views: 1,876
Posted By sal
Not for sure, but it seems to return a Negative...

Not for sure, but it seems to return a Negative value in column "status". Seems to be the same in all dbs.



Sal
Forum: SQL Server 2000 September 13th, 2004, 10:04 AM
Replies: 3
Views: 1,081
Posted By sal
I believe that SP2 was the first SP for SQL...

I believe that SP2 was the first SP for SQL Server that actually had any patch for MSDE, before that, bugs stayed in MSDE forever.



Sal
Forum: SQL Server 2000 September 13th, 2004, 10:02 AM
Replies: 6
Views: 1,950
Posted By sal
If you have a task set-up with teh SP_makewebtask...

If you have a task set-up with teh SP_makewebtask and you are making it fire when a record changes, this will be implemented with a triggeer. If the stored procedure to run the web task has been...
Showing results 1 to 25 of 500

 


All times are GMT -4. The time now is 01:40 AM.


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