bubu (5/12/2009)

---

Well the authentication will be done using an user name and a password for every user, different levels of authentication and of rights. That's why I'm a little confused,...

duplicate post..................;-)

you can transfer the data from one server to another, using linked server, openrowset, bcp for more info see SQL BOL.

kapalselambiru (5/6/2009)

---

my mistake.its MySQL Server 4.01 and 5.01..If that you are suggesting,could you please help me to completely uninstall it? n what is the meaning of "SQL error 10061"?how can...

also use,...

stelianx (5/6/2009)

---

I need the precision of a decimal value to be dynamically controlled. Example:

DECLARE @input as decimal(16,6)

SET @input = 1.234567

DECLARE @precision INT

SET @precision = 2

...

you can use bcp command to process the flat files. this is very fast, for more info see SQL BOL.

try like the following

declare@sqlquerynvarchar (1000)

,@SQLOperatornvarchar (10)

,@DateTimedatetime

set@SQLOperator= '>='

set@DateTime= getdate ()

set@sqlquery= 'select * from sysobjects where crdate ' + @SQLOperator + ' ''' + convert (varchar (10), @DateTime,...

use dynamic query, for more info see SQL BOL.

use trigger on that table, for more info see SQL BOL.

you can import data from excel file to sql table in many ways, like use OPENROWSET, for more...

nageswara.dhaveji (4/23/2009)

---

Hai Everybody,

I have a doubt.. if one variable is having datatype as varchar in one table and integer in another table and when we are comparing both columns, will...

check you query in Microsoft site.

Depends on table structure and many other factors, provided information is in-sufficient. For more information see SQL BOL and search for "Database Design Considerations".

use the below code in your C# application:

DateTime.Now.ToString("G", DateTimeFormatInfo.InvariantInfo

for more information see help.