what is difference between primary key and Unique8 4244
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????3 6250
HOW TO RENAME A COLUMN NAME3 4449
what is cluster and nin-cluster index?4 3599
What are different types of Keys? Please explain all the keys with a suitable example.4 23259
What is row by row processing ?2 5894
can primery key be a non clustered index?10 6946
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.1 3818
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?4 6489
How to find out name of all employees who has salary less than 200 Rs.?8 4537
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.1 2052
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
tell me the disaster recovery plan
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
what is package and it uses and how can u call a package
You are doing log shipping due to some reasons it is failing. How you will proceed from there
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
where the connection string store in the database
Why we need to use secondry database file? though, we can do same work using primary database file also.
Which is the best place or learning center for MS SQL?????In Bangladesh?????
wat wil hapn if we give the both read and deny read permission to user?
How to trouble shoot if unable to connect SQL Server
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.