|
Hi All
IAm just started learning sql server 2000.
I have on stored procedure sp_getdepdetails
I Am writng another stored procedure sp_getempdetails in that calling with exec sp_getdepdetails.
but error in sp_getdepdetails. my doubt is sp_getemodetails is executed or not
Thanks N advance
|
|
|
|
|
shld get executed!!!
by the way what is the error in your main sp??
Gautham
|
|
|
|
|
hi all
i am using odbc connection to query the data from excel ...
i am able to ... the query i use is
select empid from [sheet1$]... (empid is the column header in the first row)
the problem is i want to access the data by ponting the index of the column .. something like
select column1 from [sheet1$]
can anyone suggest the query for that ???
Annns
|
|
|
|
|
SELECT * FROM [Sheet1$A1:A1000]
|
|
|
|
|
thanx for the reply  ..
hope it will help me...
but still one more doubt ... then how will we get the
value from result set?? like rs.getString("?"); ???
Thnks
Annns
|
|
|
|
|
use adapter to fill data .and use them like
myDataTable.Rows[row_num][column_no]
|
|
|
|
|
thanx so much .. let me try it out !!
|
|
|
|
|
how many versions we have in sql which one is latest version...
|
|
|
|
|
The last version of MS SQL Server is 9.0 (2005)
or do you mean SQL ANSI standards ?
|
|
|
|
|
how to use rollback . give me syntax please
|
|
|
|
|
you can get the from online help
however i'm pasting only syntax part from the same
ROLLBACK [ TRAN [ SACTION ]
[ transaction_name | @tran_name_variable
| savepoint_name | @savepoint_variable ] ]
Arguments:
transaction_name
Is the name assigned to the transaction on BEGIN TRANSACTION. transaction_name must conform to the rules for identifiers, but only the first 32 characters of the transaction name are used. When nesting transactions, transaction_name must be the name from the outermost BEGIN TRANSACTION statement.
@tran_name_variable
Is the name of a user-defined variable containing a valid transaction name. The variable must be declared with a char, varchar, nchar, or nvarchar data type.
savepoint_name
Is savepoint_name from a SAVE TRANSACTION statement. savepoint_name must conform to the rules for identifiers. Use savepoint_name when a conditional rollback should affect only part of the transaction.
@savepoint_variable
Is name of a user-defined variable containing a valid savepoint name. The variable must be declared with a char, varchar, nchar, or nvarchar data type.
Regards
KP
|
|
|
|
|
how to generate automatic id like c001.c002;
|
|
|
|
|
In SQL Server generates serial numbers automatically if the column is 'Identity column'. however this is possible only for numeric data type.
in your case
SELECT max(cast(substring(id, 2, 3) as bigint)) + 1 FROM tableA
here ....
1. using substring extracting last three digits
2. converting the digits to numeric
3. getting max()
4. then incrementing by one.
Regards
KP
|
|
|
|
|
Is it possible to use multiple Like statments within a SQL statement? I have a page where users can query data based on two fields. The user then has the option to export the results to excel, via a link. If the user does not select any criteria then the fields default to %. When I trie to run the SQL statement it doesnt seem to like the %. Please help!!
DocAttach_Summary_Excel.asp?HMO=%&Doc_Attach=%
<%
Response.ContentType = "application/vnd.ms-excel"
Dim THMO
Dim TDoc_Attach
THMO = request.querystring("HMO")
TDoc_Attach = request.querystring("Doc_Attach")
%>
<% set objconn=server.createobject("adodb.connection")
connpath="DBQ=" & server.mappath("/fpdb/ClaimMart_Access.mdb")
objconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & connpath
set objrs=objconn.execute("SELECT * FROM Tbl_DocAttached_Summary WHERE (HMO LIKE '" & THMO & "' AND DOC_ATTACHED_FLG LIKE '" & TDoc_Attach & "')")
%>
|
|
|
|
|
You have a hugh security risk in your code. You are passing though a query string value directly to the SQL statement without it being sanitised. If the query string should contain, say, an apostrophe then that will change the meaning of the SQL Statement. If after the apostrophe it contains other SQL text then it could completely change the SQL statement's meaning. I advise you to read about SQL Injection Attacks and tips on how to prevent them[^]
|
|
|
|
|
This is an internal website located on the companies intranet. I just created the website to make the data more available. With that being said, am I still at risk?
|
|
|
|
|
admoore77 wrote: With that being said, am I still at risk?
Statistically, most breaches of security are insider jobs.
|
|
|
|
|
hello
i was creating relationship betwween 2 tables with different data types for the primarykeys of the two tables.
One primary key had data type int and the other primary key had data typevarchar. when i tried to create relationship between the two table, Sql Server gave the error that both the primary key data types are different and hence it didn't create the relationship.
so what i want to know is that does the data types of the primary keys have to be the same to create relationship between the tables???
|
|
|
|
|
Saira Tanwir wrote: what i want to know is that does the data types of the primary keys have to be the same to create relationship between the tables???
If you want to create a relationship between two tables the type of the primary key on one table must match the foreign key on the other. The only time that two primary keys must match is when you are creating a one-to-one (or zero-to-one) join because the primary keys are also the foreign keys.
|
|
|
|
|
Yes.It should be same datatypes while creating a relationship between two tables.
Priya
|
|
|
|
|
Priya_2007 wrote: It should be same datatypes while creating a relationship between two tables
The OP was asking about two PRIMARY KEYS. The primary keys do NOT have to be the same, and often they are not the same in two related tables. The important part is the PRIMARY KEY on the parent table matches the type of the FOREIGN KEY on the child table. You only need to match both primary keys when you are creating a one-to-one or zero-to-one relationship.
|
|
|
|
|
hi folks
can anyoe guide me about how to generate script file programmatically??
Saira
|
|
|
|
|
Create a FileStream and write SQL statements to it.
|
|
|
|
|
i'll work on it and then be back if any problem occurrs.
till then
Goodbye
|
|
|
|
|
hi
i'm using the following query to create a One to One relatonship between two tables 'boys' and 'sports'
sql="ALTER TABLE boys ADD CONSTRAINT UK_sports_type UNIQUE(sports_type)";
i get the following error
column sports_type does not exist in the target table. Couldnot create constraint see previous errors
can u plz explain the meaning of this, too???
Saira
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
