Ph: 96631224
Microsoft SQL Server
Microsoft SQL Server database RDBMS - Ask questions about MSSQL administration, queries, errors, xml, data access, transact-sql, tools, mirroring, integration, setup, stored procedures, merging and more.Views: 5,286 
Announcement: Only Q & A Threads Here
Announcement: Only Q & A Threads HereJuly 10th, 2008 msquared (Administrator)
Posting Guidelines
![[image]](http://mowser.com/img?url=http%3A%2F%2Fbytes.com%2Fimages%2Fdiscussion.jpg)
Post Reply? | Posted by: iam_clint | Last post by iam_clint, 667 days ago
Post Reply? | Posted by: iam_clint | Last post by iam_clint, 667 days agoPosting GuideLines Please follow these guidelines when posting questions. Submitting clear and concise questions allow those reading to understand... more »
sticky
How to store the result set in temp table
4 Replies | Posted by: rsrinivasan | Last post by ck9663, Today
4 Replies | Posted by: rsrinivasan | Last post by ck9663, TodayHi all, When i run below statement, i get some result set. But i want to store the results sets in some temp table. How can i store it? DBCC... more »
Deadlock Issue
Post Reply? | Posted by: irenedaniel | Last post by irenedaniel, Today
Post Reply? | Posted by: irenedaniel | Last post by irenedaniel, TodayHi Please see the update statements Update 1 and Update 2 below. The table "dataViewRequests" mentioned in the query is a high transactional table... more »
T-SQL: Recursion and circular references
Post Reply? | Posted by: balabaster | Last post by balabaster, Today
Post Reply? | Posted by: balabaster | Last post by balabaster, TodayHi, I have a couple of tables: Units( Unit_PKey Int Identity(1,1) Primary Key, Unit_Name nvarchar(8), Unit_Description nvarchar(32) ) more »
MySQL to MSSQL Conversion
Post Reply? | Posted by: chromis | Last post by chromis, Today
Post Reply? | Posted by: chromis | Last post by chromis, TodayHi, I wouldn't post such a lazy question usually but I've got to have this sorted for the end of the day, sorry! Could someone tell me how to write... more »
Encrypt and decrypt a full database in sql server 2005
Post Reply? | Posted by: rajmoghi | Last post by rajmoghi, Today
Post Reply? | Posted by: rajmoghi | Last post by rajmoghi, TodayHi, I am new to sql server 2005.i need to encrypt and decrypt my full database in sql server 2005.I gone through some sites,its saying that... more »
SQL Serial Data to Parallel
Post Reply? | Posted by: PeterSchwennesen | Last post by PeterSchwennesen, Today
Post Reply? | Posted by: PeterSchwennesen | Last post by PeterSchwennesen, TodayHi Hope somebody can help. The following is just an simple example of what I need to do. I am queering the Table "SomeTable" for "Number", "Type"... more »
SQL Installation
Post Reply? | Posted by: sibusiso | Last post by sibusiso, Today
Post Reply? | Posted by: sibusiso | Last post by sibusiso, TodayCan Anyone help I m want to install sql server 2000, when I run the setup I get the error "Windows cannot find x86\setup\setupsql" but the 'setupsql'... more »
get the jobs run in a particular time interval from sysjobhistory
Post Reply? | Posted by: mariasoosai | Last post by mariasoosai, Today
Post Reply? | Posted by: mariasoosai | Last post by mariasoosai, TodayI have to send the jobs status that are started running from the previous day 9.00 a.m to today 9 a.m from the table sysjobhistory in sql server... more »
Creating Reindex
3 Replies | Posted by: rsrinivasan | Last post by ck9663, Yesterday
3 Replies | Posted by: rsrinivasan | Last post by ck9663, YesterdayHi all, When should we execute dbcc reindex for a table? Thanks, more »
Comparing data in two different tables to find missing records
6 Replies | Posted by: jennifersalcido | Last post by ck9663, Yesterday
6 Replies | Posted by: jennifersalcido | Last post by ck9663, YesterdayHello All, I am working with two tables that contain inventory data: 1) INVENTORY contains item_number, description, etc. This data is relatively... more »
Is there a limit in retrieving foxpro file using VFPOLEDB ??
Post Reply? | Posted by: ck9663 | Last post by ck9663, 3 days ago
Post Reply? | Posted by: ck9663 | Last post by ck9663, 3 days agoselect dbf.*, 'fromfilename' as recordsource into x from OPENROWSET('VFPOLEDB','c:\my\full\path\';'';'', 'select * from mytable') dbf I have... more »
Update table name and all objects that reference it
4 Replies | Posted by: theJonster | Last post by ck9663, 3 days ago
4 Replies | Posted by: theJonster | Last post by ck9663, 3 days agoIs there anyway that a query could update a table name and all the objects that reference it. e.g table name is 'Blah' change to 'BlahBLahBLah' and... more »
passing a parameter to TOP when getting random data
2 Replies | Posted by: crazyfisher | Last post by Preterani, 3 days ago
2 Replies | Posted by: crazyfisher | Last post by Preterani, 3 days ago> Dear all, > I am trying to write a stored procedure for a recipe database so that the > user can choose how many recipes from what category. > I... more »
SQL 2005 Express
Post Reply? | Posted by: oasismas | Last post by oasismas, 3 days ago
Post Reply? | Posted by: oasismas | Last post by oasismas, 3 days agoI have a problem with Sql 2005 Express. I used Windows XP and VB6 (for my program) and database use Sql 2005 Express. Now for stand alone I have... more »
Database size shows huge
4 Replies | Posted by: rsrinivasan | Last post by rsrinivasan, 4 days ago
4 Replies | Posted by: rsrinivasan | Last post by rsrinivasan, 4 days agoHi all, I am using SQL Server 2000. My actual database size is only 19GB. But .mdf file shows 170GB. How can i reduce it? Thanks, more »
Query for displaying a particular set of data
9 Replies | Posted by: Raman Pahwa | Last post by Raman Pahwa, 4 days ago
9 Replies | Posted by: Raman Pahwa | Last post by Raman Pahwa, 4 days agoHi, I have a table with fields number,category,date and if i want to choose numbers of a particular category and date. then the query will b select... more »
get latest date record
1 Reply | Posted by: SunshineInTheRain | Last post by ck9663, 4 days ago
1 Reply | Posted by: SunshineInTheRain | Last post by ck9663, 4 days agoI have a log table. I want to get record of latest date. Meaning if 1-May-2008 13:32:22 and 1-May-2008 2:22:21, it will retrieve 1-May-2008 13:32:22... more »
Top Microsoft SQL Server Contributors
You are viewing a mobilized version of this site...
View original page here
