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
Will give you an optimal solution for this. Just make a try like this. Have your login username and password in query string along with the...
In Machine.config file you can store, 1. Connection strings 2. Membership 3. RoleManager 4. Profile 5. HttpHandlers Its like a...
Window Application: It has rich GUI and to be installed specifically in a machine for execution. But this drawback is resolved using click...
Make a try with this code String strSQL = "Select Count(*) From Authenticate where UserId =+”’John’” + and Password =+”’Password’”;";...
Virtual Directory: This enables the application to get exposed to the external environment. If some one in the intranet needs to access the...
Just make a try with the below code sir, you should not use 'AS' keyword like Stored procedure CREATE FUNCTION dbo.myFunction1() returns...
Yes you can achieve it using SQL server Login credentials. Create your own user in your machine (SQL server user authentication) and use the...
SQL Server is considered as most powerful environment for the Microsoft front end tools like VS. Venkat
Separate names with a comma.