I don't want user dynamic sql

Dear all,
I have a stored procedure which might do INSERT, UPDATE over a specified
table.
Issue is that, at the outset, that table is totally unknown:
' into aux_PLAZO_PRIMER_IMPAGO ' +
' from ' + @.TABLA_COB
EXEC
..
' end DISC043 ' +
' into aux_PLAZO_PRIMER_IMPAGO ' +
' from ' + @.TABLA_COB
EXEC...
BLA,BLA,
I'm looking for a best version of that, dangerous dynamic sql is not well
welcomed here so that...
Declaring a variable as table also to solve the problem.
Thanks in advance for any input,
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)Enric
The best solution is know a table name that you operate on.
http://www.sommarskog.se/dynamic_sql.html
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:72F7C1B3-7C25-414A-8957-D9B0472476D6@.microsoft.com...
> Dear all,
> I have a stored procedure which might do INSERT, UPDATE over a specified
> table.
> Issue is that, at the outset, that table is totally unknown:
> ' into aux_PLAZO_PRIMER_IMPAGO ' +
> ' from ' + @.TABLA_COB
> EXEC
> ..
> ' end DISC043 ' +
> ' into aux_PLAZO_PRIMER_IMPAGO ' +
> ' from ' + @.TABLA_COB
> EXEC...
> BLA,BLA,
> I'm looking for a best version of that, dangerous dynamic sql is not well
> welcomed here so that...
> Declaring a variable as table also to solve the problem.
> Thanks in advance for any input,
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)|||not sure if this is what you're looking for, but sp_executesql is the
first step to prevent SQL injection attacks. after that you're next
best step would be to validate the table against the sysobjects table
to ensure that it is a real table.|||I'm not sure I agree with what he says on that link. IMO he uses exec
way too much. His reasons for not using sp_executesql do not make
sense, and while he does suggest using quotename(), stored procedures
are a better way to ensure that your parameters are unable to be
anything other than the datatype suggested.|||Create as many INSERT and UPDATE procedures as there are tables, that's the
best advice any one can (and should) give you.
If you don't care about data, however, you could just as well store it all
in a single table. (NOT RECOMMENDED!)
I see no reason for dynamic SQL in such elementary processes as inserting,
updating or deleteing a row in a table - building the query string might eve
n
take longer than the execution (i.e. if you decide to do it right - clean up
the parameters to prevent SQL injection, check whether objects exist,
validating the parameters that contain actual values, etc.).
ML
http://milambda.blogspot.com/|||I don't know if this is the situation, but creating a generic insert /
update procedure for tables that store different types of objects is a bad
idea. Even if it's not the case now, as time goes on, there will be a need
to implment additional table specific parameters, data validation
programming, etc. and the procedure will become a big pile of unmanageable
spaghetti. Business rules for things like data validation and referential
integrity are best embedded at the table level in the form of constraints
and triggers.
Generic data access programming is best implmented on the application side
in the form of a data access class.
Designing Data Tier Components and Passing Data Through Tiers:
http://msdn.microsoft.com/library/d...Gag
.asp
On the other hand, if these tables store the same object (vertical
paritioning), then you can implement a partitioned view and perform inserts
/ updates into that:
Modifying Data in Partitioned Views:
http://msdn2.microsoft.com/en-us/library/ms187067.aspx
Strategies for Partitioning Relational Data Warehouses in Microsoft SQL
Server:
http://www.microsoft.com/technet/pr.../2005/spdw.mspx
That said; if dynamic SQL can't be avoided, here my links on the topic of
SQL injection:
http://www.sqlservercentral.com/col...qlinjection.asp
http://www.sqlservercentral.com/col...ectionpart1.asp
http://www.nextgenss.com/papers/adv...l_injection.pdf
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:72F7C1B3-7C25-414A-8957-D9B0472476D6@.microsoft.com...
> Dear all,
> I have a stored procedure which might do INSERT, UPDATE over a specified
> table.
> Issue is that, at the outset, that table is totally unknown:
> ' into aux_PLAZO_PRIMER_IMPAGO ' +
> ' from ' + @.TABLA_COB
> EXEC
> ..
> ' end DISC043 ' +
> ' into aux_PLAZO_PRIMER_IMPAGO ' +
> ' from ' + @.TABLA_COB
> EXEC...
> BLA,BLA,
> I'm looking for a best version of that, dangerous dynamic sql is not well
> welcomed here so that...
> Declaring a variable as table also to solve the problem.
> Thanks in advance for any input,
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''s hard to provide information
> without seeing the code. location: Alicante (ES)|||Will (william_pegg@.yahoo.co.uk) writes:
> I'm not sure I agree with what he says on that link. IMO he uses exec
> way too much. His reasons for not using sp_executesql do not make
> sense, and while he does suggest using quotename(), stored procedures
> are a better way to ensure that your parameters are unable to be
> anything other than the datatype suggested.
What I try to say about this particular case, is that that you should
not do this at all. That is, you should have one procedure per table.
I can't recall that I suggest that EXEC() should be used over sp_executesql,
but you are right that the text could be stronger on using sp_executesql,
and most of all using parameters. In fact, I'm already working with
reworking the article with a lot more emphasis on sp_executesql.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

