Denali – 2012

  1. Siva Manickam
    October 28, 2011 at 5:47 pm

    Hi Manoj,

    Could you please help me how to handle the the space in the sheet value ( Budget Administrative Code in the following example)

    SELECT *
    FROM OPENDATASOURCE(‘Microsoft.ACE.OLEDB.12.0′,
    ‘Data Source= C:\testing Country.xlsx;
    Extended Properties=”Excel 12.0″‘)…[Budget Administrative Code$];

    • October 31, 2011 at 5:02 am

      What do mean by space in sheet value & how do you want to handle it?
      Can you please explain.

  2. karthick
    July 30, 2012 at 6:29 pm

    how to use vb function to sql query function

    ex:
    function emp()

    str=”select * from employ”
    set rs=conn.execute(str)

    do while rs.eof=false

    for i= 1 to 6

    if sex=’m’ then

    update status=’male’ where empcode=’1000′

    else

    update status=’female’ where empcode=’1000′

    next

    loop

    end function

    • July 30, 2012 at 6:32 pm

      Check this:

      UPDATE employ
      SET status=’male’
      WHERE sex=’m’
      and where empcode=1000

      UPDATE employ
      SET status=’female’
      WHERE sex’m’
      and where empcode=1000

  3. Mayank
    December 26, 2012 at 7:57 am

    I am planning to prepare for SQL 2012 certification (Business Intelligence). Could you give me some idea how to setup the lab environment to cover 40-461, 462, 463, 466 & 467.I do not have access to server machines, so it would be good if you can provide me some info about simulating the environment using my desktop machine.
    Thanks.

  4. Nikki
    November 5, 2013 at 1:43 pm

    Hi Manoj,
    Ur website is having lot information.But i am new to work with sql server 2008 R2 and newly learning T-sql.. Could you please suggest me some books or some links where i can refer..

    Thanks

  5. Poonam
    February 7, 2014 at 9:58 pm

    Hi Manoj,

    I am writing to explore some volunteer opportunities in SQL Server. I have been unemployed for more than a year due to some visa issues. I am trying my best to get hands-on experience in T-SQL programming or Microsoft BI field while I am unemployed. Any inputs in finding online volunteer work related to SQL. I am also preparing for Exam 70-461 and would take the exam pretty soon.
    I would greatly appreciate your inputs in this regard.

    • February 10, 2014 at 12:33 pm

      @Poonam, thanks for writing to me and I really appreciate your dedication towards technology.

      As far as Volunteer work is concerned I’m not aware of any, but you can dedicate your time and knowledge on answering Questions on various forums like MSDN TSQL, SQLServerCentral, StackExchange, which will also let you learn new things and clear your doubts.

      Also you can start your own blog like this or volunteer by writing blog posts on beyondrelational, codeproject, etc. blogging forums.

      For preparing 70-461 you can check my blog post: http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/

      ~Manoj

  1. March 18, 2014 at 10:39 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 405 other followers

%d bloggers like this: