dear all, please help me with this query that i still can't find the right solution i have this query to generate a xml file: declare @output xml;...
Dear All, Sorry, if this post is in the wrong section (i don't know where to put it), so i put the question in the General DBA Section... Today, when...
Dear All, Do u have any recommended article or link for me to find a way to execute a SSIS package using xp_cmdshell syntax?? Please ur suggestion...
Dear All, I want to change a compatibility level for choosen database using syntax "sp_dbcmptlevel". Our database had been migrated from 2000 to...
dear all, need ur suggestion about this case... I have to create table with condition there is no duplication for five columns all at once. I...
Dear All, I have a table which has 41 columns, with the last 4 columns are system generated datetime column. Due to user needs, I have to add 27...
Dear All, I have a little question for u guys...please help because i'm newbie here. In our database, we have nullable field that categorize...
Hi All, I just want to know what does it mean by putting a word "N" in query such as: select * from information_schema.tables where [table_name] =...
hi all, maybe my question had been answered in this forum, so if anyone can direct me an answer or a link to me... how to know who is creating the...
hi guys, i've tried to select data from a table from another database in another machine using ODBC first, i've created a ODBC connection (with DSN...
Dear All, How to delete a linked server? Here, We have a two servers which had been linked with a main server using sql syntax sp_addlinkedserver....
Dear All, I'm using in SQL Server 2005 Express Edition in my local pc. But when I use ROW_NUMBER() function, an error occured saying like this: Msg...
Dear All, Urgently need a help with this, I want to import a flat file (text file) into a table. In the executing process, suddenly there is an...
Dear All, Need informaton about, what is the difference of the result when i implemented these two conditions: 1. i create an clustered index for...
Dear All, Just say, i'm using the free SQL Server Express edition 2005 to connect to database in a server. In server, we're using SQL Server 2000...
Hi All, Can I make a table name as a variabel in a stored procedure. Like below example create procedure MyProc @yr INT, @table_name varchar(20)...
Dear All, Can you help me with this case... I have a row data, for example as below vin call_datebook_catgshow_catg...
hi guys, please help me with this case: I have a large table about vehicle, with more than 3 million records. As the business grows, my boss...
Dear All,<br /><br />How to use a TOP statement in the stored procedures? <br /><br />the syntax is similar like this:<br /><br />select TOP N...
Separate names with a comma.
