I don't know... That's a good question. I will check it first. Thanks!

Have a nice day!

Hello! Is it possible to get the SID of the user last wrote to a file? I am able to get the owner of a file, but I can't find how to get the user that last wrote to it. Does anyone know how I can do it? Thanks in advance!

Have a nice day!

Hello! Maybe anyone knows if it is possible to get in C# the SID of the user created a file or folder? (Maybe CreatorOwner) Thanks in advance!

Have a nice day!

Hello! I have a table which has a text column. I need to modify this column for all rows that begin with some text. How can I do it? Thanks in advance!

Have a nice day!

Thank you!

Have a nice day!

Why do I need the SELECT? Won't WHILE(SUBSTRING(@strvar, LEN(@strvar), 1) NOT LIKE '\') work?

Have a nice day!

Alright, now I try to compare it to a '\' using LIKE, and it never works. How can I check if this character is '\' or not?

Have a nice day!

My problem now is getting the last character of a ntext variable. I do it this way, but it doesn't seem to work: SUBSTRING(@strvar, DATALENGTH(@strvar), 0)

Have a nice day!

Hello! I am writing a stored procedure, and in my stored procedure, I need to work with a string. I found some functions in SQL: DATALENGTH, and SUBSTRING. But I can't find information about how to work with strings in SQL. What I need is to walk through a string, exemine every character and make the string smaller depending on the characters. First, how can I compare ntext strings? And, second, maybe there are more string functions in SQL? Thanks in advance!

Have a nice day!

Found an example by googling. Thanks!

Have a nice day!

Can you give me a simple example? I would be very thankful...

Have a nice day!

Hello! I need to write a stored procedure that will make a query, and then return a value depending on the query result. My question is how can I store the query results inside the stored procedure for me to be able to examine them and then return an appropriate result? Thanks in advance!

Have a nice day!

Solved the problem. I'm using EXEC instead of an explicit INSERT.

Have a nice day!

Hello! I am writing a stored procedure that should insert a row in a table that it's name is sent to it as a parameter. I do it this way: CREATE PROCEDURE myProcedure @tablename ntext, AS INSERT INTO @tablename(...) and I get an error "Must declare the table variable "@tablename"". What should I do? Thanks in advance!

Have a nice day!

Thank you very much!

Have a nice day!

Thank you very much! Just one more question: If I decide to write a stored procedure, where do I store it? When you write "cmd = new SqlCommand("sp_Test", conn);", how will SQL Server know what "sp_Test" is?

Have a nice day!

Thanks! I hope I will manage with returning the value in SQL. Thanks again!

I don't know yet, but I know that depending on some data in the db, it should return true or false.

But, can I get a return value from the DB using SqlCommand?

Hello! I am writing an application that works with a SQL Server DB, and what I need is to send some info to the DB, and get a true / false answer from the DB. I was working always with SQLDataAdapter, but I don't need a SELECT query, but actually an answer (like return in c#). How can I do it in C#, and what kind of query should it be? Thanks in advance!