|
It's used to convert a string literal to wide character.
for example. If you have a column with nvarchar and you want to compare it with a string (where mycol= 'abc') you should make it like: (where mycol= N'abc')
you'll not notice that the first will not give the expected results unless you use a language other than English (Arabic strings for example).
|
|
|
|
|
hey thanks for this information.......
Thanks,
Ankur Bakliwal
|
|
|
|
|
hello all,
am using sqlserver 2000 as my database. my problem is am the DB administrator. i totally granting Permission to 10 user. i want to restrict 3 user can only access the DB at a time. All the others trying to enter, then it will shows that already 3 user's login u should try after some time...
Is It Possible? Please help me to solve this Problem.
|
|
|
|
|
Yes.
SQL server licensing can be set from control pannel.
by which max number of simultanious connections can be controlled.
Regards
KP
|
|
|
|
|
hello Mr.Krish
Can u tell me the details... how to do it? in control panel where i have to restrict? Please tell me more about such things.
|
|
|
|
|
Start -> Settings -> Control Panel -> SQL Server 2000 Licensing setup
need to set "per seat for" form the "Choose Licensing Mode" dialog box
Regards
KP
|
|
|
|
|
I couldn't find any sql server 2000 licensing setup in Control panel. what can i do now? else where it is actually resides?
|
|
|
|
|
I was tried your suggestion. in that case i am getting some error. i also want to know how to do it without any errors.error is come from my software
only but i dont know how to solve it.
Am going to controlpanel->administrative tools->computer management->services and application->microsoft sqlserver->localwindowsNT then its property am changing the connections to zero to five. whenever am doing this the computer management console not responding and am also not able to start my database services. it was shown some error message and the error number is -1073741724. what it is? how to rectify it? Please help me....
|
|
|
|
|
Pls set per seat
for any errors pls give full error message displayed. with would help in solving the same.
Regards
KP
|
|
|
|
|
Please tell me the full details how to set per page connections?
|
|
|
|
|
hi
i have sql server 2000 personal in server, and i want connect to it from client by vc#2005, but the following error shown me :
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
how to solve my problem ??
thanks
|
|
|
|
|
Your query is not clear.
is that you are trying to access from an application
if so, which one.
or from Query analyzer directly use the sql statements.
of from enterprise manager is a graphical interface.
Regards
KP
|
|
|
|
|
from Query analyzer.
task description is:
I have central sql2000(general office) db and several(5) sql2000 db as 5 point of sales.
GeneralOffice need fresh data about realizaton in stores as they need fresh data about new articles and price modification etc.
Connecton is by dial-up(modem connection).
I have one solution: create an xml file wich is transfer over network, but it is slowly and complicated for employees in stores.
My second idea is creating linked server but i have no experience in subject.
Any idea about this task is very helpful.
Deadline is monday!
|
|
|
|
|
one option is use DTS, get db to local instance. which would be faster.
(if is a offline transaction)
for accessing a different instance need to link using sp_addserver / sp_addlinkedserver
Regards
KP
|
|
|
|
|
I want to use Data Access Application Block for accessing my MS Access database.
Is it possible with out making changes in Enterprise Library 2.0?
M.Sendilkumar
|
|
|
|
|
Yes that is what it is designed for.
Use the configurator to attach to the backend Access db then try and run some code againist it.
You might be better of with SQL express 2005 if your target server can handle it.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
Can you tell me what exactly I need to do?
M.Sendilkumar
|
|
|
|
|
Does exist a command (like insert) to copy all records from a table to other with a condition? Let's assume than both have axactly record configuration... thanks
|
|
|
|
|
INSERT INTO DestinationTable<br />
SELECT Columns<br />
FROM SourceTable<br />
WHERE condition = whatever
|
|
|
|
|
select * from tableA
insert tableB
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
Hey guys.
I was wondering if it is possible to join two tables from different databases together.
Here is what I want to do:
TableAdapter1 would get data from file AccessDB1, from Table1.
TableAdapter2 would get data from file AccessDB2, from Table2.
Once this is done, I want to join/merge/connect the two tables together in a new DataTable in memory and be able to query this new table.
An example of what I want to do is this:
I have two Access files. The first contains Table1 that has a date column and a value column. The second Access file contains Table2 that has a date column and an exchange rate column.
What I want to do is to produce a new table in memory (i.e. Datatable) that will contain a date column, a value column, and exchange rate column, AND a new column ExchangedValue that will contain the results of value column * exchange rate column.
Can this be done? The concern here is the fact that the two tables where taken from different database files.
Thanks and regards..
The perfect code is always in your head...it just a matter of how hard you bang your head against the wall to get it out!
|
|
|
|
|
you can do this in SQL Server, even on differet db servers if you setup a linked server.
select * from
salesdb.dbo.customers inner join customer.dbo.customer
on salesdb.dbo.customers.id inner join customer.dbo.customers.id
Hope this helps
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)
http:\\www.frankkerrigan.com
|
|
|
|
|
how to create sql database wit userdefined name at run time.
please help
thanx
taher
|
|
|
|
|
taherjaorawala wrote: how to create sql database wit userdefined name at run time
Like anything else - you issue a SQL command, in this case to CREATE DATABASE.
|
|
|
|
|
I am using vb.net as front end I want to make database at runtime and name the database whatever user wants
plase help
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
