Database

Imtiaz Murtaza wrote:

I want to insert a new row in my table which is supposed to be the ditto copy of one of the previous rows. Now the problem is that there is one field in my table having datatype text. This column value is not getting copied from source to destination and i get error from SQL server that it is not allowed to copy text, nvarchar and binary types.

Insert Into t4 (f1,f2) Select f1, f2 From t4 Where f1=2

Imtiaz Murtaza wrote:

Now if i convert the column value to varchar then it gets coppied. But i dont want to convert it to varchar because varchar has a limit of 8K characters, and my text column may contains more than 8K characters; and they get truncated while converting to varchar.

Please tell me how to copy the text datatype value from one row to the other.

Insert Into t4 (f1, f2) Select f1, Substring(f2,1,8000) + Substring(f2,8001,8000) from t4 where f1=3

<xs:schema 
...
xmlns:codegen="urn:schemas-microsoft-com:xml-msprop"
...
>
...
<xs:element name="d" type="xs:dateTime" codegen:nullValue="2006-01-01T00:00:00" minOccurs="0" />
...

<br />
...<br />
tds.t.tRowChanged += new tRowChangeEventHandler(t_tRowChanged);<br />
...<br />
<br />
private void t_tRowChanged<br />
(object sender, TDS.tRowChangeEvent e)<br />
 {<br />
  if(e.Action == DataRowAction.Add)<br />
  {<br />
   e.Row.d = e.Row.d;<br />
  }<br />
}<br />

<br />
private void t_tRowChanged<br />
(object sender, TDS.tRowChangeEvent e)<br />
{<br />
if(e.Action == DataRowAction.Add)<br />
{<br />
e.Row.d = e.Row.d;//What????????:omg:<br />
}<br />
}<br />

<br />
...<br />
SqlCommand insertCommand = new SqlCommand(...);<br />
insertCommand.CommandType = CommandType.StoredProcedure;<br />
insertCommand.CommandText = "YourSPNameHere";<br />
...<br />

<br />
private void t_tRowChanged<br />
(object sender, TDS.tRowChangeEvent e)<br />
{<br />
 if(e.Action == DataRowAction.Add)<br />
 {<br />
  e.Row.d = System.DateTime.Now;<br />
 }<br />
}<br />

select * from Users
where not exists (
  select A.AppID from Applications A 
  where A.AppID = Users.AppID
)

NK7 wrote:

we can do this is sql server by isnull(c.constraint_type,'')

Swisher24 wrote:

"oledbadapter.InsertCommand(Insert Into table1 from )"

error(s):
(249): Comma, ')', or a valid expression continuation expected.
(249): Property access must assign to the property or use its value.

oledbadapter.InsertCommand = someSqlString

Swisher24 wrote:

I'm having problems figuring out what to put after the "from" statement

INSERT INTO Table1(Column1, Column2, Column3) VALUES ('value1', 'value2', 'value3')