I don't understand it

Dear all,
I'm executing a DTS which own a sql server task that launch a stored
procedure.
This stored procedure run a WHILE sentence and then launch a bcp command
dinamically.
Well, everything works debugging that stored procedure or simply launch it
throught Query Analyzer with its parameters.
Problem come up when I launch the DTS. That sql server task works but only
launch one time the BCP command.
I know that is very difficult reach to see the exit but...
There goes an excerpt:
set @.cont = 1
Set @.iCont = (select count(*) from tblDownloadKF_Bridge_Info)
WHILE @.cont < @.iCont + 1
begin
set @.table = (select name from tblDownloadKF_Bridge_Info where ID = @.cont)
SET @.bcpCommand= 'bcp ' + @.db + '' + @.table + ' out ' + @.strPath +
Ltrim(RTrim(@.table)) + '.dat -c -S ' + @.host + ' -U ' + @.strUser +' -P '
+
@.strPassword + ''
EXEC @.result = master.dbo.xp_cmdshell @.bcpCommand
if (@.result = 0)
set @.status = 'done'
else
set @.status = 'error'
update tblDownloadKF_Bridge_Info
set Remarks = Ltrim(Rtrim(@.status)),
dateoperation = getdate()
where ID = @.cont
set @.table = ''
set @.cont = @.cont + 1
end
GO
Is there any restriction on that command via DTS'
Thanks so much,Hi Enric,
Your problem is not the BCP command but xp_cmdshell stored procedure.
"INF: How to Run a DTS Package as a Scheduled Job"
http://support.microsoft.com/defaul...kb;en-us;269074
Cristian Lefter, SQL Server MVP
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:0C0CB603-97B8-40B0-9255-D6E3E3F245B3@.microsoft.com...
> Dear all,
> I'm executing a DTS which own a sql server task that launch a stored
> procedure.
> This stored procedure run a WHILE sentence and then launch a bcp command
> dinamically.
> Well, everything works debugging that stored procedure or simply launch it
> throught Query Analyzer with its parameters.
> Problem come up when I launch the DTS. That sql server task works but only
> launch one time the BCP command.
> I know that is very difficult reach to see the exit but...
> There goes an excerpt:
> set @.cont = 1
> Set @.iCont = (select count(*) from tblDownloadKF_Bridge_Info)
> WHILE @.cont < @.iCont + 1
> begin
> set @.table = (select name from tblDownloadKF_Bridge_Info where ID = @.cont)
>
> SET @.bcpCommand= 'bcp ' + @.db + '' + @.table + ' out ' + @.strPath +
> Ltrim(RTrim(@.table)) + '.dat -c -S ' + @.host + ' -U ' + @.strUser +' -P
> ' +
> @.strPassword + ''
> EXEC @.result = master.dbo.xp_cmdshell @.bcpCommand
> if (@.result = 0)
> set @.status = 'done'
> else
> set @.status = 'error'
> update tblDownloadKF_Bridge_Info
> set Remarks = Ltrim(Rtrim(@.status)),
> dateoperation = getdate()
> where ID = @.cont
> set @.table = ''
> set @.cont = @.cont + 1
> end
> GO
>
> Is there any restriction on that command via DTS'
> Thanks so much,

I don't remember...

Dear folks,
Could you please so kind to tell me where the fixed type data stored are? I
mean, in what system table are available these data?
"bigint, binary, float, decimal", and so on
Thanks in advance and regards,
Enricsystypes
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:0FEAE3E6-C6D8-400E-B210-F999DEBE6D17@.microsoft.com...
> Dear folks,
> Could you please so kind to tell me where the fixed type data stored are?
I
> mean, in what system table are available these data?
> "bigint, binary, float, decimal", and so on
> Thanks in advance and regards,
> Enric|||thanx
"Tibor Karaszi" wrote:

> systypes
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:0FEAE3E6-C6D8-400E-B210-F999DEBE6D17@.microsoft.com...
>
>

I don't remember how did I such thing...

Dear fellows,
I was wondering how it was for rename a database?
Thanks a lot for any input,
EnricOld way is sp_renamedb. As of SQL Server 2000, you can also (and preferred w
ay) ALTER DATABASE (see
Books Online for syntax).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:A10EAC4C-4AA0-4363-A17A-F62E8A66F0F3@.microsoft.com...
> Dear fellows,
> I was wondering how it was for rename a database?
>
> Thanks a lot for any input,
> Enric

I did So..

dear sir,

i am facing problem while making perspectives in sql server2005(Analysis Services) through C#.perspectives are made well but cant update within a Cube...i mean cant be added to a cube... i dont know what is the problem.so if someone can help me in this regard i will be really thankful to u.

Thanks.

Hi,

I would suggest you to post this question in any of the ADO related or SQL Services (Analysis Services) related forums.

There you should find a quick answer to your question.

Rgds,

Rodrigo

|||

dear sir,

i did post it on many of other forums like code project and microsoft india...but i dont know i got no clear response.anyhow thanks alot for giving me time and considering my problem...

thanks.

Adnan Khan.

|||

Moved to SQL Server Analysis Services forum.

Thanks.

|||

First question comes to mind after reading about your problem.

After creating perspective object did you do something like cube.Update(UpdateOptions.ExpandFull) ?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

dear sir,

thanks alot sir....i did appy ur option is working perfectly...thanks alot sir.....i am really happy for ur help...all my senior developers are shocked when i told then that i have done it......thanks alot sir....

Adnan khan..

|||

Edward,

Can you point us to anywhere that details what the three ProcessingOptions enum values actually mean?!?!

Thanks,

Steve.

|||

In following whitepaper you will find a table with processing options for Analysis Services objects

http://msdn2.microsoft.com/en-us/library/ms345142.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward, I appreciate the link and the information contained within. I would still like to see the documentation (BOL) covering items such as the UpdateOptions enumerator (values of Default, AlterDependants and ExpandFull) as well as the UpdateMode. Both of these have a column labeled 'Description' in BOL next to the enum values but these columns aren't populated. It tends to make coding against AMO a little hit and miss as to the intended outcome and actual outcome.

Thanks again,

Steve.

|||

well i am here find out how can i add or load pictures to a dll..i mean when i add that dll to a project all those images should me added also....i hope u will help me....

Thanks...

Adnan Khan.

sql

I couldn't access the Secondary Database after I finished Shipping Configuration

Dear All

Please I need an urgent help

After i finished all Transaction Log Shipping Configuration.

I tried to use the database in the secondary database but i couldn't access it

i saw it in SQL Managment Studio as (Restoring......)

i tired to make a database snapshot from it , i had a message

Msg 1822, Level 16, State 1, Line 1

The database must be online to have a database snapshot.

Please urgently

the secondary database is in a "Restoring" mode in this case, so you cannot take a snapshot of it. this is by-design.

if you do want take snapshot of the secondary database , you can choose the "standby"
mode when you configure the logshipping secondary db.

HTH.

thanks

Yunwen

I can't work out. Duplicate row

Dear all,
I am not be able to delete a row in the following table:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblSysRights]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblSysRights]
GO
CREATE TABLE [dbo].[tblSysRights] (
[sinRightID] [smallint] IDENTITY (1, 1) NOT NULL ,
[sinUserID] [smallint] NOT NULL ,
[sinApplicationID] [smallint] NOT NULL ,
[sinType] [smallint] NULL
) ON [PRIMARY]
GO
No indexes. No constraints. No relationships. What on earth hell is happenin
g?
SELECT *
FROM tblSysRights
WHERE (sinUserID = 61) AND (sinApplicationID = 163)
725 61 163 null
725 61 163 null
I obtain a warning which tell me:
"key column information is insufficient. too many rows affected"
Thanks in advance and best regards,Set RowCount 1
Delete
FROM tblSysRights
WHERE (sinUserID = 61) AND (sinApplicationID = 163)
Set RowCount 0
Madhivanan|||Enric,

