What is a NOLOCK?3 17064
How do SQL server 2000 and XML linked?2 5946
What is the difference between HAVING clause and the WHERE clause?7 11770
how to know description of a table in sqlserver 20008 5960
How to Execute an Operating System Command From Within SQL Server ?3 5535
How can I create a plain-text flat file from SQL Server as input to another application?2 8865
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?3 6387
The Difference between 'Count' and 'Count(*)'13 16964
How do I list the available tables in a database I'm querying?4 3810
How to count the number of duplicate items in a table?3 5447
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?2 3093
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?
Is it possible to create tables in stored procedures using a variable for the table name?2 3165
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.
If a stored procedure is taking a table data type, how it looks?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is RMS migrations?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
what is package and it uses and how can u call a package
your distribution database is full what will u 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
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Delete duplicate rows without using rowid.
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How retrieve field names from the table in SQL through JAVA code?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Why we need to use secondry database file? though, we can do same work using primary database file also.