Dear My Friends,I have a question... If i use the following syntax...SELECT * FROM TableName WHERE LEFT(Field,3)The result is 'J10' for all records....
Hello My Friends, I want to know the SQL Syntax to find the duplicate value in one field of Table. Anybody can help me...? Thank you.
Hello My Friends, I have a field with data type is INT (YES NOT FOR REPLICATION). This field is PrimaryKey. Right now, it almost the end of the...
Oh please... Damn, It's so simple, [:P] Anyway, thanks very much... [<:o)]
Hello My Friends, I'm a new member in TechRepublic. I have a question, about SQL Script. I'm Using SQL Server 2008. I have one table, contain 3...
Hello Ravi, Thank you... that's very interesting... By the way, the procedures running and it reduce the LDF. But, after i execute it... there's an...
Thanks very much, really help me... [8-|]
If you don't mind... Could you give a step by step please...? [:)]
Dear My Friends, I have a question... I just assign a backup schedule to one of database in my server... How can i remove the schedule from the...
Hello My Friends, I'm newbie in SQL... [:P] I have one database, the size of MDF file is only 21 MB. But The LDF File is almost 200 MB. Why...? Is...
Thanks for your explanation. Very Clear. [:)] I willl backup while users not connected to the database.
Hello My Friends, I have a question about manual backup of sql server 2K database. I have a database. Some users connect to the database via an...
Hello Brothers... [H] if i have manual backup day by day and backup file sort by backup date. I'm really sure the backup file can't be updated...
Hello My Friends, Thank for all. I really understand about your post. But, if i want to restore the previous backup... Let say, 3 days after the...
Thanks for replying my post, I create a database, letsay dbTest... dbTest has one table, Table1. Table1 has 2 Fields, 1. Item -- Varchar(50) 2....
Dear My Friends, I have a question about backup database. i have been create a database and running for more than one month. Suddenly, i have to...
Dear My Friends, I have a question... How many field in table can be inserted? I using Microsoft SQL Server 2000 Thanks & Regards, Fauzan
Thanks for replying my post. I using Real Data Type. Thanks.
Dear All, I have a question about digit on decimal number in Microsoft SQL Server 2000. I creating an application. If i input 0.956 from the...
Separate names with a comma.
