Syntax Description Help - *=

Mar 22, 2001

WHat does *= do in SQL syntax?

eg, SELECT * FROM Cars WHERE COLOR *= "Blue"

thanks,
Nick

View 1 Replies


ADVERTISEMENT

Incorrect Syntax Near The Keyword CONVERT When The Syntax Is Correct - Why?

May 20, 2008

Why does the following call to a stored procedure get me this error:


Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'CONVERT'.




Code Snippet

EXECUTE OpenInvoiceItemSP_RAM CONVERT(DATETIME,'01-01-2008'), CONVERT(DATETIME,'04/30/2008') , 1,'81350'




The stored procedure accepts two datetime parameters, followed by an INT and a varchar(10) in that order.

I can't find anything wrong in the syntax for CONVERT or any nearby items.


Help me please. Thank you.

View 7 Replies View Related

How To Get The Description ?

Jul 27, 2005

Hi,I have a SQL that is working fine:
SELECT DISTINCT T1.ATCkod FROM ATC_tot T1    JOIN ATC_tot T2 ON T2.ATCkod = T1.ATCkod and T2.Typ_lakemedel LIKE '%' + @Kod2 + '%'    JOIN ATC_tot T3 on T3.ATCkod = T1.ATCkod AND T3.Typ_lakemedel LIKE '%' + @Kod3 + '%'    WHERE T1.Typ_lakemedel = @KodNow I need to have a description together with the ATCkod, tablename ATC columnname ATCdesc. ATC_tot.ATCkod = ATC.ATCkod. I have tried Inner join without success. Any good suggestions ...?

View 1 Replies View Related

Incorrect Syntax When There Appears To Be No Syntax Errors.

Dec 14, 2003

I keep receiving the following error whenever I try and call this function to update my database.

The code was working before, all I added was an extra field to update.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WHERE'


Public Sub MasterList_Update(sender As Object, e As DataListCommandEventArgs)

Dim strProjectName, txtProjectDescription, intProjectID, strProjectState as String
Dim intEstDuration, dtmCreationDate, strCreatedBy, strProjectLead, dtmEstCompletionDate as String

strProjectName = CType(e.Item.FindControl("txtProjectName"), TextBox).Text
txtProjectDescription = CType(e.Item.FindControl("txtProjDesc"), TextBox).Text
strProjectState = CType(e.Item.FindControl("txtStatus"), TextBox).Text
intEstDuration = CType(e.Item.FindControl("txtDuration"), TextBox).Text
dtmCreationDate = CType(e.Item.FindControl("txtCreation"),TextBox).Text
strCreatedBy = CType(e.Item.FindControl("txtCreatedBy"),TextBox).Text
strProjectLead = CType(e.Item.FindControl("txtLead"),TextBox).Text
dtmEstCompletionDate = CType(e.Item.FindControl("txtComDate"),TextBox).Text
intProjectID = CType(e.Item.FindControl("lblProjectID"), Label).Text

Dim strSQL As String
strSQL = "Update tblProject " _
& "Set strProjectName = @strProjectName, " _
& "txtProjectDescription = @txtProjectDescription, " _
& "strProjectState = @strProjectState, " _
& "intEstDuration = @intEstDuration, " _
& "dtmCreationDate = @dtmCreationDate, " _
& "strCreatedBy = @strCreatedBy, " _
& "strProjectLead = @strProjectLead, " _
& "dtmEstCompletionDate = @dtmEstCompletionDate, " _
& "WHERE intProjectID = @intProjectID"

Dim myConnection As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("connectionstring"))
Dim cmdSQL As New SqlCommand(strSQL, myConnection)

cmdSQL.Parameters.Add(new SqlParameter("@strProjectName", SqlDbType.NVarChar, 40))
cmdSQL.Parameters("@strProjectName").Value = strProjectName
cmdSQL.Parameters.Add(new SqlParameter("@txtProjectDescription", SqlDbType.NVarChar, 30))
cmdSQL.Parameters("@txtProjectDescription").Value = txtProjectDescription
cmdSQL.Parameters.Add(new SqlParameter("@strProjectState", SqlDbType.NVarChar, 30))
cmdSQL.Parameters("@strProjectState").Value = strProjectState
cmdSQL.Parameters.Add(new SqlParameter("@intEstDuration", SqlDbType.NVarChar, 60))
cmdSQL.Parameters("@intEstDuration").Value = intEstDuration
cmdSQL.Parameters.Add(new SqlParameter("@dtmCreationDate", SqlDbType.NVarChar, 15))
cmdSQL.Parameters("@dtmCreationDate").Value = dtmCreationDate
cmdSQL.Parameters.Add(new SqlParameter("@strCreatedBy", SqlDbType.NVarChar, 10))
cmdSQL.Parameters("@strCreatedBy").Value = strCreatedBy
cmdSQL.Parameters.Add(new SqlParameter("@strProjectLead", SqlDbType.NVarChar, 15))
cmdSQL.Parameters("@strProjectLead").Value = strProjectLead
cmdSQL.Parameters.Add(new SqlParameter("@dtmEstCompletionDate", SqlDbType.NVarChar, 24))
cmdSQL.Parameters("@dtmEstCompletionDate").Value = dtmEstCompletionDate
cmdSQL.Parameters.Add(new SqlParameter("@intProjectID", SqlDbType.NChar, 5))
cmdSQL.Parameters("@intProjectID").Value = intProjectID

