Viewing 15 posts - 286 through 300 (of 369 total)
Double posted! See reply in other posting:
http://www.sqlservercentral.com/Forums/FindPost475040.aspx
March 26, 2008 at 1:15 pm
&rs:Command=Render&rs:id_user=66
You're making the same mistake I made when specifying parameters in a URL.
The report parameters don't have the "rs:" "RS" is for Report Server parameters.
So your URL should look...
March 26, 2008 at 1:10 pm
I'm with Jeff and others about using a source code control system.
In our environment we continually create new databases (for new customers) and upgrade all existing databases (customers) when we...
March 25, 2008 at 7:34 am
For what? Got an example of the PL/SQL that you're talking about?
Oracle PL/SQL reference: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/controlstructures.htm#sthref912
I will state that the simple syntax example could be done with a SELECT statement,...
March 21, 2008 at 7:41 am
If you create the new database, then the answer is correct.
Not exactly true. It will be set 90 unless the model database has a lower compatibility level. (From BOL)....
March 20, 2008 at 1:05 pm
9i was when they also came out with CASE to "replace" decode... SQL Server had it for about a million years before that
True. OK, one for the SQL Server...
March 19, 2008 at 12:21 pm
They didn't even know 10G had a MERGE statement
Actually, the MERGE statement was introduced in 9i (circa 2002) along with all of the new date and time datatypes that are...
March 19, 2008 at 11:39 am
I have done this before but when i right click the database thn there is no option of reports .Thats y i am confused that what is ssms .and plz...
March 19, 2008 at 11:19 am
Does 2005's (sp2) vardecimal option have any affect on "money" type fields?
Per the BOL, money is 8 bytes and smallmoney is 4 bytes. Which means that they are...
March 19, 2008 at 11:16 am
which is also checking if new data then insert and if existing one then it will update the data
You could also be using the new MERGE statement that will be...
March 18, 2008 at 7:43 am
I would create two different secondary parameters, populated by the appropriate queries, and then show/hide the appropriate parameter based upon the selection of the first parameter.
March 17, 2008 at 11:21 am
"with execute as owner" is the best way around that issue, but be very careful that you can't use that procedure to incorporate SQL INJECTION.
Agreed. Prevention of SQL injection...
March 13, 2008 at 7:14 am
Why not code the procedure with WITH EXECUTE AS OWNER vs. a specific user id?
If dbo owns the procedure, then the impersonation will occur under the covers. That is...
March 12, 2008 at 7:35 am
Thanks Jeff for this reminder.
What we also need to eliminate are:
1. The postings where the poster didn't even bother to look at the online documentation (Books Online aka BOL) first....
February 22, 2008 at 11:58 am
It would appear that the two servers are not configured the same.
Check the document types supported and filters used by querying the sys.fulltext_document_types table on both servers and comparing the...
February 19, 2008 at 6:54 am
Viewing 15 posts - 286 through 300 (of 369 total)