Search:
Type: Posts; User: kaffenils
Search:
Search took 0.14 seconds.
-
Are you thinking about the WITH ENCRYPTION option. Ref http://msdn.microsoft.com/en-us/library/ms187926.aspx
Specifying WITH ENCRYPTION in the CREATE PROCEDURE statement will render the procedure...
-
select * from sys.databases
select * from <dbname>.sys.tables
sp_help 'tablename'
-
The only thing that you should be concerned about is the fact that SOUNDEX causes table/index scans, which of course will hurt performance depending on the number of rows in the table. If you want to...
-
As long as you have an index that contains the column you are SOUNDEXing, and that index is smaller (in # of pages) than the clustered index/table heap, then it is much cheaper for SQL Server to do a...
-
I agree that putting an index on a large column is really not a good thing, and I don't know the size of this column. It could be 50 chars or 8000 chars. And an index has a size limit of 900 chars.
...
-
The structure of an MDF file is not really a secret.
But back to your problem with the missing log file. You can attach a database and have SQL Server create a new log file.
...
-
Are you sure you're not confusing index scan with index seek? Index seek is the "good" way, in which SQL Server will do lookups in the node and leaf structure. A scan on the other hand will read the...
-
This is probably because the data in Oracle is unicode.
Use adWLongVarchar (or was it adLongWVarchar) instead.
-
@vuyiswamb: Two things come to my mind.
#1: Parameter @Letter is char(2), but your left/right/substring returns only one charachter. How can that work properly?
#2: Once you start using...
-
As others have stated, it's a pain in the ass on SQL Server 2000.
As I see it you have to options.
1. Create a new column (for temporary storage) with the same data type as the existing. Copy...
-
-
Can you post the dat ayou insert, and the sql you run that fails to work.
-
-
What you want to do is create a Multistatement Table-valued Function.
The function returns a table representing the splitted values, and you reference it as any other table in an INSERT statement.
-
No, no, NO. Never build dynamic SQL statements like this. You are opening up your system to SQL injections. ALWAYS use parameterized queries.
http://imgs.xkcd.com/comics/exploits_of_a_mom.png
-
Are you kidding me??? What is the title of this major subject? I really hope it has nothing to do about computer science, for your sake.
-
create login edgarbenilde with password=N'mysecretpassword'
This will create a login but will not grant access to any databases.
To create a database user for the login you just created you...
-
You'll have to set the database to allow EXTERNAL or UNSAFE asseblies. Take a look at those keywords in BOL.
-
It's not unreliable if you use proper locking and isolation level.
Use SERIALIZABLE to protect against other inserts in the range when you get max(columnname). Also put a UPDLOCK on the...
-
Don't think there are any built-in features in SSMS.
You can build a program that scripts out the schema and creates INSERT statements for all the data. The "problem" is that you will have to...
-
It is not stored anywhere.
-
If the interviewers asked for a query that would return the sequence in the "natural" (meaning the original sequence that the data was inserted) order, they have absolutely no clue of how SQL Server...
-
The question is pretty simple as I see it.
"Number in order" means ascending. SQL Server has no knowledge of what rows where inserted first or last, so "number is original order" is impossible to...
-
Put the variable @xNoOfRows in parenthesis:
select top(@xNoOfRows)
-
There are no MS shipped tools to do this, but 3rd part products exists. For example http://www.lumigent.com/products/le_sql.html
-
Can you execute
set showplan_xml on
.. your sql here
and post the xml output.
Also execute
-
Show us the code that builds the strTrigger text. I suspect that you are missing some spaces or line breaks.
-
If we're talking about SQL Server you can kill a spid by using the KILL statement, or if you want to kill all users you can execute
ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-
If this is SQL Server 2005 Express you must also give the instance name SQLExpress in the "server" property:
SqlConnection("server=localhost\SQLExpress;database.....")
-
I did a little test (why didn't you think of that:D ) on how CAST rounds the value, and it seems like it rounds it correctly.
select cast(1.233 as decimal(25,2))
returns 1.23
select...
-
This tutorial should get you started
http://www.vbforums.com/showthread.php?t=366078
No cursors are involved, and the number of loops is equal to the depth of the thread.
-
Bad idea.
XML has five special characters and the are <>"&'
You don't replace them with empty string. Instead you use the defined escape characters.
strValue = strValue.Replace("<", "<")...
-
How is data in your exmplae related?
-
As brucevde says, there are no arrays in sql server. I have used xml when I've needed arrat functionality.
-
You could try, but I'm pretty sure the limit is per database, not per file.
-
Full backup=Backup of the whole database.
A transaction log file is split into several virtual log files.
In FULL and BULK_LOGGED recovery model, the transaction log must be backed up in order...
-
You are correct that PATH is a reserved keyword in SQL Server 2005. I originally wrote the script for SQL Server 2000 where it is not a keyword.
-
Path is just a column name. You can name it blablabla if you like.
-
You use the log backup if you need to restore the database to a specific point in time. You also need a full backup in order to be able to restore log backups.
-
Use single quote ' instead of double quote " in the file name.
|
Click Here to Expand Forum to Full Width
|