Published by: Farhan Ahmed (11/21/2008 4:27:41 AM)
I am facing lots of trouble finding common columns of two tables as I am in Banking sector. there is huge amount of data tables are in here ... as a new comer it is really diffcult to adjust and find common columns to match two tables . so how should this possible to find columns from table?
Comment (4)
Published by: Peter (11/12/2008 1:01:49 PM)
I want to add a column from my asp code, I don’t want to use it at the end of the list. I also don’t want to use the SQL Server Management Studio to achieve this. If you can let me the sample code to write by which i can insert a column anywhere i feel like then that will be great.
Comment (0)
Published by: Matt (11/10/2008 3:57:49 PM)
I want to block clients on their ip address for security reasons but i don’t know a way by which i can stop the unauthorized ips to access the sql server 2005. I don’t see any options in SQL Server Management Studio 2005. Please help me to configure this.
Comment (0)
Published by: Riya (11/6/2008 10:21:28 PM)
I am using sql server 2005 as my database. I want to write a query where i will update 2 tables. Can I write a query to update both the tables in one connection? I read in many places and it seems that i have to use stored procedure to do this but i don’t want a stored procedure. If you know a trick or method to achieve this then let me know.
Comment (0)
Published by: Rinku (10/25/2008 1:10:19 AM)
I dont really understand the major differences between a STRING Data type and Text Data type in SQL Server. Most operations that can be done with strings can be done with text data type too. Can anyone advise practically where to use a string data type and where to use Text data type. Which of them is better for performance issues.
Comment (1)
Published by: Guest (10/9/2008 10:42:12 PM)
Can i run both the server that are sql server 2000 and sql server 2005 at the same time? I guess i can run but how they run when they both gonna use 1433 as the port, if i don’t change it in the configuration. I have it running and i am guessing how it is happening.
Comment (0)
Published by: Guest (10/7/2008 3:39:30 PM)
I deleted my production sql server database accidentally, I have no clue how to get back all my data. My website is down now as it was working on the top of this database. Pros here please help me in getting back my database so that i can get my website live. Any help will be highly appreciable.
Comment (0)
Published by: Guest (9/27/2008 11:34:38 AM)
I added a new column to the existing table and set it to not null but i am getting error and not able to get my desired result. Any one knows why i get this error? ’table_name’ table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ’column_name’, table ’database.dbo.Tmp_table_name’; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Comment (0)
Published by: Guest (9/27/2008 11:12:52 AM)
I used sql server management studio to import data from xl sheet and create some indexes. I could only create a primary key and failed to create any other indexes. I got this error while trying to create an index: ’table (dbo)’ table
- Unable to create index ’IX_table’.
There is insufficient system memory to run this query.
The statement has been terminated.
Comment (0)
Published by: Rinku (9/21/2008 10:22:47 AM)
I want to know what are all the tables present in a particular database. What is the SQL command to list all tables in a database in SQL Server. I want system tables to be filtered by the query and return only user created tables present in the database.Please Help.
Comment (0)