myConnection.Open()
cmdSQL.ExecuteNonQuery
myConnection.Close()

MasterList.EditItemIndex = -1
BindMasterList()


End Sub

Thankyou in advance.

View 3 Replies View Related

Which Is Faster? Conditional Within JOIN Syntax Or WHERE Syntax?

Mar 31, 2008

Forgive the noob question, but i'm still learning SQL everyday and was wondering which of the following is faster? I'm just gonna post parts of the SELECT statement that i've made changes to:

INNER JOIN Facilities f ON e.Facility = f.FacilityID AND f.Name = @FacilityName

OR

WHERE f.Name = @FacilityName


My question is whether or not the query runs faster if i put the condition within the JOIN line as opposed to putting in the WHERE line? Both ways seems to return the same results but the time difference between methods is staggering? Putting the condition within the JOIN line makes the query run about 3 times faster?

Again, forgive my lack of understanding, but could someone agree or disagree and give me the cliff-notes version of why or why not?

Thanks!

View 4 Replies View Related

Converting Rrom Access Syntax To Sql Syntax

Sep 23, 2007


Ok I am tying to convert access syntax to Sql syntax to put it in a stored procedure or view..
Here is the part that I need to convert:

SELECT [2007_hours].proj_name, [2007_hours].task_name, [2007_hours].Employee,
IIf(Mid([task_name],1,3)='PTO','PTO_Holiday',
IIf(Mid([task_name],1,7)='Holiday','PTO_Holiday',
IIf(Mid([proj_name],1,9) In ('9900-2831','9900-2788'),'II Internal',
IIf(Mid([proj_name],1,9)='9900-2787','Sales',
IIf(Mid([proj_name],1,9)='9910-2799','Sales',
IIf(Mid([proj_name],1,9)='9920-2791','Sales',

)
)
)
)
) AS timeType, Sum([2007_hours].Hours) AS SumOfHours
from................

how can you convert it to sql syntax

I need to have a nested If statment which I can't do in sql (in sql I have to have select and from Together for example ( I can't do this in sql):
select ID, FName, LName
if(SUBSTRING(FirstName, 1, 4)= 'Mike')
Begin
Replace(FirstNam,'Mike','MikeTest')
if(SUBSTRING(LastName, 1, 4)= 'Kong')
Begin
Replace(LastNam,'Kong,'KongTest')
if(SUBSTRING(Address, 1, 4)= '1245')
Begin
.........
End
End

end




Case Statement might be the solution but i could not do it.






Your input will be appreciated

Thank you

View 5 Replies View Related

How Can I Set Description Property By T-SQL ?

Jun 6, 2007

I would like to create table by T-SQLand need to specify DescriptionBut I can't find any sample to add Description property by T-SQL  Additionally, I also would like modify Description property by T-SQL. What can I do ?????  Please help me ...... 

View 2 Replies View Related

Description Field

Sep 30, 2004

Hi

Getting an error on the following SQL. The field in question is the Description field which has * in the description. Not sure how I should have the SQL to solve this

UPDATE Taylors
SET Area=::Area::,Avail=::Avail::,Address=::Address::,Type=::Type::,Price=::Price::,Bedrooms=::Bedrooms::,HotProps=::HotProps::,Office=::Office::,Description=::Description::
WHERE RefNo =::RefNo::


Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '* modern retirement flat * double bedroom * south lounge * fitted kitchen * good size bathroom * communal gardens * residence parking *'.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

View 1 Replies View Related

Column Description

May 18, 2005

Hello, it seems I forgot how to do it,
I want to create a query to get the column description table, I mean get structure without data.
I remember it was select DESC or something like that, donno if im right!!!
 
regards

View 6 Replies View Related

Getting Error Description

Dec 29, 2005

Hi all,
I need to get the error description from the SQL Server in a SP. For ex:

I have one insert statement which is inserting some values in a tabUserMaster table. If user tries to insert any duplicated row then following error is retruned [in Query analyzer].

Server: Msg 2601, Level 14, State 3, Procedure csp_ProvisionUser, Line 70
Cannot insert duplicate key row in object 'CoreUser' with unique index 'IDX_CoreUser_UserName'.
The statement has been terminated.

I want to trap this whole message in a variable. How to do this..... :(

View 5 Replies View Related

Description Column In SP

Dec 17, 2013

I am having trouble bringing "description" column in to my sp and them at the out put. in the ppatient_status_mstr there is a column called“description” which has patient status such as “discharged” “termed collection” etc... How do I use the SP to bring this description into application? I am assigning it to @mytext. I am not sure how to declare “description” in the SP? Every time I use it I get errors like:

Msg 4104, Level 16, State 1, Procedure CheckStatus, Line 20
The multi-part identifier "pm.alerts_ind" could not be bound.
Msg 207, Level 16, State 1, Procedure CheckStatus, Line 40
Invalid column name 'description'.
Msg 207, Level 16, State 1, Procedure CheckStatus, Line 43
Invalid column name 'description'.

I want to say if user picks a description from application . show me that description in output. But I am having trouble how to use the description? I am not sure if my “IF” statements are correct either?

Here is the procedure

ALTER PROCEDURE [dbo].[CheckStatus] (@enc_id varchar(36) OUTPUT, @Mytext varchar(50) OUTPUT, @data_ind Char(1) OUTPUT)
AS
BEGIN
DECLARE
@alerts_ind char(1)

[code]....

View 20 Replies View Related

Tables Description

Jun 3, 2007

I have hundreds of tables in my database.
Is there a way to get a list of them with a description
of their content (the procedure and the transaction they
are related to, the way columns are created)?

Thank you. Anna - Verona (Italy)

View 2 Replies View Related

Columns Description How To Use It On QA

Sep 20, 2007

how do you use columns description on QA? I want to type it in some description for my columns. I see this option on EM. Need to know how to do it on QA

=============================
http://www.sqlserverstudy.com

View 19 Replies View Related

Get The Description Of A Column

Jul 23, 2005

Okay guys heres the senario.I have written a kick butt asp application that allows me to test sqlstatements and manage/display all my databases from the web but I havea feature I want to include that I can't figure out how. In EnterpriseManager, one of the column editable properties is the ColumnDescription. I can't find it in sql server itself. only in theEnterprise Manager. I need to access it using a sql statement so thatit will display in my table definiation view that I create in the aspapp.

View 1 Replies View Related

Get Description In Table

Jul 20, 2005

i want get fields description in structure tables that i madetables.please help me for resolve this problem .thank you

View 2 Replies View Related

Table Description

Jul 20, 2005

Hi All,In SQL Server how can I get the descriptions of tables in adatabase?From MSDN help I could find a way to get the description of columnsusing the following extended propertySELECT *FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table','Reports', 'column', default)ThanksRegardsSobhan

View 1 Replies View Related

Error Description

Nov 1, 2006

I want to club the ErrorDescription system variable property in OnError.

And I want to send this whole ErrorDescription variable on onTaskFailed.

Can you please suggest how to club this errordescription on OnError event



View 5 Replies View Related

ErrorCode Description

Dec 11, 2007



This is a request to the Microsoft SSIS staff.
I did a search for the keywords in the description and can already see a lot of people frustrated about this.

A lot of well designed integration packages will route error messages to an error table or file.
SSIS appends a couple of extra error columns called ErrorCode and ErrorColumn. At runtime, an extra
column is visible in the DataViewer called ErrorCode - Description.

The description is hardcoded into the dtsmsg.h file in the SDK folder of Sql Server.
This file is very hard to parse.

Can some from SSIS please post an XML or CSV file with all the error codes and descriptions for us to download please.
This will be such a big help in debugging.

Many Thanks.


Shailen Sukul
Software Architect/Developer/Consultant
(BSc | Mcts (Biztalk (IP)) | Mcpd | Mcts (Web, Win, Dist Apps) | Mcsd.NET | Mcsd | Mcad)
Ashlen Consulting Services Pty Ltd
(http://www.ashlen.com.au)
MSN | Skype | GTalk Id: shailensukul
Ph: +61 0421 277 812
Fax: +61 3 9011 9732
Linked In: http://www.linkedin.com/in/shailensukul

View 3 Replies View Related

Number / Description Of Sql Error

Oct 24, 2006

HiAll Sql Server errors have a number. Is there any MS or MSDN website or any .net method in which I can see these errors?Thanks a lotswitch (error.Number){case 17:msgErro =....break;case 4060:msgErro = ....break;case 18456:msgErro = .....break;default:msgErro = exSql.Message;break;}

View 2 Replies View Related

Searching In Title And Description

Apr 29, 2007

hey guys, so i have my website, everything is ok, until i have to put in a title field, along side my description. so far i have this code which searches in the description, how can i make it so i can search in the title as well
SelectCommand="SELECT [Stock_ID], [cat_id], [description], [size],
[selling_price], [qty], [picture1] FROM [tbl_stock]
WHERE ([description] LIKE '%' + @description + '%')">
 Any help would be great
 Cheers
Jez

View 2 Replies View Related

Item Description In Shorthand

Jun 29, 2005

Hi,

If you browse to Amazon and drill down through categories until a paged
listing appears, you will see in each item of the listing that the
description rendered as Book Description, is a cutdown version of the
full description, with a ... and "Read More" hyperlink.  How is
this achieved programatically? I dont know if thre is an efficient way
in SQL Server to do this, or whether it would be easier to have a
ShortHand field and a Description field, both of which are teh full
description when shown in the Details page, but the ShortHand is the
field rendered in listings.  This seems like a simplistic solution
and I am thinking there may be programmatic means of doing the same -
has anybody got any experience in this area?

Thanks!

jr.

View 4 Replies View Related

SQL Server2000 And COLUMN DESCRIPTION

Nov 16, 2001

HI

I have a big problem with SQL server2000. I can't get COLUMN DESCRIPTION.
I will print DATADICTIONARY from a DB, I can get all elemnts (table name, columns name, datatype, precision, scale, FK, PK, default value..) I missed only DESCRIPTION. How I can get it????

Medo

View 1 Replies View Related

Description Of *.ldf File Format

Apr 28, 2002

do anyone know the format of the *.ldf file?

View 2 Replies View Related

Accessing Description Field

Mar 20, 2001

On the Design Table screen for SQL 2000 there is a Description field along with the Default, Identity, etc. options. Once I put a description in there, is there a way to retrieve it through T-SQL?

Thank you!

View 2 Replies View Related

Table Description Information

Jul 20, 2000

In oracle there is a describe command:
describe table_name
This command will tell you the columns names, datatypes, and length of the columns for that particular table. Does anyone know if there is a simliar command in SQL server that would do that? The only way that I have found so far is to do a join of the syscolumns with sysobject by table name.

View 2 Replies View Related

Where Is "description" Col In Repository Metadata

Apr 20, 2000

I'm trying to create a Data Dictionary view from system table info like tablename, fieldname, datatype etc. I can find all that I need except for the "description" field which is displayed in Enterprise Manager/ Repository metadata pane.

How can I locate this field so I can reference it in a view? Isn't it stored in a system table? Master, model? Where is it?

Thank in advance,

Phil

View 1 Replies View Related

Accessing Description Field

Mar 20, 2001

On the Design Table screen for SQL 2000 there is a Description field along with the Default, Identity, etc. options. Once I put a description in there, is there a way to retrieve it through T-SQL?

Thank you!

View 1 Replies View Related

List Column Name And Description

May 26, 2006

Hello everybody,

If I know the table name, is there any command to list all "Column Name" and the Columns "Description" as shown in the Design Table window.

Any feedback is welcome!

Thank you,

Edi

View 3 Replies View Related

Systems Analyst - Job Description

Apr 7, 2004

Does anyone have a description of what is a System Analyst responsibility should involve. I was recently assigned the title and is no longer sure what my responsibility should entail. I asked mgmt for a description. Still waiting.

Thanks.

View 8 Replies View Related

Description Properties In SQL 2000

Jul 15, 2001

A query to get the Table and Column Description fields in SQL Server 2000.


SELECT so.name, sc.name, sc.xtype, sc.length, sc.colid,
tableprop.value as TableDescription,
colprop.value as ColDescription

FROM

sysobjects so

INNER JOIN syscolumns sc ON sc.id = so.id
INNER JOIN sysproperties tableprop ON tableprop.id = so.id and tableprop.type = 3
INNER JOIN sysproperties colprop ON colprop.id = sc.id and colprop.type = 4
and colprop.smallid = sc.colid

WHERE so.type='u' and so.name = 'TableName'

Order by sc.ColID





Damian

View 2 Replies View Related

Adding A Table Description

Jul 31, 2007

Hi everyone,

I'm using SQL 2005. I want to add a description for each table on my database. How do I do that? I know I can add a description to each field, but how do I add a description to each TABLE? I tried going to Properties but don't see anything.

Grateful for any help. Thanks.

View 12 Replies View Related

Get And Set Column Description From Sql Server2005

Aug 10, 2007

I dont know,how can I get column description from Sql Server 2005 and use it in vb.net 2005? would you please help me solve it?

View 1 Replies View Related

Set COLUMN Description In .Net 2005,

Aug 13, 2007

Hi,
I want to set column description in .Net 2005, Please guide me.
thanx very much

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved