473,739 Members | 10,033 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

The old inability to toggle/change/switch between ALTER PROCEDURE <---> CREATE PROCEDURE bug (or is it a feature?)

Keep in mind this is my first compiled SQL program Stored Procedure
(SP), copied from a book by Frasier Visual C++.NET in Visual Studio
2005 (Chap12). So far, so theory, except for one bug (feature?)
below. At some point I'm sure I'll be able to laugh about this, akin
to forgeting a semi-colon in C/C++, but right now it's frustrating
(time to sleep on it for a while).

Problem--
For some reason I get the error when trying to save files where two
tables (called Author and Content), linked by a single key, form a
relationship.

By simple comparison of the source code in the textbook and my program
(below) I found the difference: instead of, like in the textbook, the
Stored Procedure (SP) starting with "CREATE PROCEDURE", it
*automatically* is (was somehow) given the name of 'ALTER PROCEDURE'
and I cannot change this to "CREATE PROCEDURE" (you get an error in MS
Visual Studio 2005 Pro edition of "There is already an object named
XXX in the database", see *|* below). No matter what I do, the SP is
always changed by Visual Studio 2005 to 'ALTER PROCEDURE'!!!
(otherwise it simply will not save)

Anybody else have this happen? (See below, others have had this happen
over the years but it's not clear what the workaround is)

Keep in mind this is my first attempt and I have ordered some
specialized books on SQL, but if this is a common problem (and I
suspect it's some sort of bug or quirk in VS2005), please let me know.

Frankly I think SQL as done by VS2005 is messed up.

Here are two Usenet threads on this problem:

(1) http://tinyurl.com/2o956m or,

http://groups.google.com/group/micro...454182ae77d409

(2) http://tinyurl.com/2ovybv or,

http://groups.google.com/group/micro...e5428bf0525889

The second thread implies this is a bug--any fix?

Also this bug might be relate to the fact I've switched (and not
rebooted) from Administrator to PowerUser after successfully changing
the permissions in the SQL Server Management Studio Express (see this
thread: http://tinyurl.com/2o5yqa )

Regarding this problem I might try again tommorrow to see if rebooting
helps.

BTW, in the event I can't get this to work, what other SQL editor/
compiler should I use besides MS Visual Studio 2005 for ADO.NET and
SQL dB development?

RL

// source files
// error message:

'Authors' table saved successfully
'Content' table
- Unable to create relationship 'FK_Content_Aut hors'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
"FK_Content_Aut hors". The conflict occurred in database "DCV_DB",
table "dbo.Author s", column 'AuthorID'.

// due to the below no doubt!

--
CREATE PROCEDURE dbo.InsertAutho r /* THIS IS CORRECT (what I want)
'CREATE PROCEDURE' not 'ALTER PROCEDURE'*/

(
@LastName NVARCHAR(32) = NULL,
@FirstName NVARCHAR(32) = NULL
)
AS
/* SET NOCOUNT ON */
INSERT INTO Authors (LastName, FirstName)
VALUES (@LastName, @FirstName)
RETURN
--
ALTER PROCEDURE dbo.InsertAutho r /* WRONG! I want 'CREATE PROCEDURE'
not 'ALTER PROCEDURE' but VS2005 won't save it as such!!!*/

(
@LastName NVARCHAR(32) = NULL,
@FirstName NVARCHAR(32) = NULL
)
AS
/* SET NOCOUNT ON */
INSERT INTO Authors (LastName, FirstName)
VALUES (@LastName, @FirstName)
RETURN
--

*|* Error message given: when trying to save CREATE PROCEDURE Stored
Procedure: "There is already an object named 'InsertAuthor' in the dB

Mar 31 '07 #1
11 4100
It seems you are confusing creating the proc with executing the proc. MV apparently displays (when
you select Edit or something similar), the proc code with an ALTER PROC in the beginning, assuming
that you want to modify the source code for the procedure.

Compare to developing a C app from an IDE. The IDE let you work with the source code. This is the
ALTER PROC part. When you open/edit or whatever the proc in VS, it reads the source code for the
proc from the system tables and replace the initial CREATE to ALTER assuming that you want to modify
the source code.

Executing the C code is different from compiling and linking it.

For the first URL you referred to, we never got a repro of what actually was happening. For the
second, we found a bug where the tool incorrectly not only changed CREATE PROC to ALTER PROC, but
also code *inside the proc* was changed such as CREATE TABLE changed to ALTER TABLE.

Also, I suggest you keep your source code in files, which allow you to version them (Source safe
etc). Or even look at Visual Studio for Database Professionals.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"raylopez99 " <ra********@yah oo.comwrote in message
news:11******** **************@ p15g2000hsd.goo glegroups.com.. .
Keep in mind this is my first compiled SQL program Stored Procedure
(SP), copied from a book by Frasier Visual C++.NET in Visual Studio
2005 (Chap12). So far, so theory, except for one bug (feature?)
below. At some point I'm sure I'll be able to laugh about this, akin
to forgeting a semi-colon in C/C++, but right now it's frustrating
(time to sleep on it for a while).

Problem--
For some reason I get the error when trying to save files where two
tables (called Author and Content), linked by a single key, form a
relationship.

By simple comparison of the source code in the textbook and my program
(below) I found the difference: instead of, like in the textbook, the
Stored Procedure (SP) starting with "CREATE PROCEDURE", it
*automatically* is (was somehow) given the name of 'ALTER PROCEDURE'
and I cannot change this to "CREATE PROCEDURE" (you get an error in MS
Visual Studio 2005 Pro edition of "There is already an object named
XXX in the database", see *|* below). No matter what I do, the SP is
always changed by Visual Studio 2005 to 'ALTER PROCEDURE'!!!
(otherwise it simply will not save)

Anybody else have this happen? (See below, others have had this happen
over the years but it's not clear what the workaround is)

Keep in mind this is my first attempt and I have ordered some
specialized books on SQL, but if this is a common problem (and I
suspect it's some sort of bug or quirk in VS2005), please let me know.

Frankly I think SQL as done by VS2005 is messed up.

Here are two Usenet threads on this problem:

(1) http://tinyurl.com/2o956m or,

http://groups.google.com/group/micro...454182ae77d409

(2) http://tinyurl.com/2ovybv or,

http://groups.google.com/group/micro...e5428bf0525889

The second thread implies this is a bug--any fix?

Also this bug might be relate to the fact I've switched (and not
rebooted) from Administrator to PowerUser after successfully changing
the permissions in the SQL Server Management Studio Express (see this
thread: http://tinyurl.com/2o5yqa )

Regarding this problem I might try again tommorrow to see if rebooting
helps.

BTW, in the event I can't get this to work, what other SQL editor/
compiler should I use besides MS Visual Studio 2005 for ADO.NET and
SQL dB development?

RL

// source files
// error message:

'Authors' table saved successfully
'Content' table
- Unable to create relationship 'FK_Content_Aut hors'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
"FK_Content_Aut hors". The conflict occurred in database "DCV_DB",
table "dbo.Author s", column 'AuthorID'.

// due to the below no doubt!

--
CREATE PROCEDURE dbo.InsertAutho r /* THIS IS CORRECT (what I want)
'CREATE PROCEDURE' not 'ALTER PROCEDURE'*/

(
@LastName NVARCHAR(32) = NULL,
@FirstName NVARCHAR(32) = NULL
)
AS
/* SET NOCOUNT ON */
INSERT INTO Authors (LastName, FirstName)
VALUES (@LastName, @FirstName)
RETURN
--
ALTER PROCEDURE dbo.InsertAutho r /* WRONG! I want 'CREATE PROCEDURE'
not 'ALTER PROCEDURE' but VS2005 won't save it as such!!!*/

(
@LastName NVARCHAR(32) = NULL,
@FirstName NVARCHAR(32) = NULL
)
AS
/* SET NOCOUNT ON */
INSERT INTO Authors (LastName, FirstName)
VALUES (@LastName, @FirstName)
RETURN
--

*|* Error message given: when trying to save CREATE PROCEDURE Stored
Procedure: "There is already an object named 'InsertAuthor' in the dB
Apr 1 '07 #2
raylopez99 (ra********@yah oo.com) writes:
// error message:

'Authors' table saved successfully
'Content' table
- Unable to create relationship 'FK_Content_Aut hors'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
"FK_Content_Aut hors". The conflict occurred in database "DCV_DB",
table "dbo.Author s", column 'AuthorID'.

// due to the below no doubt!

--
CREATE PROCEDURE dbo.InsertAutho r /* THIS IS CORRECT (what I want)
'CREATE PROCEDURE' not 'ALTER PROCEDURE'*/
No! That has nothing to do with it! In the above you are try to add a
foreign key from the Content table to the Authors table, but there is
data that prevents this from happening. Maybe because you had already
entered data in Contents before you tried to apply the foreign key. This
is entirely unrelated to your procedure.

Here is a script that demontstrates:

CREATE TABLE Authors (
authorid int NOT NULL,
name nvarchar(50) NOT NULL,
CONSTRAINT pk_authors PRIMARY KEY (authorid))
go
-- Very simple book table. I ignore ISBN and the fact that
-- a book can have several authors.
CREATE TABLE Books (
bookid int NOT NULL,
title nvarchar(1000) NOT NULL,
authorid int NOT NULL,
CONSTRAINT pk_books PRIMARY KEY (bookid))
go
-- Being eager, we insert a book, before we add any authors.
INSERT Books (bookid, title, authorid)
VALUES(1, 'The Mouse Trap', 1)
go
-- Oops, someone told us that foreign keys is a good idea.
ALTER TABLE Books ADD
CONSTRAINT fk_books_author s FOREIGN KEY (authorid)
REFERENCES Authors(authori d)
go
-- It failed. We must add the author first:
INSERT Authors (authorid, name)
VALUES (1, 'Agatha Christie')
go
-- It should work now.
ALTER TABLE Books ADD
CONSTRAINT fk_books_author s FOREIGN KEY(authorid)
REFERENCES Authors(authori d)
go
-- Clean up.
DROP TABLE Books, Authors

Note by the way that this is all SQL commands. While point-and-click
GUIs for table design can make you work faster if you are unexperienced,
learning the SQL commands is absolutely essential if you plan for a
professional career in SQL programming. Once you know the commands well,
you can use GUI tools if you find that more convenient. But all the
tools do is to generate the commands like the above, and without knowledge
and understanding of that, you are pretty clueless when things go wrong.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 1 '07 #3
On Apr 1, 3:22 am, Erland Sommarskog <esq...@sommars kog.sewrote:
>
Note by the way that this is all SQL commands. While point-and-click
GUIs for table design can make you work faster if you are unexperienced,
learning the SQL commands is absolutely essential if you plan for a
professional career in SQL programming. Once you know the commands well,
you can use GUI tools if you find that more convenient. But all the
tools do is to generate the commands like the above, and without knowledge
and understanding of that, you are pretty clueless when things go wrong.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se

Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx
Thanks Erland--I have bookmarked your example for future reference,
after I read some SQL books I ordered. Right now I'm trying to just
learn how the SQL editor and IDE work. For some strange reason I was
able to "save" the same example while as Administrator rather than
PowerUser, but I think it's just a coincidence--I must have inserted a
wrong word or some wrong semantics in the PowerUser version, which is
kept in its own seperate database. Permissions seems to be a big deal
with modern SQL databases BTW--eventually I hope to figure out how to
manipulate permissions on the fly with commands, as you seemed to show
in another thread.

Seems like SQL is like a macro language that is "top-down" procedural
and definitely not object oriented of course.

Now onto the next topic in my SQL GUI paint-by-numbers book:
connected vs disconnected ADO.NET (I program for fun, not
professionally) .

RL

Apr 1 '07 #4
raylopez99 (ra********@yah oo.com) writes:
For some strange reason I was able to "save" the same example while as
Administrator rather than PowerUser, but I think it's just a
coincidence
Probably because the first time the procedure wasn't there, so CREATE was
the right thing. The second time round, ALTER is the right thing.
Seems like SQL is like a macro language that is "top-down" procedural
and definitely not object oriented of course.
SQL is hardly a macro language, but it's true that neither is it object-
oriented. And it is different from traditional programming. In a traditional
programming when you want to operate on many objects of the same time you
run a loop. In SQL you operate on all rows at once, and the optimizer out
which is the best way to do this.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 1 '07 #5
On Apr 1, 8:16 am, Erland Sommarskog <esq...@sommars kog.sewrote:
>--
Thanks Erland--right now another problem that's sprung up is
connecting to a simple database (the same one, this time the database
'works' fine, but accessing it from outside the SQL language via a
console C++ program is the problem). See thread here: http://tinyurl.com/3e2nz8

If you have any insight please let me know.

Cheers,

Ray

Apr 1 '07 #6
raylopez99 (ra********@yah oo.com) writes:
Thanks Erland--right now another problem that's sprung up is
connecting to a simple database (the same one, this time the database
'works' fine, but accessing it from outside the SQL language via a
console C++ program is the problem). See thread here:
http://tinyurl.com/3e2nz8
You have a connection string that goes:

connection->ConnectionStri ng = "User ID=sa; Password=;"
"Data Source=(local); Initial Catalog=DCV_DB; ";

But didn't you say you were using SQL Express? By default, SQL Express is
installed as a named instance with the name SQLEXPRESS, in which case the
Data Source should be: (local)\SQLEXPR ESS.

Did the User ID and Password come from that book? If you want your app
to run with Integrated Security, you should use

Integrated Security=SSPI;

instead. Having sa with a blank password is extremely bad practice, and
outright dangerous if the server is exposed on the Internet.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 1 '07 #7
On Apr 1, 11:45 am, Erland Sommarskog <esq...@sommars kog.sewrote:
raylopez99 (raylope...@yah oo.com) writes:
> See thread here:
http://tinyurl.com/3e2nz8

You have a connection string that goes:

connection->ConnectionStri ng = "User ID=sa; Password=;"
"Data Source=(local); Initial Catalog=DCV_DB; ";

But didn't you say you were using SQL Express? By default, SQL Express is
installed as a named instance with the name SQLEXPRESS, in which case the
Data Source should be: (local)\SQLEXPR ESS.
Yes, but for some reason \SQLEXPRESS doesn't compile in VS2005 "S not
recognized" error
>
Did the User ID and Password come from that book?
Yes, it was the author's example.
If you want your app
to run with Integrated Security, you should use

Integrated Security=SSPI;

instead. Having sa with a blank password is extremely bad practice, and
outright dangerous if the server is exposed on the Internet.
I'm not sure this database is exposed to the Internet or not (I
believe I checked the \CLR option in SQL Server Management Express,
and intended only local connections but I don't know.

Also of interest: "testing" the database connection (from within
Server Explorer in VS2005) yields "OK" (connected), then clicking on
"Modify Connection" then "Advanced" gives: "Use Windows
Authentication" , "Integrated Security = True", "initial catalog =
NAMEofDB", "Data Source = myPCname\SQLEXP RESS, and a bunch of other
parameters such as packet size, etc.

Rather than waste any more of your time (and I thank you for replying--
very helpful), I am going to order a specialized book on programming
for SQL *within* VS2005 (I've already ordered a bunch of SQL generic
books, including this one: Programming Microsoft SQL Server 2005
(Paperback) by Andrew J. Brust (Author)
http://www.amazon.com/Programming-Mi...5461390&sr=1-1
).

The online help for VS2005 was too specific and not comprehensive
enough--they were talking about setting connection strings, which is
fine once you get more experienced, but all I want to do at the moment
is connect to a existing dB from within a simple console C++
application. I wish they had an example showing how to get a
connection string from all databases 'open' in your local path, which
would have helped, or how to connect to any database that's open in
your 'environment'.

Anyway I think the solution lies in security permissions etc. The
example in the textbook made it look so easy but it's not. As in lots
of programming you can spend days with various permutations or you can
see an exemplar that works, and solve your problem much quicker.
Right now I'm looking for that exemplar and am confident I can find it
eventually.

BTW I recently have picked up the Trojan virus "pushu-A", which is
unusual, and I hope it's not related to this database programming. I
can't imagine how, since the above dB is "using Windows
Authentication" and I have a firewall, so I should not be any less
safe than before, but I don't know.

RL

Apr 1 '07 #8
raylopez99 (ra********@yah oo.com) writes:
Yes, but for some reason \SQLEXPRESS doesn't compile in VS2005 "S not
recognized" error
If you program in C++ (and I assume C#) you need to double the \, as
\ has a special meaning in string literals in C++.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 1 '07 #9
On Apr 1, 3:41 pm, Erland Sommarskog <esq...@sommars kog.sewrote:
raylopez99 (raylope...@yah oo.com) writes:
Yes, but for some reason \SQLEXPRESS doesn't compile in VS2005 "S not
recognized" error

If you program in C++ (and I assume C#) you need to double the \, as
\ has a special meaning in string literals in C++.

--
Yes it worked! You are correct Erland. The double slash did work,
and the program compiled and worked perfectly. (For some reason the
forward slash, which usually also works for paths in lieu of the
double slash, did not compile however).

For the record here is what worked for the connection string:

connection->ConnectionStri ng = "Persist Security Info = False;
Integrated Security=SSPI;" "Data Source=(local)\ \SQLEXPRESS; Initial
Catalog=MyDATAB ASEnameHERE_DB; ";

//note the double slash: \\

No need to supply a password in the connection string (using Windows
Authentication) .

Thanks again! Now I can pickup this book on SQL again, which I set
aside.

RL

Apr 2 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
24085
by: geoff | last post by:
Is there a stored procedure installed by sql server 2000 that I can call and just pass in the name of a new database and have it create the database for me? If not, how do I do it in sql? Thanks.
4
8101
by: MD | last post by:
I am trying to create a dynamic SQL statement to create a view. I have a stored procedure, which based on the parameters passed calls different stored procedures. Each of this sub stored procedure creates a string of custom SQL statement and returns this string back to the main stored procedure. This SQL statements work fine on there own. The SQL returned from the sub stored procedure are returned fine. The datatype of the variable that...
6
3424
by: cmay | last post by:
I am writing some code generation stuff and I am trying to get a script like this to work: IF (something) BEGIN CREATE PROCEDURE Whatever AS SELECT 1 as one END
8
4921
by: peteh | last post by:
Hi All; I have what I hope is a simple environmental problem. I have some SQL that creates a VERY simple procedure. When the create is executed from Quest (from a Windows client) - no problem. As soon as I go to the command line (on the actual DB server), I get a strange (and somewhat frightening) sqlcode -1007 (corrupt tablespace!?). I'm pretty sure it has something to do with CLP/statement terminator behavior, but cannot find the recipe...
2
22619
by: masri999 | last post by:
I have a requirement in SQL 2005 in Development database 1. Schema dbo owns all objects (tables,views,SPs,UDFs etc) . 2. Only DBA's ( who are database owners ) can create, alter tables . Developer's should not create or alter tables . 3. Developers can create/alter Stored Procedure/User Defined functions in dbo schema and can execute SP/UDF. 4. Developers should have SELECT,INSERT,DELETE,UPDATE on tables ( tables in dbo schema
6
13052
by: Shiller | last post by:
I want my application to create a new database/tables when run for the first time. I have created a stored procedure to create the new database named "budget". When I run the stored procedure, it creates the budget database but the tables are created in the "master" database. Please help.
3
2446
by: PRAW | last post by:
Hi I am working on a way to Create procedure to insert a set of records for a project in a database.Now there are 11 tasks and they are to be added in each project in a table Task_Name Task_taskid Project_ID Task_outline_no 01 - Project Management 1204 1180 0.1 02 - Installation 1207 1180 2 03 - Design Pilot 1208 1180 3 04 - Integration &...
2
7189
by: rameshcse2005 | last post by:
hai this is Ramesh , What the difference is between CREATE PROC and CREATE PROCEDURE? i have a basic question, i googled this question, but i could't get exact answer. so i hope somebody clear my basic doubt.
3
4146
by: gopi2ks | last post by:
Dear All, I have one stored procedure like sp_insertEmployee Employee Table Fileds Eno int pk, ename varchar(100), designation varchar
0
8969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9342
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9211
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8218
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6756
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6056
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4572
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3286
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2195
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.