xp_fileexist workd in Query window but doesnt in stored procedure
Hello,I am running on SQL server on my local PC . I am singed onto the PC using a network user.This probelm happens if the SQL server service runs as either Local system or network service.In the server management studio if I go to a query window and enterDeclare @result intexec xp_fileexist...
Answer Question
| Jun 26 2008 1:59 PM GMT
| asked by
Kendo
MS SQL, Stored procedures, SQL error messages
Random number generation
Hi, I have a 6 digit number. I need to make this as a 10 characters with those 6 digits within it. For eg, if my input number is 123456, the result should be a4y2d365p1. some combination of characters with the original 6 digit numbers. Please do let me know if this could be done by any ways..
View Answer
| May 18 2008 6:44 PM GMT
| asked by
Coolgirl04
MS SQL, SQL, Random Number Generator
using a local variable to build an sql-statement beyond datatype nvarchar(4000) and execute with sp_executesql
I build a sql-statement and put it in a local variable so i can execute it using sp_executesql, but a local variable cannot be a text or ntext data type, and a varchar data type cannot be used by sp_executesql. So the maximum lenght of the statement cannot be more than nvarchar(4000)...is there any...
View Answer
| Feb 6 2008 4:59 PM GMT
| asked by
Aabbccddee
SQL, MS SQL
rows to columns
I have a table containing answers from different forms. the forms are created dynamically so some forms will have 3 answer fields, some will have as much as 20 answerfields.ex : form_id field_id unique_id field_value1000 631 1 john doe1000 ...
View Answer
| Feb 5 2008 2:04 PM GMT
| asked by
Aabbccddee
MS SQL, SQL
MS SQL and IBM BLADE
Is MS SQL compatible with IBM Blade HS21?
View Answer
| Nov 22 2007 10:53 AM GMT
| asked by
Darqtanian
IBM Blade, MS SQL