> I am not be able to delete a row in the following table:
Can you be more specific?
From where and how are you trying delete the row?
AMB
"Enric" wrote:

> Dear all,
> I am not be able to delete a row in the following table:
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[tblSysRights]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
> drop table [dbo].[tblSysRights]
> GO
> CREATE TABLE [dbo].[tblSysRights] (
> [sinRightID] [smallint] IDENTITY (1, 1) NOT NULL ,
> [sinUserID] [smallint] NOT NULL ,
> [sinApplicationID] [smallint] NOT NULL ,
> [sinType] [smallint] NULL
> ) ON [PRIMARY]
> GO
> No indexes. No constraints. No relationships. What on earth hell is happen
ing?
> SELECT *
> FROM tblSysRights
> WHERE (sinUserID = 61) AND (sinApplicationID = 163)
> 725 61 163 null
> 725 61 163 null
> I obtain a warning which tell me:
> "key column information is insufficient. too many rows affected"
> Thanks in advance and best regards,
>
>|||Thanks for that Madhinavan.
Done successfully.
Thanks Alejandro, too.
Regards,
"Alejandro Mesa" wrote:
> Enric,
>
> Can you be more specific?
> From where and how are you trying delete the row?
>
> AMB
>
> "Enric" wrote:
>|||Just to add a couple of points. For elimination of duplicates, refer to:
http://support.microsoft.com/defaul...b;EN-US;q139444
Use keys in all your tables, and you will avoid a lot of such headaches. On
a related note, a couple of comments:
* You seem to have an identity column which is constrained to be unique, but
apparently it seems to be violated with SET IDENTITY_INSERT ON setting.
Check where the "hole" is.
* Your naming conventions are stale which can be better -- search for some
good guidelines in the archives of this newsgroup.
* Use Query Analyzer for testing your queries, the EM query interface is
buggy and has certain limitations.
* And most importantly, use primary keys in your tables. In relational
database, a value is identified using <table, column, key> triplet. With
duplicates, such identification becomes impossible and relational operations
cannot be used beneficially. The impossibility of logically deleting one row
out of duplicates is often cited as a prime illustration of the consequence
of allowing duplicates by SQL. ( SQL language inventors and its flag bearers
should take the credit, for even standardizing them ! )
Anith|||Thanks for that Anith.
That table was defined without identity fields or key. Just a mess-up.
Best Regards,
"Anith Sen" wrote:

> Just to add a couple of points. For elimination of duplicates, refer to:
> http://support.microsoft.com/defaul...b;EN-US;q139444
> Use keys in all your tables, and you will avoid a lot of such headaches. O
n
> a related note, a couple of comments:
> * You seem to have an identity column which is constrained to be unique, b
ut
> apparently it seems to be violated with SET IDENTITY_INSERT ON setting.
> Check where the "hole" is.
> * Your naming conventions are stale which can be better -- search for some
> good guidelines in the archives of this newsgroup.
> * Use Query Analyzer for testing your queries, the EM query interface is
> buggy and has certain limitations.
> * And most importantly, use primary keys in your tables. In relational
> database, a value is identified using <table, column, key> triplet. With
> duplicates, such identification becomes impossible and relational operatio
ns
> cannot be used beneficially. The impossibility of logically deleting one r
ow
> out of duplicates is often cited as a prime illustration of the consequenc
e
> of allowing duplicates by SQL. ( SQL language inventors and its flag beare
rs
> should take the credit, for even standardizing them ! )
> --
> Anith
>
>

I can't understand the meaning of a prediction query

Dear friends,
I'm reading Wiley's Data mining with SQL Server 2005... There are MANY things I can't understand about MovieClick example (Chapter 3).
I hope someone is going to help me with this troubles...

WARNING (1): I'm a dummy both with sql server and data mining.
WARNING (2): My English is not good at all.

Just two questions for now:

1) When I create the model to predict the number of bedrooms for homeowners, the book says to check BEDROOMS as Predictable... question: is it also an INPUT for the model, or PREDICTABLE only?

