|
hi all,
the following statement Installed the SQL Server with SQL AUthentication mode with USER 'SA' when we run this command in command promopt
C:\SQLEXPRFiles\setup.exe /qb ADDLOCAL=ALL INSTANCENAME=myInstance SECURITYMODE=SQL SAPWD=mypassword DISABLENETWORKPROTOCOLS=0
but i want to create A different login(instead of 'sa') so what Parameter is required with above statement.
|
|
|
|
|
My friends & I have a problem with our one of the table of our SQL Data...
One of our Table Column shows like this when we view it in sql :
ChaInvent
<binary>
We dont know how to read & edit inside that CharInvent..??
That ChaInvent has all the information we need because that is place where are all the Inventory on the Game of the Character stored like weapons, armors, potion, ..etc..haysss..Any Help here?
Are there any script or program that can read & interpret those data readable by Human?? I tried to search all the Info here but NO LUCK...
|
|
|
|
|
you always get binary data when running a select.
It depends on the client how to process it, mostly it becomes a array of bytes.
You can show it by storing it to file or convert it to strings to show it in a memo or listbox.
You probably used the sql studio manager for viewing data,
this is not showing you binary data.
greetz
kurt
|
|
|
|
|
...."You can show it by storing it to file or convert it to strings to show it in a memo or listbox"...
How?? we don't know, Please Help us...
|
|
|
|
|
Or you can write a program in you're language. for example C#
or build a query like this..
EXEC master.dbo.sp_configure 'show advanced options',1 RECONFIGURE
EXEC master.dbo.sp_configure 'xp_cmdshell', 1 RECONFIGURE
declare @query varchar(500)
set @query = 'BCP "SELECT * FROM YourTable" queryout "C:\YourTable.txt" -c -T -C850 -S(local)\SQLEXPRESS -Usa -Psa'
EXEC master..xp_cmdshell @query
EXEC master.dbo.sp_configure 'xp_cmdshell', 0
RECONFIGURE EXEC master.dbo.sp_configure 'show advanced options', 0
RECONFIGURE
Be sure you're sql server has rights to write on the HD. (set local system account of you're SQL service)
greetz
Kurt
|
|
|
|
|
I heard that is not possible to disable database attach. Is that accurate?
Better way is to encrypt data. But ... encrypt is about string isn´t it? how can i encript other types of data? if it´s an int the database structure won´t accept other type, do you copy me?
id|f_name|l_name|age|
11 john silva 29
24 glen berger 45
39 dan smith 34
40 luiz owen 41
id|f_name|l_name|age|
d22wfd kfvjff fgvfrer feef
5rfrfb 37bfjkr r43hifi85 kfnrk3ifn
rrui8 r44r 4rh4i ni43i
What do you think?
nelsonpaixao@yahoo.com.br
|
|
|
|
|
nelsonpaixao wrote: What do you think?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi,
i want to retrieve creationDate and time from a file on the server HD
by using a query.
anyone any idea how i can do this?
thx
Kurt
|
|
|
|
|
Hi,
First thing that comes in mind is to create a small assembly using c#. Implement a method to extract file info you need and then install and register it to SQL Server. After that you can use this custom function in t-sql.
Mika
|
|
|
|
|
Take a look at xp_cmdshell.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
OK thx.
if i can get the result of XP_CmdShell, i can manage it.
greetz
Kurt
|
|
|
|
|
hi all,
i want to Create login on SQL Server EXPRESS .How can i create this login using SMO. ?
Plesae provide me some useful link or code snippet. Also how can i create login for database which is on SQL Server.
|
|
|
|
|
Thought about Google
Loads of articles and examples
^]
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi folks,.
Can any1 let me know how to sum the time component of two time values in oracle?
for e.g s = 09:00
t = 19:09
i want to add s and t
T.Balaji
|
|
|
|
|
Hi,
There are two questions concerning this:
- what about the date portion. Should the start date be current date (in your example the result goes to next date)
- what are the datatypes for time components, dates, strings?
This SELECT should give you some starting point to adding elements to a date. This returns first day of this month reflected to desired time (variable s) and then added with given time (variable t) and the result is formatted to string to see all the elements:
SELECT TO_CHAR( SYSDATE,
'dd.mm.yyyy hh24:mi:ss'
) AS CurrentTime,
TO_CHAR( TO_DATE('09:00','hh24:mi') -- results in first day of this month at 09:00
+ INTERVAL '19' HOUR -- adding hours
+ INTERVAL '09' MINUTE, -- adding minutes
'dd.mm.yyyy hh24:mi:ss' -- formatting
) AS AddedTime
FROM dual;
And the result:
CURRENTTIME ADDEDTIME
6.8.2008 21:18 2.8.2008 4:09
Notice that when using only time portion in to_date function, the date is set to the first day of current month.
Mika
|
|
|
|
|
Hello Friends,
How to create stored procedure in SQL Server 2005.
Please help me.
Thanks in advance.
Adarsh
|
|
|
|
|
CREATE PROCEDURE mySchema.MyProcedure
(
... Parameters go here ...
)
AS
... SQL Code Goes here ...
GO
|
|
|
|
|
Thanks for your reply.
can u have anything more. something like data types, how to declare variable, how to check condition. I am aware of Oracle Procedure. Is the same syntax or something different.
Please Help me
Adarsh
|
|
|
|
|
compad wrote: how to declare variable
DECLARE @myVariable int -- or what ever type you want.
compad wrote: how to check condition
IF @myVariable = 123
BEGIN
... Some SQL Code Here
END
ELSE
BEGIN
... Some other SQL Code here
END
compad wrote: I am aware of Oracle Procedure. Is the same syntax or something different.
You might want to read the documentation.
|
|
|
|
|
Thanks a lot
I got it.
Adarsh
|
|
|
|
|
hi, you have to download some tutorial first
nelsonpaixao@yahoo.com.br
|
|
|
|
|
Thanks for your help
If you have any link for tutorial. please forward it to me.
Thanks
Adarsh
|
|
|
|
|
compad wrote: If you have any link for tutorial. please forward it to me.
Can you not use a search engine? The search term "SQL Server Tutorial" will probably give you lots of links to helpful websites.
|
|
|
|
|
Hi Adarsh,
Open SQL Server
Create a database like "Test"
Open that database
You will find programability--open it you will find stored prtocedure.
Rite click ....select new stored procedure
A query window will come
paste ur SP and run
It will get added to your SP
For further questions mai me at jijuanair@gmail.com
Hope this helps
|
|
|
|
|