Click here to Skip to main content
15,914,335 members
Home / Discussions / Database
   

Database

 
GeneralRe: . MDF Pin
plural28-Aug-07 2:41
plural28-Aug-07 2:41 
QuestionGetting Last Day of Month: Pin
Shahzad.Aslam28-Aug-07 1:30
Shahzad.Aslam28-Aug-07 1:30 
AnswerRe: Getting Last Day of Month: Pin
mihirhp28-Aug-07 1:53
mihirhp28-Aug-07 1:53 
GeneralRe: Getting Last Day of Month: Pin
Shahzad.Aslam28-Aug-07 3:34
Shahzad.Aslam28-Aug-07 3:34 
QuestionRadioButtons are not working Pin
RaveRare27-Aug-07 18:46
RaveRare27-Aug-07 18:46 
AnswerRe: RadioButtons are not working Pin
Widgets30-Aug-07 22:43
Widgets30-Aug-07 22:43 
Questionsqlserver and msoffice Pin
kalyan_241627-Aug-07 18:13
kalyan_241627-Aug-07 18:13 
QuestionUsing SqlFacet Attributes for an SQL function Pin
~~~Johnny~~~27-Aug-07 11:17
~~~Johnny~~~27-Aug-07 11:17 
Hi, I wrote a function in C# to be used as a scalar function in SQL2005:

[Microsoft.SqlServer.Server.SqlFunction(IsPrecise = true, IsDeterministic = true, DataAccess = DataAccessKind.Read)]
public static SqlDecimal GetTaxAmountFromTax(SqlString tax, SqlDecimal amount)
{
SqlConnection conn = new SqlConnection("context connection=true");
SqlDataAdapter adap = new SqlDataAdapter("SELECT * FROM TransactionTaxes", conn);
DataTable taxTable = new DataTable();
adap.Fill(taxTable);
DataRow[] rows = taxTable.Select("[ID] = '" + tax.ToString() + "'");
if (rows.Length == 0) return SqlDecimal.Null;
if (rows[0]["CalculatedOnTax"] != DBNull.Value)
{
if ((bool)rows[0]["Cumulative"])
{
DataRow[] rows1 = taxTable.Select("[ID] = '" + rows[0]["CalculatedOnTax"].ToString() + "'");
if (rows1.Length == 0) return SqlDecimal.Null;
return ((amount + (amount * (decimal)rows1[0]["Rate"]) / new SqlDecimal(100))) * (decimal)rows[0]["Rate"] / new SqlDecimal(100);
}
else return amount * (decimal)rows[0]["Rate"] / new SqlDecimal(100);
}
else return amount * (decimal)rows[0]["Rate"] / new SqlDecimal(100);
}


I want to publish this function making sure the return type has a precision of 2 and a scale of 18. I found that I have to use the SqlFacetAttributes but I am unsure how to do it for a function. I found examples only for a Strored Procedure parameter.

Any help appreciated. Txs
QuestionSELECT MAX Pin
RichardBerry27-Aug-07 6:16
RichardBerry27-Aug-07 6:16 
QuestionRe: SELECT MAX Pin
Kschuler27-Aug-07 9:59
Kschuler27-Aug-07 9:59 
AnswerRe: SELECT MAX Pin
RichardBerry27-Aug-07 21:55
RichardBerry27-Aug-07 21:55 
GeneralRe: SELECT MAX Pin
Kschuler30-Aug-07 4:24
Kschuler30-Aug-07 4:24 
GeneralRe: SELECT MAX [modified] Pin
RichardBerry30-Aug-07 4:53
RichardBerry30-Aug-07 4:53 
AnswerRe: SELECT MAX Pin
Chris Meech27-Aug-07 10:45
Chris Meech27-Aug-07 10:45 
GeneralRe: SELECT MAX Pin
RichardBerry27-Aug-07 22:00
RichardBerry27-Aug-07 22:00 
GeneralRe: SELECT MAX Pin
RichardBerry27-Aug-07 22:12
RichardBerry27-Aug-07 22:12 
GeneralRe: SELECT MAX Pin
Chris Meech28-Aug-07 7:35
Chris Meech28-Aug-07 7:35 
GeneralRe: SELECT MAX Pin
RichardBerry29-Aug-07 1:43
RichardBerry29-Aug-07 1:43 
Question"Set Default" doesn't work [modified] Pin
Meysam Mahfouzi27-Aug-07 4:01
Meysam Mahfouzi27-Aug-07 4:01 
AnswerRe: "Set Default" doesn't work Pin
Meysam Mahfouzi27-Aug-07 5:23
Meysam Mahfouzi27-Aug-07 5:23 
Questionlarge scale inserts duplicate checking Pin
brsecu27-Aug-07 3:34
brsecu27-Aug-07 3:34 
AnswerRe: large scale inserts duplicate checking Pin
Michael Potter27-Aug-07 5:17
Michael Potter27-Aug-07 5:17 
QuestionSetting up POS [modified] Pin
dptalt27-Aug-07 3:21
dptalt27-Aug-07 3:21 
QuestionSQL Vs Oracle Pin
Ahamed Azeem27-Aug-07 2:43
Ahamed Azeem27-Aug-07 2:43 
AnswerRe: SQL Vs Oracle Pin
andyharman27-Aug-07 22:49
professionalandyharman27-Aug-07 22:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.