2) I'd like to keep this model (number of bedrooms.......) and make a prediction query.

- Query builder
- select case table -> Homeowners
- Drag the Customer ID column from the Homeowners table and drop it on the grid
- Drag the BEDROOMS column from the mining model and drop it on the grid.
- On the last row: Source=PredictionFunction, Field=PredictProbability
- Drag the BEDROOMS column from the mining model and drop it into Criteria/Argument
- Add (i.e.) 'Two or Three' to the field Criteria/Argument

I execute the query and I obtain many rows in a table with the following colums: CustomerID, BEDROOMS and Expression: WHAT DOES THIS MEAN?
WHICH INFO DO I GET FROM THOSE NUMBERS? WHAT CAN I LEARN FROM THEM?

Thanx a lot in advance, please help me!

1: It won't actually matter if you make it INPUT as well. When you mark something as PREDICTABLE, it generally means that the algorithm will try to learn about the data in that column. When you mark it as INPUT, it generally means that the algorithm will consider this column as information about the predictable columns. For trees, for example, the algorithm will create a tree for each predictable column, and the trees can have splits on the input columns. If you have a column that is marked INPUT and PREDICTABLE, in general, it only matters if you have more than one PREDICTABLE, since the columns don't act as inputs for themselves, for example, the tree for # of bedrooms isn't going to have a split on # of bedrooms, but if you also make Home Ownership predictable, than # of bedrooms could be a condition in the tree for Home Ownership. (the one exception is for clustering, but that's a longer explanation).

2: What do the numbers mean? The first column is just the customer ID from the input - this could also be the customer name, for example. The second column is the # of bedrooms predicted by the algorithm - that is, the count of bedrooms that has the highest probability of all options given the input. The last column is the probability that the # of bedrooms would be 'Two or Three'.

What can you use this for? Take for example you were building a model to predict whether people would buy a product. You would want to predict which people would buy or not buy. In addition, you would probably want to contact those people with the highest probability of buying - therefore you need to use the PredictProbability function with a specified value. As you learn to use the product more, you will see that you can use the Profit Chart to determine the maximum profit for a marketing campaign using a Mining Model. The chart will give you a probability threshold. You want to use this threshold in a DMX query to select all customers who have a probability higher than that threshold in order to achieve maximum profit.

Hope this helps

-Jamie

I am new for SQL Server please help me to write the code

Hi Dear all

I am new for SQL Server I know VB Programming and Access also but I don't know about SQL Server pls help me or guide me the web site.

Thank U in advance.http://www.w3schools.com/sql/default.asp

I am looking for a task which..

