How to loop through result set objects using mssql_fetch_array()?
How network traffic be reduced by using the stored procedure?
How many clustered indexes there can be on table ?
can a database be shrunk with users active? : Sql server administration
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is sql server profiler?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Explain what is cte (common table expression)?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
What will happen if a column containing char type data is changed to the nchar data type?
How much is a sql server license?
What are the advantages of using cte?