Sir, Just make a try with identity column (seed value 0,1) - To check whether the problem is with auto generation. Whether you are trying...
Unique Key constraints: Unique key constraint will provide you a constraint like the column values should retain uniqueness. It will...
Introduction Stored procedures are special objects available in sql server. Its a precompiled statements where all the preliminary parsing...
Introduction This article deals with parsing techniques involved in executing the sql server query. Nowadays, stored procedures forms a strong...
Shabbir, I think you dealt only with list collection. I will try to post my articles on other .net collections. Regards, Venkatesan Prabu. J
Problem may be due to the statistics collected by the search engine. or invalid data stored in the database so that data get replicated with...
Create a stored procedure with update statement in it. You can send the arguments to the stored procedure and execute it from the front end...
Will give you suggestions in sql server You can opt collation property to solve this problem. Regards, Venkatesan Prabu. J
If we issue select statement with order by clause, My database engine will search for the table in the database using the hierarchy...
Yes if we try to execute any program, the execution will happen in the RAM. Cursors will stay in the ram but in a seperate sql server application...
1. Database provides a structured way of arranging datas instead of storing in irregular way 2. Logical and physical grouping and faster...
The path should be jdbc:microsoft:sqlserver:Your Ip address:1433;Your Database Name Regards, Venkatesan Prabu. J
Separate names with a comma.