Dear all,
A couple of days ago I posted a request but nobody answered it.
I need a task which reports me all the NT users and groups in every
server/database and of course, their permissions.
The following excerpt is a part of the work:
declare @.sql varchar(300)
declare @.USER as char(25)
declare cursor1 cursor fast_forward for
select name from sysusers nolock where isntuser = 1 or isntgroup = 1
open cursor1
fetch next from cursor1 into @.USER
while @.@.fetch_status = 0
BEGIN
set @.sql = ('sp_helprotect NULL, ''' + lTRIM(rTRIM(@.USER)) + '''')
exec (@.sql)
fetch next from cursor1 into @.USER
end
close cursor1
deallocate cursor1
Thanks a lot and regards,Finding a list of server instances is something I haven't had to do before,
so I can't help you there.
sysdatabases lists the databases in an instance.
sysobjects lists the database objects, including tables (U), views (V),
procedures (P), and functions (FN, TF, IF)
sysprotects contains information about permissions, take a look a the
definition of the INFORMATION_SCHEMA.TABLE_PRIVILEGES.
I think syspermissions also contains permissions information.
Good luck! I would purchase a security audit tool instead. That way you
limit your liability and shift the focus of the leeches--oops, I meant
lawyers, to someone with deeper pockets.
It might be easier to generate a database creation script (script all
objects) for each database and parse the output.
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:7CDE748E-8426-4250-A52D-57DA7798F73E@.microsoft.com...
> Dear all,
> A couple of days ago I posted a request but nobody answered it.
> I need a task which reports me all the NT users and groups in every
> server/database and of course, their permissions.
> The following excerpt is a part of the work:
> declare @.sql varchar(300)
> declare @.USER as char(25)
> declare cursor1 cursor fast_forward for
> select name from sysusers nolock where isntuser = 1 or isntgroup = 1
> open cursor1
> fetch next from cursor1 into @.USER
> while @.@.fetch_status = 0
> BEGIN
> set @.sql = ('sp_helprotect NULL, ''' + lTRIM(rTRIM(@.USER)) + '''')
> exec (@.sql)
> fetch next from cursor1 into @.USER
> end
> close cursor1
> deallocate cursor1
>
> Thanks a lot and regards,

I am having trouble connecting to the database

Dear Sir -

I am new to thsi and I have installed the SQL server 2005 Dev (not express). I am useing Visual Web Express - When I create an application and attempt to launch it - the web config tell me that I am unable to connect to the Database - in the properties page (sidebar) the database status says closed - an I cannot seem to connect if though I go into the connections and test it says connected!

What is happening?

I need this to work? Can anyone assist?

Hi Harris,

Did you check your config file once, may be you passing wrong connection string.

Thanks & Regards,

Kiran.Y

I am having trouble connecting to the database

Dear Sir -

I am new to thsi and I have installed the SQL server 2005 Dev (not express). I am useing Visual Web Express - When I create an application and attempt to launch it - the web config tell me that I am unable to connect to the Database - in the properties page (sidebar) the database status says closed - an I cannot seem to connect if though I go into the connections and test it says connected!

What is happening?

I need this to work? Can anyone assist?

Hi Harris,

Did you check your config file once, may be you passing wrong connection string.

Thanks & Regards,

Kiran.Y

Hyperlink is not working

Dear all,

I would like to ask a question here about the hyperlink in reporting service.

I have programmed a report and it runs perfectly in my PC. Unfortunately when I deployed it to a server, the hyperlinks in that report can not be clicked. Is it because of the version at the server which is 9.00.2047.00? My development version is 9.00.3042.00.

Hope can hear from you soon. Thanks in advance.

Hi,

Not sure if this is a version issue, do you have a sub-report linked witht the hyperlink, if yes are you deploying that also to server....

|||

I have the same issue but my hyperlink has linked with other report with parametrs but doesn't work.

|||

Hi,

Parameters can be the problem. About using something like that for a report with parameters?

http://reporting.onsemi.com/ReportServer/Pages/ReportViewer.aspx?%2fProduct+Reports%2fProduct+Launch+Packages&rs%3aCommand=Render&Division=%23%23&RTM_Bucket=Last%206%20months

or something like that for another web site with parameters in the URL?

="javascript:void window.open('http://www.onsemi.com/PowerSolutions/product.do?id=" & CStr(Fields!WEB_PART_NAME.Value) & "&ppt=Y','_blank')"

or any combination of the above.

Note that in preview mode, the java script version will not work. It works only from the browser.

Regards,

Philippe

Hyperlink Datatype in SQL Server?!

Dear All,

I just want to know ,wheather there is any way to store 'hyperlink' in sql Table as in Ms Access.

or

What is the Procedure to store a Path of a file in SQL table and file should be able to retrieve through the query.

Thhank you

Graceson MathewI think that you will find that what you are asking for is a mix of back-end storage and front-end (client) formatting. Access really blurs the line between these two (very different) functions. SQL Server, on the other hand, is clearly a back-end storage system (ie, minimal client-side formatting features).

What you will end up having to do is to store text values for URLs and/or file locations and then use a client-side script/program/tool to format the data for presentation.

I personally like to pull the data using an ADO stream formatted in XML and then transform it with an XSL template. It's fast (as long as the recordsets aren't too big), it's flexible and gives you a great deal of control over how the data is represented.

This is not, however, the only solution.

Regards,

hmscott

Dear All,

I just want to know ,wheather there is any way to store 'hyperlink' in sql Table as in Ms Access.

or

What is the Procedure to store a Path of a file in SQL table and file should be able to retrieve through the query.

Thhank you

Graceson Mathew

Hyperlink

Dear friends,
How we can insert hyperlink column in a sql table? Is there is any datatype?
gracesonuse VARCHAR(255)|||If I remember correctly, if you want that other office applications would recognize the content of the field as a hyperlink, you should include it between "#', that is 'http://a.b.c' should be stored into your field as '#http://a.b.c#'