PL/SQL or Oracle SQL
I am mostly a SQL server user, but by chance used to use Oracle 7.3.4, 8.1.5 and now 9.2. In the current project, the client wanted us to write Oracle SQL instead of Stored Procedure (PL/SQL), and argued that since Oracle 8, the dynamic Oracle SQL string in the client code is as faster as a stored procedure. Actually, this kind of debate happened in the SQL server field. But, it seems in the SQL server field, most people prefer to use SP, not just due to the performance, but the considerations including code encapsulation, code re-use, less traffic, security, better management and so on.
...difference between T-Sql and Sql,
I am very new to Sybase, can some one tell me the differences
between T-Sql and Sql.
Thanks in advance,
I believe you are referring to:
SQL--The standard SQL syntax used universally for most DBMS's
T-SQL--Transact-SQL, Sybase's flavor of SQL the is used for writing stored
proc's, etc. I supported variable declarations, functions and data-type
...SQL A and SQL Server
Hi I heard SQL Server used to be owned by Watcom is this true? Is SQL
Anywhere, therefore, similar to SQL Server?
Not quite true. SQL Anywhere was created by Watcom. SQLServer was created by Sybase, and Microsoft licensed the
technology. So MSSQL and ASE have common roots, not SQLAnywhere.
"John Kingan" <email@example.com> wrote in message news:40d82aa1$1@forums-1-dub...
> Hi I heard SQL Server used to be owned by Watcom is this true? Is SQL
> Anywhere, therefore, similar to SQL Ser...SQL Express to SQL ?
I am developing a site using the express edition of all tools (VWD and SQL Express). I want to use GoDaddy hosting and was wondering if I will be able to effectively put my SQL database and website up on their hosting even though it was developed via Express edition of Microsoft programs?...sql or my sql query
hi,in my database i have the two tables...1)programs 2)reservedin the programs...two fields 1)program id 2)maxseats................these details wil be entered by adminin the reserved table two fileds ..1)PRogramid 2)statusmy requirement is .. i need the available seats..meansif any body is intersted in any program...they wil select the program...then status becomes approved(1)..then i need the o/p as ...SQL > My SQL
I have a problem, my asp.net page wants to connect to the sql server, but it has to be the mysql. How can I solve this problem?
This is my code:
<%@ page explicit="true" language="VB" debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<%@ Import Namespace="System.Data.SqlClient" %>
sub page_load(sender as object, e as eventargs)
If Not IsPostBack Then
dim connect as sqlconnectio...what's difference between Accesss DataBase and Sql Sever about Sql String(or Command),Sql StoreProcedure ?
i am being dirty to Access DataBase from Sql Sever Database for my new work.But the sql string of Access sounds like a little different,can i use the sql string of SqlSever for Access database,too?another question is: Does Access DataBase support Sql StoreProcedure??? when i worked in Access2000 ,did not see any about StoreProcedure,but i download a file named AccessHelper.cs , some function of it looks like support StoreProcedure,Does it? i want to fly ...
Hi dkzeng ,Your first question The string of both sqlsever and acce...Strange difference between SQL from .Net and SQL within stored proc
Hi, I am trying to fill a DataGrid with random records from my database. It thought I had found a way to randomly select records using SQL. So I built a stored procedure in Access and sure enough, it returns a random set of records.
Whe I tried to call this from my app, it kept returning the same set of records. So I copied and pasted the SQL into the app (code below) but it made no difference. Could anyone tell me why this wouldn't work?
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="...what is the difference between InstallSqlState.sql and InstallPersistSqlState.sql?
i have the following questions
1> what is the difference between InstallSqlState.sql and InstallPersistSqlState.sql?
2> Both of these file comes with 1.1 and 2.0. what is the difference between those?
3> i have 1.1 application and 2.0 application which version of files i should use if i want share session information bwteen the 1.1 and 2.0 application.
4> if set Session mode in web.config to use SQLServer. is it possible to access that database/tables from classic ASP pages so that i can share session information with classic ASP also?
First one is to install it on m...SQL code to stop and restart sql server 2005 and sql agent
I would like to restore a SQL Server 2005 database from a backup file. The problem is that the users which are using the site, prevent the restore operation from completing. So, I stop the sql server by right clicking the server name in management studio and selecting stop, wait for 3-4 minutes and restart it by clicking start. Then I can restore. So I am looking for code that can do these operations (including the wait). let me just add that I am using a named instance - and I want to stop and restart the instance.
Please help, thanks in advance.
I found this link http://...Announce: BNF Grammars for SQL-92, SQL-99 and SQL-2003
Jonathan Leffler has sent me these grammars, which I'm hosting at:
Ron Savage, firstname.lastname@example.org on 17/07/2005
Let the record show: Microsoft is not an Australian company
At 11:08 AM +1000 7/17/05, Ron Savage wrote:
>Jonathan Leffler has sent me these grammars, which I'm hosting at:
Thanks for posting that; should be very useful.
I will point out an apparent spelling mistake, though. See
http://savage.net.au/SQL/sql-2003-noncore-feat...Converting a gridView using an Sql Datasource to a gridview who is not using an SQL DataSource
How can i rewrite this page so that i doesnt make use of an SqlDataSource?
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="LoginHistory.ascx.cs" Inherits="Private_UserControls_WebUserControl" %>
<%--<link rel="stylesheet" href="BaldwinPortal.css" mce_href="BaldwinPortal.css" type="text/css" />--%>
<body style="margin:0 0 0 0;padding:0 0 0 0">
...sql server 2005 inserting prbblem..wrong SQL? wrong parameter?
Im trying to insert a record in my sql server 2005 express database.The following function tries that and without an error returns true.However, no data is inserted into the database...Im not sure whether my insert statement is correct: I saw other example with syntax: insert into table values(@value1,@value2)....so not sure about thatAlso, I havent defined the parameter type (eg varchar) but I reckoned that could not make the difference....Here's my code: Function CreateNewUser(ByVal UserName As String, ByVal Password As String, _&nbs...Is Oracle/SQL Server better than SQL Anywhere
Could anyone tell me if Oracle or SQL Server is better than SQL Anywhere?
That depends entirely on your criteria. Price, performance, supported
platforms, developer/dba skillset, 3rd party application support etc etc.
need to be taken in account. We use both Oracle and ASA in our shop.
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
"NG" <email@example.com> wrote in message
> Could anyone tell m...any difference between sql anywhere and sql anywhere studio
Is there any difference between sql anywhere and sql anywhere studio?
>Is there any difference between sql anywhere and sql anywhere studio?
The answer depends upon the context of the question. Years ago, "sql anywhere" referred to the DBMS
that is now known as Adaptive Server Anywhere. Now, "sql anywhere" can mean a general reference to
a set of products that includes ASA, as well as some other things. "sql anywhere studio" is a
particular bundling of these products.
Still, sometimes when people refer to "sql anywhere" t...