=========================== contact serverteam@... witha brief summary of your SQLserver DBA skills and why you want to help if you want to volunteer...
Hello Every One. What are the steps to create a Sql-Server2000 user having username & password to log on. User should have only read privilege over all tables ...
Hello Every One. What are the steps to create a Sql-Server2000 user having username & password to log on. User should have only read privilege over all tables ...
Hi, This is my first mail to this group... I have a question .. These are regarding the SQL Server 2000. . Can we call a stored procedure from a stored...
Dear all, Actually I just would like to ask regarding update , can we update many columns at same time because most of example I saw only one column at...
How to merge these 2 into a single: query 1: UPDATE I_LIMIT SET [cycle no] = "US0010001" WHERE USERNAME LIKE '*1' or USERNAME LIKE '*2'; query 2: UPDATE...
Hi, What is the advantage of using oracle instead of xml to store data for applciation development. Currently i am doing a project to implement the ERP, but i...
Dear all, I just started to learn sql. I don't know how can I become a good database handler. Can anyone help me. Thanks and regards, Narendra Send instant...
Hi alllllll i am using oracle and need to store images in a field named pic having raw as datatype how is it possible only through oracle's own interface (SQL...
hi all i want to delete duplicate records from a table. there is no unique key in the table and the problem is in the SQL Server 2000 its possible in oracle...
hello every one i want to know how should i use dynamic table name to get data from the table like i want user to select name of the table & my query should...
Hi Friends, I am new to this group. I need urgent help from you . Its very urgent (S#, SNAME, STATUS, CITY) PRIMARY KEY (S#) P(P#, PNAME, COLOR, WEIGHT,...
heck MUST be recieved via fedex by Dec 20th for amazing offer below! (only 4 seats left at this price in C# class, 6 in VB.net class, first come first served) ...
Hi, I want to know is there any query or sub-query for counting the number of columns in a table. I used:: select count(*) from(describe table products) It...
Hi, I want to know is there any command or method in java so as to list the tables in given database using java.sql or anyother package Thanks, Vinod K...
Hi Team, Is there a way to update one particular field in 1000's of tables have a common field called OPRID, and the value is OPRID='XYZ', now we want to...
any idea why this would cause a type mismatch ? UPDATE Empsked SET empsked_starttime = '9' WHERE empsked_day = '1' AND empsked_id = '1'; Im 99.9999% sure that...
I am using Access/JET SQL. This sql gives me a list people who submitted quizzes that need to be manually graded. SELECT a.ID, c.Fname + ' ' + c.Lname,...
Since an MD5 hash is 128-bits, when it's inserted into an MS SQL database field, assuming the hash is not salted, then it would be equal to 16 characters using...
MS SQL Server In a stored procedure, I want to pull data from one table if the user id exists there. If it doesn't, I want then to check a second table. So I...
