Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?1 4424
How do I compare two values when one value(data type) is char and the other is an integer?3 6034
What are the pros and cons of creating extended stored procedures?1 3918
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?1 4924
How to Check Whether a Global Temporary Exists in a SQL Database or not?2 5726
how to know Who Is Blocking Your SQL Server?4 8885
How to Get the last identity value used4 5389
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?1 3665
How to Run a Query on a Remote SQL Server?2 6191
How to Generate a Series of Random Integers With T-SQL?1 3013
What is normalization?9 6838
What is a Stored Procedure?8 6581
Can you give an example of Stored Procedure?4 6993
How we create SQL Server 2005 Reporting Services ? Give me Sample
how can u get last observation in an unknown dataset ?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
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
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
how to take backup bcp out for a column in table in sql server?
How do you Implement SSIS Packages in your Project?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is the difference between NOROW and LOCKROW?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
Does any body please help me what question's have asked for SSRS in the interview?